3.7. Review Questions

  1. Which of the following statements about tablespaces is true?

    1. A tablespace is the physical implementation of logical structure called a namespace.

    2. A tablespace can hold the objects of only one schema.

    3. A bigfile tablespace can have only one datafile.

    4. The SYSAUX tablespace is an optional tablespace only created if you install certain database options.

  2. Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?

    1. The whole storage clause

    2. NEXT and PCTINCREASE

    3. BUFFERPOOL and FREEPOOL

    4. PCTFREE and PCTUSED

  3. Which objects share the same namespace and therefore cannot have the same name?

    1. Tables and indexes

    2. Tables and procedures

    3. Tables and constraints

    4. Tables and triggers

  4. Which is not a type of segment that is stored in a tablespace?

    1. Undo

    2. Redo

    3. Permanent

    4. Temporary

  5. With which parameters do you specify unlimited datafile growth?

    1. MAXSIZE UNLIMITED

    2. UNLIMITED GROWTH

    3. MAXEXTENTS UNLIMITED

    4. Datafile size cannot change.

  6. Which of the following is not a character datatype that can be used in a table column definition?

    1. char

    2. varchar

    3. nvarchar2

    4. string

  7. With which numeric datatype can you represent infinity?

    1. double

    2. float

    3. binary_float

    4. Infinity cannot be represented in the database.

  8. A table name can never include the special meta-character dollar sign ($).

    1. True

    2. False

    3. Only if the table name is enclosed in double quotes

    4. Only if the table name is enclosed in single quotes

  9. Which of the following column specifications results in a column that will store time values down to the microsecond decimals of precision?

    1. timestamp(3)

    2. time(3)

    3. datetime(3)

    4. date(3)

  10. Which type of index can specify as a unique index?

    1. Bitmap

    2. Heap organized

    3. Btree

    4. XOR

  11. Which operation can you not do to a table that is created with the following SQL statement?

    CREATE TABLE properties
("Location"  NUMBER primary key
,value       NUMBER(15)
,lot         varchar2(12)
,constraint positive_value check
   (value > 0)
);

    1. Rename the primary key to properties.

    2. Insert a null into the value column.

    3. Add a column named owner.

    4. Rename the index supporting primary key to properties.

    5. None of the above.

  12. Which of the statements is true regarding the table created with the following SQL statement?

    CREATE TABLE autos
(vin         VARCHAR2(64) primary key
,style       VARCHAR2(15) default 'TUDOR'
,year        char(4)
,make         varchar2(12)
,model        varchar2(30)
);

    1. MAKE is a reserved word; the CREATE TABLE will fail.

    2. The column style will always have a value.

    3. There is no index on this table.

    4. The column style can have a NULL value.

  13. Which constraint-checking model is the default?

    1. Initially immediate and deferrable

    2. Initially immediate and not deferrable

    3. Initially deferred and not immediately

    4. Initially deferrable and not immediate

  14. Which statement on views is true?

    1. A view can only be on one base table, although that base table can be joined to itself.

    2. A view cannot be created with the same name and columns as the base table.

    3. Inserts into a view are not allowed.

    4. Privileges on a view can be different from those on the base table.

  15. What can tablespaces be used for?

    1. To organize tables and indexes into manageable groupings

    2. To make sure that data stored in the tablespace does not change

    3. To move data from one database to another

    4. All of the above

  16. Which allocation unit is the smallest?

    1. Datafile

    2. Extent

    3. Data block

    4. Segment

  17. Which is a valid tablespace extent management specification?

    1. Automatic

    2. Local

    3. Manual

    4. Temporary

  18. Which of the following is not a valid Oracle10g datatype?

    1. timestamp with local timezone

    2. binary

    3. blob

    4. urowid

  19. How do you specify that a temporary table will be emptied at the end of a user's session?

    1. Create the temporary table with the ON COMMIT PRESERVE ROWS option.

    2. Create the temporary table with the ON DISCONNECT PRESERVE ROWS option.

    3. Create the temporary table with the ON DISCONNECT PURGE ROWS option.

    4. Create the temporary table with the ON COMMIT DELETE ROWS option.

  20. How can you change the comment assigned to the columns in a table?

    1. Use the ALTER TABLE MODIFY COLUMN statement.

    2. Use the COMMENT ON TABLE statement.

    3. Use the RENAME statement.

    4. Use the COMMENT ON COLUMN statement.

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

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