Checking It

1:An ERD crows foot pointing towards an object means:

  1. The table with the crows foot is a subset of the table at the other end

  2. The table with the crows foot has a 1-to-many relationship with the other object

  3. The table with the crows foot has more rows than the other object

2:A straight line in an ERD diagram indicates a one-to-one row relationship between the two objects.

True/False

3:Creating multiple tablespaces is useful for:

  1. Tuning the application via distribution

  2. Aid in moving the application to larger computer systems

  3. Allows for different storage parameter defaults

  4. All of the above

4:Is SQL*Plus the only tool useful in creating database objects?

True/False

5:What is the purpose of :new.inv_insert_user := :old.inv_insert_ user; in the Listing 4.3.

  1. To insure the contents of the INV_INSERT_FIELD does not change

  2. To force the INV_INSERT_FIELD to a new value

  3. To allow for other processes to change the INV_INSERT_FIELD

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

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