1z0-067 practice test

1. Question 1 · 1

   Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

   Choose all answers that apply.

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

   Read explanation

   References:

2. Question 2 · 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.

3. Question 3 · 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.

4. Question 4 · 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

5. Question 5 · 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

6. Question 6 · 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.

7. Question 7 · 1

   Which two statements are true about a common user?

   Choose all answers that apply.

   • A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
   • A common user with the create user privilege can create other common users, as well as local users.
   • A common user can be granted only a common role.
   • A common user can have a local schema in a PDB.
   • A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

8. Question 8 · 1

   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?

   Choose all answers that apply.

   • All archive redo log files are automatically copied to the duplicate database.
   • The duplicate database has the same directory structure as the source database.
   • The duplicate database is created by using the backups created during the execution of
   • the duplicate command.
   • The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
   • The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

9. Question 9 · 1

   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?

   Choose all answers that apply.

   • Drop the tenpOi.dbf file, and then re-create the temp file.
   • Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
   • Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
   • Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
   • Create a new temporary tablespace and assign it as the default to the user.

10. Question 10 · 1

    Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?

    Choose all answers that apply.

    • Enable temporary undo for the database.
    • Enable undo retention guarantee.
    • Increase the size of the redo log buffer.
    • Enable Automatic Memory Management (AMM).
    • Increase the size of the temporary tablespace.

11. Question 11 · 1

    Which two statements are true about service creation for pluggable databases (PDBs)?

    Choose all answers that apply.

    • When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
    • The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
    • A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
    • Only a common user can create additional services for a PDB.
    • When a PDB is created, a service with the same name as the PDB is created in the PDB.

12. Question 12 · 1

    You want to move your existing recovery catalog to another database. Examine the steps: 1)Export the catalog data by using the Data Pump Export utility in the source database. 2) Create a recovery catalog user and grant the necessary privileges in the target database. 3) Create a recovery catalog by using the create catalog command. 4)Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database. 5)Import the source recovery catalog schema by using the import catalog command. 6)Connect to the destination database. 7) Connect as catalog to the destination recovery catalog schema. Identify the option with the correct sequence for moving the recovery catalog.

    Choose one answer.

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

13. Question 13 · 1

    Examine the command and its output: SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE - -------------------------------------------------------------------------------------------------------------- binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command: SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true?

    Choose all answers that apply.

    • It flashes back the employee table and all the constraints associated with the table.
    • It automatically flashes back all the indexes on the employes table.
    • It automatically flashes back any triggers defined on the table.
    • It flashes back only the structure of the table and not the data.
    • It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

14. Question 14 · 1

    Your database supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery - Target_mttrestimated_mttr - ---------------------- --------------------------- To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30. What is the effect of this setting on the database?

    Choose one answer.

    • Automatic checkpoint tuning is disabled.
    • The frequency of log switches is increased.
    • The overhead on database performance is increased because of frequent writes to disk.
    • The MTTR advisor is disabled.

15. Question 15 · 1

    In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

    Choose all answers that apply.

    • The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
    • Setting the target tablespace to read-only after the segments are moved
    • The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
    • Taking the target tablespace offline after the segments are moved
    • The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs

Paid access to all 50 questions

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