Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 51:

  You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:

  

  Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.
  D. The valid time columns are visible by default when the table is described.
  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

  ---

  A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the

  existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating

  them internally.

  E: ENABLE_AT_VALID_TIME Procedure

  This procedure enables session level valid time flashback.

• Question 52:

  Which two are true concerning a multitenant container database with three pluggable databases?

  A. Pluggable databases in the same container database (CDB) each have their own buffer cache
  B. Pluggable databases can make database consolidation easier
  C. All administration tasks must be done to each pluggable database.
  D. Pluggable databases increase patching time.
  E. Pluggable databases are patched together
  B. Pluggable databases can make database consolidation easier
  E. Pluggable databases are patched together

• Question 53:

  You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by using SQL*Plus.

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

  There are ongoing transactions in both the CDB and the PDBs.

  What happens after issuing the SHUTDOWN TRANSACTIONAL statement?

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

• Question 54:

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

  A. The seed will be in MOUNT state.
  B. The seed will be opened read-only.
  C. The seed will be opened read/write.
  D. The other PDBs will be in mount state.
  E. The other PDBs will be opened read-only.
  F. The PDBs will be opened read/write.
  B. The seed will be opened read-only.
  D. The other PDBs will be in mount state.

  ---

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

  You use a recovery catalog for maintaining your database backups.

  You execute the following command: Which two statements are true? (Choose two.)

  

  A. Corrupted blocks, if any, are repaired.
  B. Checks are performed for physical corruptions.
  C. Checks are performed for logical corruptions.
  D. Checks are performed to confirm whether all database files exist in correct locations
  E. Backup sets containing both data files and archive logs are created.
  B. Checks are performed for physical corruptions.
  D. Checks are performed to confirm whether all database files exist in correct locations

  ---

  B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows: RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

  This form of the command would check for physical corruption. To check for logical corruption, RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

  D: You can use the VALIDATE keyword of the BACKUP command to do the following:

  Check datafiles for physical and logical corruption

  Confirm that all database files exist and are in the correct locations.

  Note:

  You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When

  performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).

• Question 56:

  Which three statements are true about RMAN compressed backups?

  A. Media manager compression should not be enabled if compressed backups are being written to tape.
  B. Compressed backups can be written to media only if using proxy copies.
  C. File system compression should be enabled if compressed backups are being written to disk.
  D. Compression creates some performance overhead during backups to tape.
  E. Compression creates some performance overhead during backups to disk.
  B. Compressed backups can be written to media only if using proxy copies.
  C. File system compression should be enabled if compressed backups are being written to disk.
  E. Compression creates some performance overhead during backups to disk.

• Question 57:

  Which three activities are supported by the Data Recovery Advisor? (Choose three.)

  A. Advising on block checksum failures
  B. Advising on inaccessible control files
  C. Advising on inaccessible block change tracking files
  D. Advising on empty password files
  E. Advising on invalid block header field values
  A. Advising on block checksum failures
  B. Advising on inaccessible control files
  E. Advising on invalid block header field values

  ---

  *

  Data Recovery Advisor can diagnose failures such as the following: / (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on / (A, E) Physical corruptions such as block checksum failures and invalid block header field values / Inconsistencies such as a datafile that is older than other database files / I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)

  *

  The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

• Question 58:

  Which two statements are true about Oracle Direct Network File System (NFS)?

  A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.
  B. It utilizes the operating system file system cache.
  C. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.
  D. The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS.
  E. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.
  C. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.
  E. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.

• Question 59:

  You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

  Which three storage options support the use of HCC? (Choose three.)

  A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
  B. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
  C. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
  D. Database files stored in ZFS and accessed using conventional NFS mounts.
  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
  F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
  A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

  ---

  HCC requires the use of Oracle Storage ?Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).

  Note:

  *

  Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above

  *

  Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

• Question 60:

  Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

  A. Bind Variable Peeking
  B. SQL Plan Baselines
  C. Adaptive Cursor Sharing
  D. Bind variable used in a SQL statement
  E. Literals in a SQL statement
  A. Bind Variable Peeking
  C. Adaptive Cursor Sharing
  E. Literals in a SQL statement

  ---

  * In bind variable peeking (also known as bind peeking), the optimizer looks at the value in a bind variable when the database performs a hard parse of a statement.

  When a query uses literals, the optimizer can use the literal values to find the best plan. However, when a query uses bind variables, the optimizer must select the best plan without the presence of literals in the SQL text. This task can be extremely difficult. By peeking at bind values the optimizer can determine the selectivity of a WHERE clause condition as if literals had been used, thereby improving the plan.

  C: Oracle 11g/12g uses Adaptive Cursor Sharing to solve this problem by allowing the server to compare the effectiveness of execution plans between executions with different bind variable values. If it notices suboptimal plans, it allows certain bind variable values, or ranges of values, to use alternate execution plans for the same statement. This functionality requires no additional configuration.