You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM
Answer : B,C,D
Explanation:
Purpose -
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description -
md_restore backup_file [--silent]
[--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]']
[-S sql_script_file] [-G 'diskgroup [,diskgroup...]']
backup_file
Reads the metadata information from backup_file.
--silent
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.
--full
Specifies to create a disk group and restore metadata.
--nodg
Specifies to restore metadata only.
--newdg -o old_diskgroup:new_diskgroup]
Specifies to create a disk group with a different name when restoring metadata. The -o option is required with
--newdg.
-S sql_script_file
Write SQL commands to the specified SQL script file instead of executing the commands.
-G diskgroup
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
Answer : B
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
Answer : A,B,D
The INV_HISTORY table is created using the command:
Answer : C
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted
SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
Which DB01 is the net service name.
Which authentication method would be used first?
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Answer : A Topic 2, Configuring for Recoverability
Which of the following does the recover command not do?
Answer : A
What is the purpose of the list expired backup command?
Answer : C
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous
Sunday and earlier. You now need to restore your backup due to database loss.
To which point can you restore your database?
Answer : E
Which of the following parameters defines the location where Oracle should create archived redo logs?
Answer : D
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data
Pump Import would you use to accomplish this?
Answer : D
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?
Answer : D
Which RMAN backup command is used to create the block-change tracking file?
Answer : C
Your archive-log destination directory runs out of space. What is the impact of this on the database?
Answer : E
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?
Answer : C
You want to use the automatic management of backup and recovery operations features for your database.
Which configuration must you set?
Answer : A