Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 91:

  A senior DBA asked you to execute the following command to improve performance:

  

  You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

  What could be a reason for this recommendation?

  A. The keep pool is not configured.
  B. Automatic Workarea Management is not configured.
  C. Automatic Shared Memory Management is not enabled.
  D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
  E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
  D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

  ---

  The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

• Question 92:

  Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

  

  What are three possible causes for the latch-related wait events?

  A. The size of the shared pool is too small.
  B. Cursors are not being shared.
  C. A large number COMMITS are being performed.
  D. There are frequent logons and logoffs.
  E. The buffers are being read into the buffer cache, but some other session is changing the buffers.
  A. The size of the shared pool is too small.
  B. Cursors are not being shared.
  E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

• Question 93:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  C. Tracking insert time by row for table rows
  D. Tracking the most recent write time for a table block in a table segment
  E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
  F. Tracking the most recent write time for a table segment in the SYSAUX tablespace
  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  C. Tracking insert time by row for table rows

  ---

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.

• Question 94:

  You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:

  SQL > @utlrp.sql

  Which two actions does the script perform? (Choose two.)

  A. Parallel compilation of only the stored PL/SQL code
  B. Sequential recompilation of only the stored PL/SQL code
  C. Parallel recompilation of any stored PL/SQL code
  D. Sequential recompilation of any stored PL/SQL code
  E. Parallel recompilation of Java code
  F. Sequential recompilation of Java code
  C. Parallel recompilation of any stored PL/SQL code
  E. Parallel recompilation of Java code

  ---

  utlrp.sql and utlprp.sql

  The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/

  admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of

  parallelism as follows.

  0 - The level of parallelism is derived based on the CPU_COUNT parameter.

  1 - The recompilation is run serially, one object at a time.

  N - The recompilation is run in parallel with "N" number of threads.

  Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.

• Question 95:

  You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause?

  A. The database is created as a non-CDB and can never contain a PDB.
  B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
  C. The database is created as a non-CDB and can never be plugged into a CDB.
  D. The database is created as a non-CDB but can be plugged into an existing CDB.
  E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
  A. The database is created as a non-CDB and can never contain a PDB.
  D. The database is created as a non-CDB but can be plugged into an existing CDB.

  ---

  A (not B, not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

  D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB: Incorrect Answers:

  

  E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

• Question 96:

  You created an encrypted tablespace:

  

  You then closed the encryption wallet because you were advised that this is secure.

  Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.

  Which is true about the result?

  A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
  B. It generates an error when creating the table because the wallet is closed.
  C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
  D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
  B. It generates an error when creating the table because the wallet is closed.

• Question 97:

  Which two statement are true about the installation modes in Oracle Database 12c? (Choose two.)

  A. In silent mode installation, you can validate the parameter values on installation screens for which you have provided information in the response file.
  B. In interactive mode, parameter values are read from a response file and can be changed during installation.
  C. Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.
  D. In response file mode, you can include responses for some or all prompts.
  A. In silent mode installation, you can validate the parameter values on installation screens for which you have provided information in the response file.
  D. In response file mode, you can include responses for some or all prompts.

• Question 98:

  Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)

  A. By default, EM express is available for a database after database creation.
  B. Multiple databases on the same node (or host) may each be individually managed by using EM Express.
  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.
  B. Multiple databases on the same node (or host) may each be individually managed 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 99:

  You notice that the elapsed time for an important database scheduler job is unacceptably long.

  The job belongs to a scheduler job class and runs in a scheduler window.

  Which two actions could reduce the job's elapsed time?

  A. Increasing the job's relative priority within the Job class to which it belongs
  B. Increasing the priority of the scheduler window to which the job belongs
  C. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
  D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
  E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
  A. Increasing the job's relative priority within the Job class to which it belongs
  C. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

• Question 100:

  You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours. For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

  A. to check the database time consumed for the two time periods
  B. to review the change in the initialization parameters between the two runs
  C. to find the resource consumption by SQL statements that are common to both periods
  D. to check the performance improvement and degradation caused during the change
  E. to review the hardware resources used during the two runs
  F. to compare the performance change of top SQL statements for the two runs
  C. to find the resource consumption by SQL statements that are common to both periods
  D. to check the performance improvement and degradation caused during the change
  E. to review the hardware resources used during the two runs