Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 181:

  Examine these configuration details:

  1.

  A Fast Recovery Area (FRA) has been specified for a database.

  2.

  The database instance is in ARCHIVELOG mode

  3.

  The default location for archived redo log files is the FRA.

  Which two types of files are removed automatically due to space pressure in the FRA? (Choose two.)

  A. flashback logs
  B. obsolete RMAN database backup sets
  C. obsolete spfiles
  D. expired RMAN image copies
  E. expired RMAN database backup sets
  F. Mirrored copies of online logs
  A. flashback logs
  B. obsolete RMAN database backup sets

  ---

  Reference: http://satya-dba.blogspot.com/2009/02/flash-recovery-area.html

• Question 182:

  Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

  A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
  B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
  C. All the components may be moved into SYSAUX tablespace.
  D. All the components may be moved from the SYSAUX tablespace.
  A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
  B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

• Question 183:

  You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.

  You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.

  What must you run to achieve this?

  A. SQL Access Advisor with a SQL tuning set
  B. Automatic Database Diagnostic Monitor (ADDM) report
  C. SQL Tuning Advisor
  D. SQL Access Advisor with a hypothetical workload
  E. SQL Performance Analyzer
  D. SQL Access Advisor with a hypothetical workload

• Question 184:

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

  CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)

  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 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 the package.
  C. Create the CREATE_TEST procedure with invoker's rights.

  ---

  If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker's rights can mitigate the risk of

  SQL injection.

  Incorrect:

  Not A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer-rights subprograms are bound to the schema in which they reside.

  not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.

• Question 185:

  Which two statements are true concerning the 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, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
  B. In a PDB plan, subplans may be used with up to eight consumer groups.
  C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
  D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  E. If a PDB plan is enabled for a pluggable database, then 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, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
  E. If a PDB plan is enabled for a pluggable database, then 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: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.

  * In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences: / Non-CDB Database Multi-level resource plans Up to 32 consumer groups Subplans / PDB Database Single-level resource plans only Up to 8 consumer groups (not B) No subplans

• Question 186:

  Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

  A. The PDB must be open in read-only mode.
  B. The PDB must be in mount state.
  C. The PDB must be unplugged.
  D. The PDB data files are always removed from disk.
  E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
  B. The PDB must be in mount state.
  C. The PDB must be unplugged.

  ---

  http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658

• Question 187:

  Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

  A. Dynamic Registration by the LREG process
  B. Dynamic Registration by the SMON process
  C. Static registration in the listener.ora file using the GLOBAL_DBNAME parameter
  D. Dynamic Registration by the PMON process
  E. Static registration in the listener.ora file using the SERVICE_NAME parameter
  A. Dynamic Registration by the LREG process
  E. Static registration in the listener.ora file using the SERVICE_NAME parameter

  ---

  Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG298

• Question 188:

  You are connected to a pluggable database (PDB) as a common user with DBA privileges.

  The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:

  SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE;

  Which is true about the result of this command?

  A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
  B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
  C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
  D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
  A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

• Question 189:

  A database runs in ARCHIVELOG mode.

  Dally full database backups are taken with RMAN which is configured to perform control file autobackup.

  The control file and redo log files are multiplexed.

  In which two cases is media recovery required? (Choose two.)

  A. loss of a data file that belongs to the active undo tablespace
  B. physical corruption of data
  C. loss of one copy of the control file
  D. loss of one member of the active redo log group
  E. loss of all members of an inactive redo log group
  C. loss of one copy of the control file
  D. loss of one member of the active redo log group

• Question 190:

  You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.

  You plan to create the database using SQL statements.

  Which three techniques can you use to achieve this? (Choose three.)

  A. Use Oracle Managed Files (OMF).
  B. Specify the SEED FILE_NAME_CONVERT clause.
  C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
  D. Specify the DB_FILE_NAMECONVERT initialization parameter.
  E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
  A. Use Oracle Managed Files (OMF).
  B. Specify the SEED FILE_NAME_CONVERT clause.
  C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

  ---

  You must specify the names and locations of the seed's files in one of the following ways:

  *

  (A) Oracle Managed Files

  *

  (B) The SEED FILE_NAME_CONVERT Clause

  *

  (C) The PDB_FILE_NAME_CONVERT Initialization Parameter