Oracle Database 11g: Administration II - 1Z0-053 FREE EXAM DUMPS QUESTIONS & ANSWERS

You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this? (Choose two)
Correct Answer: B,E Vote an answer
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline.
Which action would you take before performing this task?
Correct Answer: C Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?
Correct Answer: D Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
For which of the following can you use Segment Shrink? (Choose all that apply.)
Correct Answer: A,B,C Vote an answer
View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?
Exhibit:
Correct Answer: D Vote an answer
Examine the following PL/SQL block:

Which statement describes the effect of the execution of the above PL/SQL block?
Correct Answer: B Vote an answer
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?
Exhibit:
Correct Answer: B Vote an answer
Which of the following restrictions are NOT true with respect to tablespace point-in-time recovery? (Choose all that apply.)
Correct Answer: C,D Vote an answer
Another DBA issues a shutdown abort command on a database on which you were running an online backup.
What will happen when you try to restart the database?
Correct Answer: A Vote an answer
Which two statements are true regarding hot patching? (Choose two.)
Correct Answer: B,C Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
Correct Answer: D,E Vote an answer
You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?
Correct Answer: B Vote an answer
0
0
0
10