[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 61-70

Get Full Version of the Exam

Question No.61

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

  1. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

  2. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

  3. Use the DBMS_PDB package to clone an existing PDB.

  4. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

  5. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 ( non-CDB database into an existing CDB.

Correct Answer: ACD


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 No.62

To implement Automatic Management (AMM), you set the following parameters:


When you try to start the database instance with these parameter settings, you receive the following error message:

SQL gt; startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

Identify the reason the instance failed to start.

  1. The PGA_AGGREGATE_TARGET parameter is set to zero.

  2. The STATISTICS_LEVEL parameter is set to BASIC.

  3. Both the SGA_TARGET and MEMORY_TARGET parameters are set.

  4. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Correct Answer: B Explanation: Example:

SQLgt; startup force

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

Question No.63

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)







Correct Answer: CE


Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and

TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.

Question No.64

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.)

  1. The ASM compatibility attribute controls the format of the disk group metadata.

  2. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

  3. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

  4. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

  5. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Correct Answer: ABD


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.


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 an volume in a disk group.

Question No.65

Your database is open and the listener LISTENER is up. You issue the command: LSNRCTLgt; RELOAD

What is the effect of RELOAD on sessions that were originally established by LISTENER?

  1. Only sessions based on static listener registrations are disconnected.

  2. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.

  3. The sessions are not affected and continue to function normally.

  4. All the sessions are terminated and active transactions are rolled back.

Correct Answer: C

Question No.66

Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)

  1. A segment cannot span data files.

  2. A data file can belong to only one tablespace.

  3. An extent cannot span data files.

  4. The size of an Oracle data block in a data file should be the same as the size of an OS block.

Correct Answer: BC


A single extent can never span data files. https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1095

Question No.67

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0


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







Correct Answer: AEF


Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter

The 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


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 No.68

You run a script that completes successfully using SQL*Plus that performs these actions:

  1. Creates a multitenant container database (CDB)

  2. Plugs in three pluggable databases (PDBs)

  3. Shuts down the CDB instance

  4. Starts up the CDB instance using STARTUP OPEN READ WRITE

Which two statements are true about the outcome after running the script? (Choose two.)

  1. The seed will be in mount state.

  2. The seed will be opened read-only.

  3. The seed will be opened read/write.

  4. The other PDBs will be in mount state.

  5. The other PDBs will be opened read-only.

  6. The PDBs will be opened read/write.

Correct Answer: BD


B: The seed is always read-only.

D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.

Question No.69

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.)

  1. Use Oracle Managed Files (OMF).

  2. Specify the SEED FILE_NAME_CONVERT clause.

  3. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

  4. Specify the DB_FILE_NAMECONVERT initialization parameter.

  5. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

Correct Answer: ABC


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

  1. Oracle Managed Files


  3. The PDB_FILE_NAME_CONVERT Initialization Parameter

Question No.70

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table#39;s indexes, to another tablespace.

The table does not have a primary key and is used by an OLTP application.

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

  1. Oracle Data Pump.

  2. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

  3. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

  4. Online Table Redefinition.

  5. Edition-Based Table Redefinition.

Correct Answer: D


Oracle Database provides a mechanism to make table structure modifications without

significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.

To redefine a table online:

Choose the redefinition method: by key or by rowid

By keySelect a primary key or pseudo-primary key to use for the redefinition. Pseudo- primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.

By rowidUse this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE … DROP UNUSED COLUMNS statement to drop it.

You cannot use this method on index-organized tables.


When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace.

Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.


Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF