Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 71:

  Which two statements are true when row archival management is enabled?

  A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

  ---

  http://gavinsoorma.com/2013/08/oracle-12c-new-feature-in-database-archiving/

• Question 72:

  You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:

  RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION `+RECO';

  Which five steps are performed by RMAN?

  A. truncating the SCOTT.EMP table in the original database
  B. exporting the SCOTT.EMP table from the auxiliary database
  C. flashing back the original database to the desired point in time
  D. recovering the auxiliary database to the desired point in time
  E. creating an auxiliary instance
  F. importing the SCOTT.EMP table into the original database
  G. restoring the tablespaces required for point-in-time recovery
  H. dropping the SCOTT.EMP table in the original database
  C. flashing back the original database to the desired point in time
  D. recovering the auxiliary database to the desired point in time
  E. creating an auxiliary instance
  F. importing the SCOTT.EMP table into the original database
  G. restoring the tablespaces required for point-in-time recovery

• Question 73:

  Your database runs in NOARCHIVELOG mode.

  Whole database backups are taken daily.

  A media failure damages data files belonging to the USERS tablespace and the online redo log files.

  The hardware that is causing this damage is not repairable.

  You issue the SHUTDOWN ABORT command.

  Examine these steps:

  1.

  Restore only the damaged files from the whole database backup to a new location.

  2.

  Restore the whole database backup to a new location.

  3.

  Edit the restored initialization parameter file to indicate the new location of the control files.

  4.

  Issue the STARTUP MOUNT command.

  5.

  Issue the STARTUP NOMOUNT command.

  6.

  Issue the RECOVER DATABASE command.

  7.

  Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME FILE command.

  8.

  Specify a new location for each affected online log by issuing the command: RECOVER DATABASE UNTIL CANCEL

  9.

  Open the database in RESETLOGS mode.

  Identify the minimum steps required in the correct sequence to recover your database.

  A. 1, 3, 5, 8, 9
  B. 1, 4, 7, 8, 9
  C. 1, 3, 4, 6
  D. 2, 5, 6, 7, 9
  B. 1, 4, 7, 8, 9

• Question 74:

  Oracle Data Redaction is active on the SCOTT.EMP table.

  You queried the table twice.

  SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

  

  SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

  

  Which is guaranteed to be true concerning the redaction policy?

  A. FULL redaction is active on the SAL column B. RANDOM redaction is active on the MGR column
  C. RANDOM redaction is active on the HIREDATE column
  D. PARTIAL redaction is active on the MGR column.
  E. PARTIAL redaction is active of the HIREDATE column.
  A. FULL redaction is active on the SAL column B. RANDOM redaction is active on the MGR column

• Question 75:

  Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.

  The steps to recover the tablespace are as follows:

  1.

  Mount the CDB.

  2.

  Close all the PDBs.

  3.

  Open the database.

  4.

  Apply the archive redo logs.

  5.

  Restore the data file.

  6.

  Take the SYSAUX tablespace offline.

  7.

  Place the SYSAUX tablespace online.

  8.

  Open all the PDBs with RESETLOGS.

  9.

  Open the database with RESETLOGS.

  10.

  Execute the command SHUTDOWN ABORT.

  Which option identifies the correct sequence to recover the SYSAUX tablespace?

  A. 6, 5, 4, 7
  B. 10, 1, 2, 5, 8
  C. 10, 1, 2, 5, 4, 9, 8
  D. 10, 1, 5, 8, 10
  A. 6, 5, 4, 7

  ---

  RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;

  RMAN> RESTORE TABLESPACE sysaux;

  RMAN> RECOVER TABLESPACE sysaux;

  RMAN> ALTER TABLESPACE sysaux ONLINE;

  *

  Example:

  While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost".

  Cannot close the pdb as the system datafile was missing...

  So only option to recover was:

  Shutdown cdb (10)

  startup mount; (1)

  restore pluggable database

  recover pluggable database

  alter database open;

  alter pluggable database name open;

  Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.

  *

  Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:

  / Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances) / After shutting down the database using SHUTDOWN ABORT

  Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.

  * Open the database with the RESETLOGS option after finishing recovery: SQL> ALTER DATABASE OPEN RESETLOGS;

• Question 76:

  Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

  A. A DBA can check specific tables with the DMU
  B. The database to be migrated must be opened read-only.
  C. The release of the database to be converted can be any release since 9.2.0.8.
  D. The DMU can report columns that are too long in the converted characterset.
  E. The DMU can report columns that are not represented in the converted characterset.
  A. A DBA can check specific tables with the DMU
  D. The DMU can report columns that are too long in the converted characterset.
  E. The DMU can report columns that are not represented in the converted characterset.

  ---

  A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.

  D: Exceed column limit

  The cell data will not fit into a column after conversion.

  E: Need conversion

  The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

  * Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode. Incorrect Answers:

  C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.

• Question 77:

  The current system change number (SCN) for a live database is 663571.

  You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.

  After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.

  Which is the fastest way to do this?

  A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
  B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.
  C. Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
  D. Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
  B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.

• Question 78:

  Which two statements are true about variable extent size support for large ASM files?

  A. The metadata used to track extents in SGA is reduced.
  B. Rebalance operations are completed faster than with a fixed extent size
  C. An ASM Instance automatically allocates an appropriate extent size.
  D. Resync operations are completed faster when a disk comes online after being taken offline.
  E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
  A. The metadata used to track extents in SGA is reduced.
  C. An ASM Instance automatically allocates an appropriate extent size.

  ---

  A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases (A), and improve performance for file create and open operations.

  C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size. Note:

  *

  The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.

  *

  The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher.

• Question 79:

  In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?

  A. Setting a metric threshold
  B. Implementing Database Resource Manager
  C. Enabling resumable timeout for user sessions
  D. Decreasing the value of the IDLE_TIME resource limit in the default profile
  B. Implementing Database Resource Manager

  ---

  http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11844

• Question 80:

  You notice that the performance of your production 24/7 Oracle 12c database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.

  How can you detect the cause of the degraded performance?

  A. Enable Memory Access Mode, which reads performance data from SGA.
  B. Use emergency monitoring to fetch data directly from SGA analysis.
  C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
  D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
  E. Run ADDM in diagnostic mode.
  B. Use emergency monitoring to fetch data directly from SGA analysis.