Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 121:

  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?

  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.

  ---

  A, D: 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.

  Incorrect Answers:

  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 122:

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

  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 11g 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.
  D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

• Question 123:

  Which two statements are true about the RMAN VALIDATE DATABASE command? (Choose two.)

  A. It checks the database for intrablock corruptions.
  B. It can detect corrupt pfiles.
  C. It can detect corrupt spfiles.
  D. It checks the database for interblock corruptions.
  E. It can detect corrupt block change tracking files.
  A. It checks the database for intrablock corruptions.
  C. It can detect corrupt spfiles.

  ---

  (key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption. VALIDATE Command Output •

• Question 124:

  Examine the following command:

  

  Which three statements are true about using an invisible column in the PRODUCTS table?

  A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  C. Referential integrity constraint cannot be set on the invisible column.
  D. The invisible column cannot be made visible and can only be marked as unused.
  E. A primary key constraint can be added on the invisible column.
  A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  E. A primary key constraint can be added on the invisible column.

  ---

  AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output:

  *

  SELECT * FROM statements in SQL

  *

  DESCRIBE commands in SQL*Plus

  *

  %ROWTYPE attribute declarations in PL/SQL

  *

  Describes in Oracle Call Interface (OCI) Incorrect Answers:

  D: You can make invisible columns visible.

  You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.

• Question 125:

  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

  ---

  Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. It is supported in Oracle 11g. Incorrect Answers:

  A: Using Transportable database with the "FULL=Y TRANSPORTABLE=ALWAYS VERSION=12" parameters allows you to plug in an 11.2.0.3 or later non-CDB 11g database, not an 11.2.0.2.0 database.

  D: The DBMS_PDB package allows you to generate an XML metadata file from a non-CDB 12c database. This allows the non-CDB to be plugged in as a PDB into an existing CDB. However, the non-CBD is an 11g (11.2.0.2.0) database.

• Question 126:

  You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.

  You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.

  Which three findings would you get from the report?

  A. It detects any configuration change that caused a performance difference in both time periods.
  B. It identifies any workload change that caused a performance difference in both time periods.
  C. It detects the top wait events causing performance degradation.
  D. It shows the resource usage for CPU, memory, and I/O in both time periods.
  E. It shows the difference in the size of memory pools in both time periods.
  F. It gives information about statistics collection in both time periods.
  A. It detects any configuration change that caused a performance difference in both time periods.
  B. It identifies any workload change that caused a performance difference in both time periods.
  D. It shows the resource usage for CPU, memory, and I/O in both time periods.

  ---

  Keyword: shows the difference.

  *

  Full ADDM analysis across two AWR snapshot periods Detects causes, measure effects, then correlates them Causes: workload changes, configuration changes Effects: regressed SQL, reach resource limits (CPU, I/O, memory, interconnect) Makes actionable recommendations along with quantified impact

  *

  Identify what changed / Configuration changes, workload changes

  *

  Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.

  While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference (ABE) between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.

• Question 127:

  In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

  Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

  A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  D. Setting the target tablespace to read-only after the segments are moved
  E. Taking the target tablespace offline after the segments are moved
  C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
  D. Setting the target tablespace to read-only after the segments are moved

• Question 128:

  You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the MD_BACKUP command to back up the ASM metadata regularly.

  You lose an ASM disk group DG1 due to a hardware failure.

  In which two ways can you re-create the lost disk group and restore the data? (Choose two.)

  A. Use RMAN to restore both the metadata and the data.
  B. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.
  C. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
  D. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.
  B. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.
  D. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.

• Question 129:

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

  Which three tools can be used to add a new PDB to the CDB? (Choose three.)

  A. Enterprise Manager Cloud Control
  B. SQL Developer
  C. Database Upgrade Assistant (DBUA)
  D. Database Configuration Assistant (DBCA)
  E. Oracle Universal Installer (OUI)
  A. Enterprise Manager Cloud Control
  B. SQL Developer
  D. Database Configuration Assistant (DBCA)

• Question 130:

  Examine the contents of SQL loader control file:

  

  Which three statements are true regarding the SQL* Loader operation performed using the control file?

  A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
  B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
  C. The SQL* Loader operation fails because no record terminators are specified.
  D. Field names should be the first line in the both the SQL* Loader data files.
  E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
  A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
  B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
  E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

  ---

  A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.

  B (not D): Note:

  * SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record

  Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed.

  Action: Check the listed data file and fix it. Then retry the operation

  E:

  *

  A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the

  file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other

  character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.

  *

  Fields with embedded commas must be quoted.

  Example:

  1997,Ford,E350,"Super, luxurious truck"

  Note:

  *

  SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.