Answers to Chapter 16

Reviewing It

1: What does TOAD stand for?
A1: Tool for Oracle Application Development
2: Where can I download the current version of TOAD?
A2: www.toadsoft.com
3: Where do you access the single record viewer?
A3: Any window that displays data
4: What is the Schema Browser useful for?
A4: Allows you to quickly find and edit various Database objects.

Checking It

1: Is TOAD strictly a development tool?

Yes/No

A1: No, it does many DBA functions as well
2: When TOAD starts up, this window comes up first:

  1. SQL Modeler

  2. SQL Editor

  3. SQL Procedure Builder

  4. SQL Schema Browser

A2: b
3: TOAD only works with SQL and PL/SQL.

True/False

A3: False, TOAD also interfaces with other code development tools such as VB, Java, C++, or Delphi
4: How many different ways are there to get code into the Procedure Editor?

  1. 1

  2. 2

  3. 4

  4. 6

A4: b, read from a file or load from the database.

Applying It

Independent Exercise 1:

  • Build a simple SQL query, logged in as SCOTT, using the EMP and DEPT tables.

    • Display the results.

    • Model the SQL relationships.

    • Show an explain plan.

    • Change some salaries one row at a time.

Independent Exercise 2:

  • Add a new user.

  • Grant this new user the same privileges as SCOTT.

Independent Exercise 3:

  • Build a POST-INSERT trigger on the EMP table.

    • Have it make sure the DEPTNO code is in the DEPT table.

    • Have it loop 10 times, updating a variable by 10 with each loop.

  • Set a break point just inside the loop.

    • Check the value of the variable with each loop.

Independent Exercise 4:

  • Using the Schema Browser, see if EMP has any procedures.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.222.125.171