Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 161:

  Which two are prerequisites for performing Flashback Transaction? (Choose two.)

  A. Fast Recovery Area must be enabled for the database
  B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package
  C. Undo retention guarantee must be configured for the database
  D. A supplemental log must be enabled for the primary key
  E. Row movement must be enabled
  B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package
  D. A supplemental log must be enabled for the primary key

• Question 162:

  You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

  CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE

  You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges

  Why does the startup command return the error shown?

  A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
  B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
  C. because the threaded architecture requires authentication using a password file before issuing a startup command
  D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
  E. because the threaded architecture requires restarting the listener before issuing a startup command
  C. because the threaded architecture requires authentication using a password file before issuing a startup command

  ---

  The first pitfall is, when you try to configure your database for such use. You need a connection which is authenticated trough the password file. Otherwise you will get are error similar to this.

  Reference:

  https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threaded-oracle/

• Question 163:

  Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

  You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

  How would you achieve this?

  A. by using the RMAN switch command to set the new location for the data files
  B. by using the RMAN duplicate command with no filename check to recover the database to the new host
  C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
  D. by creating a new database in the new host, and then using the RMAN recover command
  B. by using the RMAN duplicate command with no filename check to recover the database to the new host

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#CHDGFABD

• Question 164:

  The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.

  The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.

  A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.

  In the CATDB12c database, you execute the commands:

  Srman

  RMAN> CONNECT CATALOG rc12c/pass12c@catdbI2c

  RMAN> IMPOST CATALOG rc1l/pwdcatl11@catdbl1 DBID=I423241;

  What is the outcome of the import?

  A. It fails because the target database and recovery catalog database are of different versions.
  B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
  C. It succeeds but the database is not automatically registered in the Rc12c catalog.
  D. It fails because RMAN is not connected to the target database with DBID=1423241.
  A. It fails because the target database and recovery catalog database are of different versions.

  ---

  The version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schema. If they are not equal, then upgrade the schemas to the same version.

  References:

  https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

• Question 165:

  Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

  A. A DBA can check specific tables with the DMU
  B. The database to be migrated must be opened read-only.
  C. The release of the database to be converted can be any release since 9.2.0.8.
  D. The DMU can report columns that are too long in the converted characterset
  E. The DMU can report columns that are not represented in the converted characterset
  A. A DBA can check specific tables with the DMU
  D. The DMU can report columns that are too long in the converted characterset
  E. The DMU can report columns that are not represented in the converted characterset

  ---

  A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.

  D: Exceed column limit

  The cell data will not fit into a column after conversion.

  E: Need conversion

  The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

• Question 166:

  Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases

  (PDBs), PDB1 and PDB2, respectively.

  Examine the commands to change the value of the PDB modifiable initialization parameter:

  $> sqlplus sys/oracle_4U@pdb1 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH;

  SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

  SQL> CONN sys/oracle_4U@pdb1 AS SYSDBA

  SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

  Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the best answer.)

  A. It gives an error because it cannot be set for the root database.
  B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
  C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
  D. It is set to TRUE for the root database and all the PDBs, but is effective only when CDB is restarted and the PDBs are reopened.
  B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.

  ---

  Reference: https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1

• Question 167:

  Examine Exhibits: Exhibit1

  

  and Exhibit2.

  

  Both processes use an existing job template PROG_1 Jobs elapsed times are recorded in table TEST_LOG.

  Why is job creation in Exhibit1 faster than in Exhibit2?

  A. It creates jobs in memory only
  B. It writes compressed job metadata to disk
  C. It creates less job metadata
  D. It updates tables in the SYSTEM tablespace instead of creating new tables
  D. It updates tables in the SYSTEM tablespace instead of creating new tables

• Question 168:

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

  A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
  C. Each PDB can have its own default temporary tablespace.
  D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
  E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
  C. Each PDB can have its own default temporary tablespace.

  ---

  References:

  https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-tablespaces

• Question 169:

  You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?

  A. The installation proceeds with the default value but a message is generated in the alert log file
  B. The installation terminates with an error
  C. The installation proceeds with the default value but the database creation is not attempted
  D. The software installation proceeds with the default value but database creation fails
  A. The installation proceeds with the default value but a message is generated in the alert log file

• Question 170:

  You install Oracle Grid Infrastructure for a standalone server and issue this command:

  crsctl start has

  Which two components get automatically added to the Oracle Restart configuration the first time this command is issued? (Choose two.)

  A. A database that already exists prior to the Grid Infrastructure installation
  B. Oracle Notification services
  C. Oracle Healthcheck services
  D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation
  E. Oracle CSSD services
  C. Oracle Healthcheck services
  E. Oracle CSSD services