Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 111:

  You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).

  The characteristics of the non-CDB are as follows: Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit Character set: AL32UTF8 National character set: AL16UTF16 O/S: Oracle Linux 6 64-bit

  The characteristics of the CDB are as follows: Version: Oracle Database 12c Release 1 64-bit Character Set: AL32UTF8 National character set: AL16UTF16 O/S: Oracle Linux 6 64-bit

  Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

  A. Transportable database
  B. Transportable tablespace
  C. Data Pump full export/import
  D. The DBMS_PDB package
  E. RMAN
  B. Transportable tablespace

  ---

  * Overview, example:

  -Log into ncdb12c as sys

  - Get the database in a consistent state by shutting it down cleanly.

  -Open the database in read only mode

  - Run DBMS_PDB.DESCRIBE to create an XML file describing the database.

  -Shut down ncdb12c

  -Connect to target CDB (CDB2)

  -Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)

  - Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).

  -Access the PDB and run the noncdb_to_pdb.sql script.

  -Open the new PDB in read/write mode.

  *

  You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.

  *

  Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.

• Question 112:

  You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure for a Standalone Server is already installed on the server.

  Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)

  A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created.
  B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.
  C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.
  D. The Oracle Database 12c installation must have a separate Oracle inventory directory.
  E. An operating system OSOPER group be created for users with the SYSOPER system privilege.
  B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.
  C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.
  E. An operating system OSOPER group be created for users with the SYSOPER system privilege.

• Question 113:

  As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.

  Which command would you execute to create the database link?

  A. CREATE DATABASE LINK HQ USING 'HQ';
  B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING `HQ';
  C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
  D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
  C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

• Question 114:

  Which three statements are true about Database Resource Manager? (Choose three.)

  A. A resource plan change can be automated by using the Oracle Scheduler.
  B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.
  C. It can be used to control the usage of the undo tablespace by consumer groups.
  D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.
  E. It can be used to enable resumable timeout for user sessions.
  F. It can be used to control the usage of the temp tablespace by consumer groups.
  A. A resource plan change can be automated by using the Oracle Scheduler.
  C. It can be used to control the usage of the undo tablespace by consumer groups.
  D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

• Question 115:

  You must create a table, DAILY_ORDERS, for a DSS application.

  Data should be compressed when using direct-path INSERT.

  The table will also be used for occasional DSS queries.

  Load performance is critical.

  Which compression option satisfies these requirements?

  A. COLUMN STORE COMPRESS FOR QUERY LOW
  B. COLUMN STORE COMPRESS FOR QUERY HIGH
  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  D. ROW STORE COMPRESS ADVANCED
  E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  D. ROW STORE COMPRESS ADVANCED

• Question 116:

  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:

  Not 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 117:

  Your database is running in ARCHIVELOG mode.

  You want to take a consistent whole database backup.

  Which two statements are true in this scenario? (Choose two.)

  A. RMAN backups contain only data files.
  B. The database instance must be shut down to take a user-managed consistent backup.
  C. Consistent RMAN backups can be taken while the database is open.
  D. User-managed backups only contain formatted data blocks.
  E. The database must be in MOUNT state to take consistent RMAN backups.
  C. Consistent RMAN backups can be taken while the database is open.
  D. User-managed backups only contain formatted data blocks.

• Question 118:

  Which statement is true regarding the DEFAULT profile?

  A. The values assigned to the resource limits and password parameters in the default profile can be altered.
  B. A different DEFAULT profile can be created before each user in a database.
  C. It can be dropped and recreated.
  D. it must be explicitly assigned to the user.
  A. The values assigned to the resource limits and password parameters in the default profile can be altered.

• Question 119:

  The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.

  Which two types of lock exist in this situation? (Choose two.)

  A. exclusive lock on the EMPLOYEES table
  B. null lock on the row being updated
  C. null lock on the EMPLOYEES table
  D. row level lock on the row being updated
  E. shared lock on the EMPLOYEES table
  D. row level lock on the row being updated
  E. shared lock on the EMPLOYEES table

• Question 120:

  An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?

  A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
  B. Increase the database buffer cache size.
  C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
  D. Configure Automata Shared Memory Management.
  E. Configure Automatic Memory Management.
  A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

  ---

  Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.