Free Oracle 1Z0-052 Exam Dumps Questions & Answers

Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

• A.when the tablespace contains undo data that is needed to rollback an uncommitted transaction
• B.when the tablespace contains a table that is currently being used by transactions
• C.when the tablespace is a default permanent tablespace for the database
• D.when the tablespace is online
• E.when the tablespace has segments with data in it

Examine this LISTENER.ORA file:

How should you configure and start an additional listener LISTENER2 that listens for the same SID?

• A.Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA
• B.Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it
• C.Add relevant details in DESCRIPTION under the existing LISTENER with a different port number in LISTENER.ORA
• D.Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER.ORA

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

• A.Inactive and current redo log files are required to accomplish recovery
• B.Online and archived redo files are required to accomplish instance recovery
• C.All redo log entries after the last checkpoint are applied from redo log files to data files
• D.All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
(Choose two.)

• A.The ADDM analysis provides only diagnostics information but does not provide recommendations
• B.The ADDM calls other advisors if required, but does not provide recommendations about the advisors
• C.The ADDM requires at least four AWR snapshots for analysis
• D.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
• E.The ADDM runs after each AWR snapshot is collected automatically by MMON

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

• A.The ORDERS table is dropped along with the ITEM table.
• B.The dependent referential integrity constraints in the ORDERS table are removed.
• C.The dependent referential integrity constraints in the ORDERS table are disabled.
• D.No flashback is possible to bring back the ITEM table.
• E.The table definition of the ITEM table and associated indexes are placed in the recycle bin.