Loading questions...
Updated
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?
Which two statements describe the relationship between a window, a resource plan, and a job class?
Which two are prerequisites for creating a backup-based duplicate database?
Which three statements are true about Oracle Secure Backup (OSB)?
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_backup
In 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 on
Sundays 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:
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
You wish to create jobs to satisfy these requirements:
Which three statements are true about the keystore storage framework for transparent data encryption?
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i.Long-running queries are not affected. ii.No extra space is used. iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process. iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
For which two requirements would you use the Database Resource Manager?
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin -
IDENTIFIED BY password -
DEFAULT TABLESPACE users -
QUOTA I00M ON users -
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?
Which two statements are true about a common user?
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on
Sundays 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.
Which action must you take for recovery?
Which three statements are true about Oracle Restart?
Examine the parameters for your database instance:
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE -
NOFILENAMECHECK -
PASSWORD FILE -
SPFILE;
Which two statements are true about the execution of the duplicate command?
A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
You want to export the pluggable database (PDB) hr_pdb1 from the multitenant container database (CDB) CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task: