Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 91:

  Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required. In which two cases is this true?

  A. flashback logs
  B. inactive online redo log
  C. current online redo log member
  D. all control files
  E. archived log files required to perform recovery
  B. inactive online redo log
  D. all control files

  ---

  Reference: https://docs.oracle.com/cd/B10501_01/server.920/a96519/strategy.htm

• Question 92:

  On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:

  S>sqlldrhr/hr@pdb table=employees

  Which two statements are true about the command?

  A. It succeeds with default settings if the employees table exists in the hr schema.
  B. It fails because no SQL*Loader data file location is specified.
  C. It fails if the hr user does not have the create any directory privilege.
  D. It fails because no SQL*Loader control file location is specified.
  E. It succeeds and creates the employees table in the HR schema.
  A. It succeeds with default settings if the employees table exists in the hr schema.
  C. It fails if the hr user does not have the create any directory privilege.

  ---

  sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=\"DD-MON-YYYY HH24:MI:SS\" Reference: https://oracle-base.com/articles/12c/sql-loader-enhancements-12cr1

• Question 93:

  The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.

  The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.

  You execute the RMAN commands: RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11

  Which two tasks are performed as part of the import? (Choose two.)

  A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
  B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
  C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
  D. Imported databases are unregistered from the RC11 catalog.
  E. Recovery catalog is resynchronized with the control files of the registered databases.
  A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
  D. Imported databases are unregistered from the RC11 catalog.

• Question 94:

  What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  A. statistics recommendations
  B. SQL profile recommendations
  C. SQL statement restructure recommendations
  D. creation of materialized views to improve query performance
  B. SQL profile recommendations

  ---

  Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: ... During the tuning process, all recommendation types are considered and reported, but only

  SQL profiles can be implemented automatically.

  References:

  https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

• Question 95:

  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?

  A. DEALLOCATE UNUSED
  B. SHRINK SPACE CASCADE
  C. SHRINK SPACE COMPACT
  D. ROW STORE COMPRESS BASIC
  C. SHRINK SPACE COMPACT

  ---

  The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed. The defragmentation and compaction results are saved to disk, so the data movement does not have to be redone during the second phase. You can reissue the SHRINK SPACE clause without the COMPACT clause during off-peak hours to complete the second phase. References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

• Question 96:

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

  A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
  B. 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.
  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
  D. Only a common user can create additional services for a PDB.
  E. When a PDB is created, a service with the same name as the PDB is created in the PDB.
  A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

• Question 97:

  Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  A. By default, EM express is available for a database after database creation.
  B. You can use EM express to manage multiple databases running on the same server.
  C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
  D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
  E. You can create and configure pluggable databases by using EM express.
  A. By default, EM express is available for a database after database creation.

  ---

  EM Express is built inside the database.

  Note:

  Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From

  an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.

• Question 98:

  Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

  A. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
  C. Use PDB$SEED for creating a PDB.
  D. To clone an existing PDB.
  E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.
  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
  C. Use PDB$SEED for creating a PDB.
  D. To clone an existing PDB.

• Question 99:

  In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:

  CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_SALARYNUMBER,v_dept_idNUMBER)

  BEGIN

  INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);

  END;

  /

  GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;

  How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

  A. Create the create_test procedure with definer's rights.
  B. Grant the execute privilege to users with grant option on the create_test procedure.
  C. Create the create_test procedure with invoker's rights.
  D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.
  C. Create the create_test procedure with invoker's rights.

  ---

  You can control access to privileges that are necessary to run user-created procedures by using definer's rights, which execute with the privileges of the owner, or with invoker's rights, which execute with the privileges of the user running the procedure.

• Question 100:

  Examine the backup requirement for your company:

  1) Every Sunday, a backup of all used data file blocks is performed.

  2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.

  3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.

  Which backup strategy satisfies the requirements?

  A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
  B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
  C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
  D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
  A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

  ---

  Multilevel Incremental Backups RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data. You can create a level 0 database backup as backup sets or image copies. The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0. A level 1 incremental backup can be either of the following types: A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0. A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0. Incremental backups are differential by default.