1z0-063 practice test

1. Question 1 · 1

   Which two statements are true about scheduling operations in a pluggable database (PDB)?

   Choose all answers that apply.

   • 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.

2. Question 2 · 1

   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: 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.

   Choose one answer.

   • 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

3. Question 3 · 1

   Which two statements describe the relationship between a window, a resource plan, and a job class?

   Choose all answers that apply.

   • 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.

4. Question 4 · 1

   Which three statements are true about Oracle Secure Backup (OSB)?

   Choose all answers that apply.

   • 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.

5. Question 5 · 1

   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?

   Choose one answer.

   • 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

6. Question 6 · 1

   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.

   Choose one answer.

   • 1, 3, 4, 5
   • 6, 3, 4, 5
   • 2, 3, 4, 5
   • 6, 4, 3, 5

7. Question 7 · 1

   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?

   Choose one answer.

   • 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.

8. Question 8 · 1

   Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup In which three situations can you use the backup?

   Choose all answers that apply.

   • 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

9. Question 9 · 1

   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: 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.

   Choose one answer.

   • 4, 8, 11, 5
   • 1, 3, 8, 11, 9
   • 1, 2, 6, 3, 7, 10, 9
   • 1, 3, 7, 10, 9
   • 1, 2, 6, 3, 8, 11, 9

10. Question 10 · 1

    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?

    Choose one answer.

    • It recovers the structure, data, and indexes of the first emp table.
    • It recovers only the structure of the second emp table.
    • It returns an error because two tables with the same name exist in the recycle bin.
    • It recovers the structure, data, and indexes of the second emp table.

11. Question 11 · 1

    You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

    Choose one answer.

    • Create both jobs by using Scheduler raised events.
    • Create both jobs using application raised events.
    • Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
    • Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

12. Question 12 · 1

    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?

    Choose one answer.

    • DEALLOCATE UNUSED
    • SHRINK SPACE CASCADE
    • SHRINK SPACE COMPACT
    • ROW STORE COMPRESS BASIC

13. Question 13 · 1

    For which two requirements would you use the Database Resource Manager?

    Choose all answers that apply.

    • limiting the CPU used per database call
    • specifying the maximum number of concurrent sessions allowed for a user
    • specifying the amount of private space a session can allocate in the shared pool of the SGA
    • limiting the degree of parallelism of operations performed by a user or group of users
    • specifying an idle time limit that applies to sessions that are idle and blocking other sessions

14. Question 14 · 1

    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?

    Choose one answer.

    • The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
    • The command succeeds only if all the PDBs have the users and temp tablespaces.
    • The command gives an error because the container=all clause is missing.
    • The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does

15. Question 15 · 1

    Which two statements are true about the Automatic Diagnostic Repository (ADR)?

    Choose all answers that apply.

    • The ADR base is shared across multiple instances.
    • The ADR base keeps all diagnostic information in binary format.
    • The ADR can be used to store statspack snapshots to diagnose database performance issues.
    • The ADR can be used for problem diagnosis even when the database instance is down.
    • The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Paid access to all 148 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.