A.The data dictionary is created and maintained by the database administrator.

B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.

C.The usernames of all users including database administrators are stored in the data dictionary.

D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.

E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.

F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

A.The TRANS_VALIDITYcolumn would have a maximum size of one character.

B.The CUST_CREDIT_LIMITcolumn would be able to store decimal values.

C.The TRANS_DATEcolumn would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

D.The CUST_STATUScolumn would store exactly one character.

E.The CUST_STATUScolumn would give an error.

F.The TRANS_VALIDITYcolumn would give an error.

A.when a PL/SQL anonymous block is executed

B.when a DELETE statement is executed

C.when a ROLLBACK command is executed

D.when a data definition language (DDL) statement is executed

E.when a TRUNCATE statement is executed after the pending transaction

A.It will return rows that are not common to both SELECT statements.

B.It will return rows from both SELECT statements including duplicate rows.

C.It will return rows from both SELECT statements after eliminating duplicate rows.

D.It will return rows common to both SELECT statements.

A.A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to create a unique index.

B.Indexes should be created on columns that are frequently referenced as part of any expression.

C.When a table is dropped, the corresponding indexes are automatically dropped.

D.For each DML operation performed, the corresponding indexes are automatically updated.