Oracle 1Z0-082 valid exam dumps : Oracle Database Administration I

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

• A. The high-water mark (HWM) of orders is adjusted.
• B. Dependent indexes become UNUSABLE.
• C. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
• D. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.
• E. Only queries are allowed on ORDERS while the shrink is executing.
• F. Queries and DML statements are allowed on ORDERS while the shrink is executing.

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A. The LREG process registers services dynamically with the LISTENER_1 listener
• B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
  1521 on the same host as the database instances
• C. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
• D. Dynamic service registration cannot be used for this database instance
• E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

• A. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
• B. SELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• C. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• D. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• E. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
• F. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

• A. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
• B. DBA_DATA _FILES displays both the new name and the old name for the data files.
• C. DBA_DATA_FILES displays the original name for the data files.
• D. V$DATAFILE displays the new names for the data files.
• E. DBA_DATA_FILES displays the new name for the data files.

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A. The primary key constraint will be enabled and deferred.
• B. The foreign key constraint will be enabled and immediate.
• C. The foreign key constraint will be enabled and deferred.
• D. The foreign key constraint will be disabled.
• E. The primary key constraint will be enabled and immediate.