10 free sample questions from a bank of 211, with the correct answers and explanations. No signup required — start practising right now.
1Which two statements are true about scheduling operations in a pluggable database (PDB)?
Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
A job defined in a PDB runs only if that PDB is open.
Scheduler attribute setting is performed only at the CDB level.
Scheduler objects created by users can be exported or imported using Data Pump.
Scheduler jobs for a PDB can be created only by common users.
Answer:
2You 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:
1. Create a PDB named emp_pdb1.
2. Export the hr_pdb1 PDB by using the full clause.
3. Open the emp_pdb1 PDB.
4. Mount the emp_pdb1 PDB.
5. Synchronize the emp_pdb1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the emp_pdb1 PDB.
8. Import data into emp_pdb1 with the full and remap clauses.
9. Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
2, 1, 3, 7, 6, and 8
2, 1, 4, 5, 3, 7, 6, 9, and 8
2, 1, 3, 7, 6, 9, and 8
2, 1, 3, 5, 7, 6, and 8
Answer: C
3Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?
A job is specified as part of a program definition.
A program can be used in the definition of multiple jobs.
A program and job can be specified as part of a schedule definition.
A program and schedule can be specified as part of a job definition.
A program and window can be specified as part of a job definition.
Answer:
4Which two statements describe the relationship between a window, a resource plan, and a job class?
A window specifies a resource plan that will be activated when that window becomes active.
A window specifies a job class that will be activated when that window becomes active.
A job class specifies a window that will be open when that job class becomes active.
A window in association with a resource plan controls a job class allocation.
A window in association with a job class controls a resource allocation.
Answer:
5Which two are prerequisites for creating a backup-based duplicate database?
connecting to the target database and a recovery catalog to execute the duplicate command
creating a password file for an auxiliary instance
connecting to an auxiliary instance
matching the database identifier (DBID) of the source database and the duplicate database
creating an SPFILE for the target database
Answer:
6Which three statements are true about Oracle Secure Backup (OSB)?
It can encrypt client data written to tape.
It can be used to take image copy backups to tape.
It can be used to manage tape backup and restore operations for multiple databases.
It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
It can be used to perform file system backups at the file, directory, file system, or raw partition level.
Answer:
7LDAP_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?
authentication by password file
authentication by using certificates over SSL
authentication by using the Oracle Internet Directory
authentication by using the local OS of the database server
Answer: A
8Your 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.
1, 3, 4, 5
6, 3, 4, 5
2, 3, 4, 5
6, 4, 3, 5
Answer: C
9You 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?
The statistics_level parameter is set to all when any of the PDBs is reopened.
The statistics_level parameter is set to all only for PDB2 when it is reopened.
The statistics_level parameter is set to all when the root database is restarted.
The statement is ignored because there is no SPFILE for a PDB.
Answer: B
10Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?
when one or more disks in an ASM disk group are lost
when the data file on an ASM disk group gets corrupted
when one of the disks in a disk group is accidentally unplugged
when one or more file directory paths are accidentally deleted from an ASM disk group
when all the ASM disk groups for the ASM instance are lost