1z0-062 무료 덤프문제 온라인 액세스

Which three database operations can be performed only at MOUNT state? (Choose three.)

• A.enabling or disabling ARCHIVELOG mode
• B.re-creating control files
• C.performing Flashback Database
• D.performing full database recovery
• E.renaming control files

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A.The time when the last flashback operation in your database was performed
• B.The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
• C.The time when the first flashback operation in our database was performed
• D.The approximate time and the lowest system change number (SCN) to which you can flash back your database

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

• A.AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• B.AWR contains system wide tracing and logging information.
• C.The AWR data is stored in memory and in the database.
• D.The snapshots collected by AWR are used by the self-tuning components in the database
• E.All AWR tables belong to the SYSTEM schema.

Which statement is true about a database in ARCHIVELOG mode?

• A.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• B.Full database backups can be performed when the database is opened.
• C.A Fast Recovery Area (FRA) must be configured for the database.
• D.All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

• A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B.The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
• C.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• D.ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E.Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.