LDAP_DIRECTORY_SYSAUTH is set to YES.Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).SSL has been configure for the database and OLD and the password file has been configured for the database.User scott with sysdba privilege tries to connect remotely using this command:$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.Which authentication method will be attempted first?
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.Examine the steps to recover the online redo log group and move it to a new location.1.Restore the corrupted redo log group.2.Restore the database from the most recent database backup.3.Perform an incomplete recovery.4.Relocate the member of the damaged online redo log group to a new location.5.Open the database with the resetlogs option.6. Issue a checkpoint and clear the log.Identify the required steps in the correct order.
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.The statistics_level parameter is PDB modifiable.As the user sys, execute the following command on pdb2:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;Which statement is true about the result of this command?
Examine the command to back up the ASM metadata:ASMCMD>md_backup /backup/ASM_backupIn which three situations can you use the backup?
You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup onSundays and level 1 Incremental backups on all the other days of the week.One of the data files is corrupted and the current online redo log file is lost because of a media failure.You want to recover the data file.Examine the steps involved in the recovery process:1. Shut down the database instance.2. Start up the database instance in nomount state.3. Mount the database.4. Take the data file offline.5. Put the data file online.6. Restore the control file.7. Restore the database.8. Restore the data file.9. Open the database with the resetlog option.10. Recover the database with the noredo option.11. Recover the data file with the noredo option.Identify the required steps in the correct order.
Which two statements are true about scheduling operations in a pluggable database (PDB)?
