Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 61:

  Which two statements are true about roles in multitenant container databases (CDBs)?

  A. Local roles can be granted to local and common users.
  B. A common role can be granted only to a common user.
  C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
  D. A common role can be granted only system privileges.
  E. The root container can have both local and common roles.
  F. A local role can be assigned to a common role in a PDB.
  D. A common role can be granted only system privileges.
  F. A local role can be assigned to a common role in a PDB.

• Question 62:

  Examine these parameter settings:

  SGA_TARGET = 700M

  SGA_MAX_SIZE = 1024M

  DB_8K_CACHE_SIZE = 124M

  LOG_BUFFER = 200M

  You attempt this:

  SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M

  Which statement is true based on the information available?

  A. It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
  B. It succeeds only if memory is available from the autotuned components of the SGA.
  C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
  D. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
  B. It succeeds only if memory is available from the autotuned components of the SGA.

• Question 63:

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

  A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
  B. A job defined in a PDB runs only if that PDB is open.
  C. Scheduler attribute setting is performed only at the CDB level.
  D. Scheduler objects created by users can be exported or imported using Data Pump.
  E. Scheduler jobs for a PDB can be created only by common users.
  B. A job defined in a PDB runs only if that PDB is open.
  D. Scheduler objects created by users can be exported or imported using Data Pump.

  ---

  In general, all scheduler objects created by the user can be exported/imported into the PDB using data pump. Predefined scheduler objects will not get exported and that means that any changes made to these objects by the user will have to be made once again after the database has been imported into the pluggable database. However, this is how import/export works currently. A job defined in a PDB will run only if a PDB is open.

• Question 64:

  The SYS user creates this job:

  

  Which two statements are true about this job? (Choose two.)

  A. It executes with the privileges of SYS
  B. It is automatically dropped after the last run
  C. The globalization environment that exist at job creation is used run time
  D. It executes with the privileges of OPS
  A. It executes with the privileges of SYS
  B. It is automatically dropped after the last run

• Question 65:

  View the SPFILE parameter settings in the Exhibit.

  

  You issue this command and get errors: SQL> startup ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation

  Why did the instance fail to start?

  A. because pga_aggregate_target is not set
  B. because statistics_level is set to basic
  C. because memory_target and memory_max_target cannot be equal
  D. because sga_target and memory_target are both set
  B. because statistics_level is set to basic

  ---

  SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

• Question 66:

  You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.

  You set the value of the initialization parameter resumable_timeout to 3600.

  Which two statements are true?

  A. A resumable statement can be suspended and resumed only once during execution.
  B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
  C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
  D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
  E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
  C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
  D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

  ---

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm

• Question 67:

  Which three statements are true about a job chain?

  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  C. It cannot invoke the same program or nested chain in multiple steps in the chain.
  D. It cannot have more than one dependency.
  E. It can be executed using event-based or time-based schedules.
  A. It can contain a nested chain of jobs.
  B. It can be used to implement dependency-based scheduling.
  E. It can be executed using event-based or time-based schedules.

  ---

  Chains are the means by which you can implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs. DBMS_SCHEDULER.DEFINE_CHAIN_STEP DBMS_SCHEDULER.DEFINE_CHAIN_EVENT_STEP Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12

• Question 68:

  You execute the command to recover your database.

  

  Which statement is true?

  A. It restores all data files from the specified time, and then applies the redo logs
  B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time
  C. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task
  D. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".
  C. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task

• Question 69:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

  A. Encrypted backups can only be written to disk.
  B. Image copy backups can be created by using password encryption.
  C. A database uses the same encryption key for every encrypted backup.
  D. Transparent encryption of backups uses an encryption wallet.
  E. A password encryption of backups uses the password while creating and restoring backups.
  D. Transparent encryption of backups uses an encryption wallet.
  E. A password encryption of backups uses the password while creating and restoring backups.

  ---

  Reference: https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/rcmbackp006.htm

• Question 70:

  You have a production Oracle 12c database running on a host.

  You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c

  database.

  The steps in random order:

  1.Create directory structures similar to the production database on all new machines.

  2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3.Create a database clone template for the database.

  4.Run the Database Configuration Assistant (DBCA) to create the database.

  5.Run OUI in graphical mode on each machine.

  6.Run OUI in silent mode using the OUI response file.

  Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

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

  ---

  Reference: http://docs.oracle.com/cd/B19306_01/install.102/b15660/app_nonint.htm