Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 41:

  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 EM express.
  E. You can create and configure pluggable databases by using EM express.
  D. You cannot start up or shut down a database instance by using EM express.

  ---

  O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.

• Question 42:

  Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges: Which statement is true about the common user created by the command?

  

  A. The user cannot connect any database because the CONTAINER clause is missing.
  B. The user can connect only to the root database.
  C. The user can connect to the root and all PDBs.
  D. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.
  C. The user can connect to the root and all PDBs.

• Question 43:

  To complete the online redefinition procedure, you execute the following command;

  EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES', `INT_SALES', 600);

  What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

  A. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.
  B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.
  C. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.
  D. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.
  B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

  ---

  Wait up to 600 seconds for required locks on SH.SALES:

  EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (

  'SH', 'SALES', 'INT_SALES', 600);

  Reference: http://oradb-srv.wlv.ac.uk/E50529_01/ARPLS/d_redefi.htm#ARPLS042

• Question 44:

  You are connected to a multitenant container database (CDB) with DBA privileges.

  The STATISTICS_LEVEL parameter is PDB_MODIFIABLE.

  You issue:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;

  Which three effects does this have on the CDB and its pluggable databases (PDBs)? (Choose three.)

  A. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter has no value set.
  B. The STATISTICS_LEVEL parameter is immediately set to ALL in the CDB instance.
  C. The STATISTICS_LEVEL parameter is set to ALL on all PDBs when they are opened.
  D. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs.
  E. The STATISTICS_LEVEL parameter is set to ALL in the SPFILE.
  A. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter has no value set.
  B. The STATISTICS_LEVEL parameter is immediately set to ALL in the CDB instance.
  C. The STATISTICS_LEVEL parameter is set to ALL on all PDBs when they are opened.

• Question 45:

  Examine the following parameters for a database instance:

  

  Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

  A. LOG_BUFFER
  B. SORT_AREA_SIZE
  C. JAVA_POOL_SIZE
  D. STREAMS_POOL_SIZE
  E. DB_16K_CACHE_SIZE
  F. DB_KEEP_CACHE_SIZE
  A. LOG_BUFFER
  E. DB_16K_CACHE_SIZE
  F. DB_KEEP_CACHE_SIZE

  ---

  Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter / The log buffer LOG_BUFFER / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE

  Note:

  *

  In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.

  *

  Table, Automatically Sized SGA Components and Corresponding Parameters

  

• Question 46:

  Your multitenant container database (CDB) contains several pluggable databases (PDBs).

  A common user C##A_ADMIN, is created with connect privileges.

  You execute this command from the root container:

  SQL> GRANT create tablespace to C##A_ADMIN;

  Which statement is true?

  A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root container.
  B. The command fails because the CONTAINER=ALL clause is not used.
  C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.
  D. The command fails because the CONTAINER=CURRENT clause is not used.
  C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.

• Question 47:

  Which three statements are true about Automatic Workload Repository (AWR)?

  A. All AWR tables belong to the SYSTEM schema.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
  E. AWR contains system wide tracing and logging information.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

  ---

  5.2 Overview of the Automatic Workload Repository The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.

  The statistics collected and processed by AWR include: Object statistics that determine both access and usage statistics of database segments Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views

  References: http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm#PFGRF02601

• Question 48:

  You find this query being used in your Oracle 12c database:

  

  Which method a used by the optimizer to limit the rows being returned?

  A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
  B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
  C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
  D. A TOP-N query is created to limit the rows to 20 percent of the total rows
  C. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

• Question 49:

  Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

  A. Maximum Undo per consumer group
  B. Maximum Idle time
  C. Parallel server limit
  D. CPU
  E. Exadata I/O
  F. Local file system I/O
  C. Parallel server limit
  D. CPU
  E. Exadata I/O

  ---

  http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11852

• Question 50:

  Examine these parameters settings: What is true about the control file?

  

  A. The control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1 and DB_CREATE_ONLINE_LOG_DEST_2.
  B. Only a single control file exists in the location specified by DB_CREATE_FILE_DEST.
  C. The control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST.
  D. Only a single control file exists in the location specified by DB_RECOVERY_FILE_DEST.
  E. The control file is multiplexed in the locations specified by DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_1.
  A. The control file is multiplexed in the locations specified by DB_CREATE_ONLINE_LOG_DEST_1 and DB_CREATE_ONLINE_LOG_DEST_2.

  ---

  Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17120/omf005.htm