1Z0-052 試験問題を無料オンラインアクセス

Which two are true about consistent database backups? (Choose two.)

• A.They can only be taken by using RMAN command.
• B.They can only be taken when a RECOVERY CATALOG is used.
• C.They can only be taken by using RMAIN when the database is in MOUNT state.
• D.They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.
• E.They can only be taken if the database is in ARCHIVELOG mode.

Which two statements are true regarding transactions in an Oracle database? (Choose two.)

• A.Multiple transactions can use the same undo segment.
• B.More than one transaction cannot share the same extent in the undo tablespace.
• C.A transaction is assigned an undo segment when it is started.
• D.The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

You have issued a SHUTDOWN ABORT command to bring down your database instance.
Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

• A.1, 7, 5, 4, 2, 3, 6
• B.7, 1, 4, 5, 2, 3, 6
• C.1, 2, 3, 7, 5, 6, 4
• D.7, 1, 5, 2, 3, 6, 4

Which three are true about dynamic performance views? (Choose three.)

• A.They display selected data from data dictionary base tables
• B.Some of them display data that is useful for SQL statement tuning
• C.Read consistency is not guaranteed for these views
• D.They can be queried only by SYS even when the database is open
• E.They contain information that is not available in data dictionary views

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

• A.The database files are corrupted when the database is open
• B.The database is not opening because the required database files are missing
• C.The archived redo log files are missing for which the backup is not available
• D.The user has dropped an important table that needs to be recovered