Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 141:

  Which three statements are true about common roles? (Choose three.)

  A. A common role can be granted only to a common user
  B. Only system privileges can be granted to a common role to a container database (CDB)
  C. Object privileges can be granted to a common role in a pluggable database (PDB)
  D. A common rule cannot be created by a local user
  E. A common user that is granted a common role can grant the role to other common and local users in a PDB
  C. Object privileges can be granted to a common role in a pluggable database (PDB)
  D. A common rule cannot be created by a local user
  E. A common user that is granted a common role can grant the role to other common and local users in a PDB

• Question 142:

  You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).

  The following are the possible steps to accomplish this task:

  1.

  Place all the user-defined tablespace in read-only mode on the source database.

  2.

  Upgrade the source database to a 12c version.

  3.

  Create a new PDB in the target container database.

  4.

  Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

  5.

  Copy the associated data files and export the dump file to the desired location in the target database.

  6.

  Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

  7.

  Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

  Identify the correct order of the required steps.

  A. 2, 1, 3, 4, 5, 6
  B. 1, 3, 4, 5, 6, 7
  C. 1, 4, 3, 5, 6, 7
  D. 2, 1, 3, 4, 5, 6, 7
  E. 1, 5, 6, 4, 3, 2
  C. 1, 4, 3, 5, 6, 7

  ---

  1. Create a directory in source database to store the export dump files. 2. Set the user and application tablespace in the source database as READ ONLY 3. Export the source database using expdp with parameters version=12.0,

  transportable=always and full=y 4. Copy the dumpfile and datafiles for tablespaces containing user /application data. 5. Create a new PDB in the destination CDB using create pluggable database command. 6. Create a directory in the

  destination PDB pointing to the folder containing the dump file or create a directory for dump file and move the dump file there. 7. Create an entry in tnsnames.ora for the new PDB. 8. Import in to the target using impdp with parameters

  FULL=Y and TRANSPORT_DATAFILES parameters. Make sure, the account is having IMP_FULL_DATABASE. 9. Restore the tablespaces to READ-WRITE in source database.

  References:

  http://sandeepnandhadba.blogspot.pt/2014/05/migrating-from-11203-non-cdb-to-12c-pdb.html

• Question 143:

  Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.

  LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY'

  Identify the statement that correctly describes these settings.

  A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
  B. Optional destinations cannot use the fast recovery area.
  C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
  D. These settings work only if log__archive_min_succeed_dest is set to a value of 4.
  C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.

  ---

  SQL> show parameter log_archive_min_succeed_dest NAME TYPE VALUE ------------------------------?------------------- log_archive_min_succeed_dest integer 1 SQ>; References: https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346

• Question 144:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

  A. tracking the most recent read time for a table segment in a user tablespace
  B. tracking the most recent write time for a table segment in a user tablespace
  C. tracking insert time by row for table rows
  D. tracking the most recent write time for each block in a table segment
  E. tracking the most recent read time for a table segment in the sysauxtablespace
  F. tracking the most recent write time for a table segment in the sysauxtablespace
  A. tracking the most recent read time for a table segment in a user tablespace
  B. tracking the most recent write time for a table segment in a user tablespace
  D. tracking the most recent write time for each block in a table segment

  ---

  Tracking of segment-level reads and writes At the block level, Heat Map tracks only the most recent modification time stamp.

• Question 145:

  Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

  A. Oracle Data Pump
  B. Oracle Recovery Manager (RMAN)
  C. Oracle Label Security
  D. Oracle Database Vault
  E. Oracle Real Application Security
  B. Oracle Recovery Manager (RMAN)

  ---

  Unlike other Oracle Database components, you do not create a unified audit policy for Oracle Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that

  automatically record Recovery Manager-related events.

  References:

  https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA

• Question 146:

  Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

  A. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
  B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
  C. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
  D. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
  E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
  A. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
  E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

• Question 147:

  Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

  A. Database Resident Connection Pooling
  B. Oracle Suggested Backup Strategy
  C. Database Vault in ORACLE_HOME
  D. Nondefaultblocksizetablespaces
  E. Configure Label Security
  C. Database Vault in ORACLE_HOME
  E. Configure Label Security

• Question 148:

  Which three statements are true about persistent lightweight jobs?

  A. A user cannot set privileges on them.
  B. They generate large amounts of metadata.
  C. They may be created as fully self-contained jobs.
  D. They must reference an existing Scheduler Program.
  E. The are useful when users need to create a large number of jobs quickly.
  A. A user cannot set privileges on them.
  D. They must reference an existing Scheduler Program.
  E. The are useful when users need to create a large number of jobs quickly.

  ---

  Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either `PLSQL_BLOCK' or `STORED_PROCEDURE'. References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668

• Question 149:

  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?

  A. 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.
  B. The command succeeds only if all the PDBs have the users and temp tablespaces.
  C. The command gives an error because the container=all clause is missing.
  D. 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 not exist in that PDB.
  B. The command succeeds only if all the PDBs have the users and temp tablespaces.

  ---

  When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command must exist in every PDB. If none of these are specified, the default TABLESPACE, TEMPORARY TABLESPACE, and PROFILE for the PDB will be used.

• Question 150:

  The following parameters are set for your Oracle 12c database instance:

  OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

  You want to manage the SQL plan evolution task manually. Examine the following steps:

  1.

  Set the evolve task parameters.

  2.

  Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

  3.

  Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

  4.

  Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

  5.

  Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

  Identify the correct sequence of steps.

  A. 2, 4, 5
  B. 2, 1, 4, 3, 5
  C. 1, 2, 3, 4, 5
  D. 1, 2, 4, 5
  B. 2, 1, 4, 3, 5

  ---

  Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653