Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 271:

  To enable faster incremental backups, you enabled block change tracking for the database.

  Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.
  B. The change tracking file must be created after the first level 0 backup.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

• Question 272:

  Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

  A. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
  B. A job class specifies a scheduler window that will be open when that job class becomes active.
  C. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.
  D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
  E. A scheduler window can control resource allocation by itself.
  D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
  E. A scheduler window can control resource allocation by itself.

• Question 273:

  You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.

  All databases of all versions use Automatic Storage Management (ASM).

  Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

  A. The ASM compatibility attribute controls the format of the disk group metadata.
  B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
  C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
  D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
  E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.
  A. The ASM compatibility attribute controls the format of the disk group metadata.
  B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
  D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

  ---

  AD: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.

  B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.

  For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.

  Not E:

  /The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be

  11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.

  / You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.

  The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.

  Note:

  * The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create a volume in a disk group.

• Question 274:

  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.

  ---

  References: http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html

• Question 275:

  Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

  A. Oracle Net Manager
  B. Oracle Enterprise Manager Cloud Control
  C. Oracle Net Configuration Assistant
  D. Listener Control Utility (LSNRCTL)
  E. Oracle Enterprise Manager Database Express
  A. Oracle Net Manager
  B. Oracle Enterprise Manager Cloud Control

• Question 276:

  Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

  A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
  B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
  C. Use the DBMS_PDB package to clone an existing PDB.
  D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
  E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.
  A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
  C. Use the DBMS_PDB package to clone an existing PDB.
  D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

  ---

  Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks:

  *

  (A) Create a PDB by using the seed as a template

  Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.

  *

  (C) Create a PDB by cloning an existing PDB

  Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.

  The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.

  * Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB

  Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

• Question 277:

  Examine the parameters for your database instance:

  

  You execute the following command:

  SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;

  Which statement is true in this scenario?

  A. Undo data is written to flashback logs after 1200 seconds.
  B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
  C. You can perform a Flashback Database operation only within the duration of 1200 seconds.
  D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
  D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

• Question 278:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set
  D. Putting the MASTERTBS tablespace in read-only mode
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set

  ---

  If constraints for the tables in tablespace tbs1 are contained in the tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.

  Reference:

  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV99978

• Question 279:

  You use the segment advisor to help determine objects for which space may be reclaimed.

  Which three statements are true about the advisor given by the segment advisor? (Choose three.)

  A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
  B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
  C. It may advise the use of online table redefinition for tables in locally managed tablespaces
  D. It will detect and advise about chained rows.
  E. It may advise the use of segment shrink for free list managed tables.
  A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
  C. It may advise the use of online table redefinition for tables in locally managed tablespaces
  D. It will detect and advise about chained rows.

• Question 280:

  You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.

  The CDB has several pluggable databases (PDBs) open in the read/write mode.

  There are ongoing transactions in both the CDB and PDBs.

  What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

  A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
  B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
  C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
  D. The statement results in an error because there are open PDBs.
  B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

  ---

  *

  SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]

  Shuts down a currently running Oracle Database instance, optionally closing and dismounting a database. If the current database is a pluggable database, only the pluggable database is closed. The consolidated instance continues to run.

  Shutdown commands that wait for current calls to complete or users to disconnect such as SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the SHUTDOWN command will wait. If all events blocking the

  shutdown have not occurred within the time limit, the shutdown command cancels with the following message:

  ORA-01013: user requested cancel of current operation

  *

  If logged into a CDB, shutdown closes the CDB instance.

  To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that you want to close, and then enter

  SHUTDOWN

  Database closed. Database dismounted. Oracle instance shut down.

  To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command. SHUTDOWN Pluggable Database closed.

  Note:

  * Prerequisites for PDB Shutdown

  When the current container is a pluggable database (PDB), the SHUTDOWN command can only be used if:

  The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.

  The privilege is either commonly granted or locally granted in the PDB.

  The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG at connect time.

  To close a PDB, the PDB must be open.