1Z0-052 무료 덤프문제 온라인 액세스

You want to audit update statements that refer to USER1.DEPT.DNAME.
Which type of auditing must you use?

• A.value-based auditing
• B.fine-grained auditing
• C.standard auditing
• D.mandatory auditing

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

• A.It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
• B.It produces a warning for new failures before advising for CRITICAL and HIGH failures.
• C.It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
• D.It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?

• A.The command performs the recovery and closes the failure
• B.The command only displays the advice and the RMAN script required for recovery
• C.The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
• D.The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

• A.External naming method
• B.Host naming method
• C.Local naming method
• D.Directory naming method

Which two statements are true regarding undo tablespaces? (Choose two.)

• A.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management
• B.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
• C.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
• D.The database can have more than one undo tablespace