Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 261:

  Which two are prerequisites for performing a flashback transaction? (Choose two.)

  A. Flashback Database must be enabled.
  B. Undo retention guarantee for the database must be configured.
  C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
  D. Supplemental logging must be enabled.
  E. Recycle bin must be enabled for the database.
  F. Block change tracking must be enabled tor the database.
  B. Undo retention guarantee for the database must be configured.
  D. Supplemental logging must be enabled.

  ---

  References: http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-Transaction-Queries https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS610

• Question 262:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  C. Tracking insert time by row for table rows
  D. Tracking the most recent write time for a table block
  E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
  F. Tracking the most recent write time for a table segment in the SYSAUX tablespace
  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  D. Tracking the most recent write time for a table block

  ---

  Incorrect:

  Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.

  *

  To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.

• Question 263:

  You execute the following PL/SQL:

  

  Which two statements are true? (Choose two.)

  A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
  B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
  C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
  D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
  A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
  B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

  ---

  DBMS_FGA.add_policy

  *

  The DBMS_FGA package provides fine-grained security functions.

  *

  ADD_POLICY Procedure

  This procedure creates an audit policy using the supplied predicate as the audit condition.

  Incorrect:

  Not C: object_schema

  The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)

• Question 264:

  In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

  

  You plan to execute the commands:

  

  Which two statements are true? (Choose two.)

  A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
  B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
  C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
  D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
  E. The MYTAB table is owned by the SYS user.
  B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
  E. The MYTAB table is owned by the SYS user.

• Question 265:

  Which two are true for databases running in ARCHIVELOG mode? (Choose two.)

  A. Archived redo log files can only be multiplexed to a maximum of ten local destinations.
  B. Inactive redo log groups must be archived before they can be reused.
  C. Archived redo log files can only be backed up when backing up the database.
  D. Archived redo log files get overwritten if the archived redo file destination is full.
  E. Archived redo log files can be multiplexed to a maximum of thirty destinations.
  A. Archived redo log files can only be multiplexed to a maximum of ten local destinations.
  B. Inactive redo log groups must be archived before they can be reused.

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/archredo.htm

• Question 266:

  Which statement is true about a database in ARCHIVELOG mode?

  A. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.
  B. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
  C. A Fast Recovery Area (FRA) must be configured for the database.
  D. Full database backups can be performed when the database is opened.
  D. Full database backups can be performed when the database is opened.

• Question 267:

  You are using RMAN to back up your database. All the data files are in read/write mode.

  Examine the RMAN configuration parameters:

  

  Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

  A. The backup can be used as an incremental level 0 backup.
  B. The database instance must be shut down to take the backup.
  C. The database must be in MOUNT state to take the backup.
  D. The backup consists of blocks that have been formatted.
  E. The system Change Number (SCN) is the same for all the data files in the backup.
  B. The database instance must be shut down to take the backup.
  E. The system Change Number (SCN) is the same for all the data files in the backup.

• Question 268:

  The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:

  

  HR then opens a second session.

  Which two operations wait when executed in HR's second session? (Choose two.)

  A. LOCK TABLE employees IN EXCLUSIVE MODE;
  B. INSERT INTO employees(empno,ename) VALUES (1289, `Dick');
  C. SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;
  D. SELECT empno,ename FROM employees WHERE job='CLERK';
  E. INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK);
  A. LOCK TABLE employees IN EXCLUSIVE MODE;
  C. SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;

• Question 269:

  Which three statements are true about user account administration? (Choose three.)

  A. A user's current session is not affected when the user's profile is changed.
  B. Only users with the SYSDBA privilege can change the tablespace quota for other users.
  C. A new user account can be created only by SYS or SYSTEM users.
  D. A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.
  E. A user requires only the CREATE SESSION privilege to change his or her own password.
  A. A user's current session is not affected when the user's profile is changed.
  D. A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.
  E. A user requires only the CREATE SESSION privilege to change his or her own password.

• Question 270:

  Identify three uses of the CROSSCHECK command (Choose three.)

  A. to validate the database backup
  B. to synchronize logical backup records with physical files in backup storage
  C. to check the obsolete backups that can be deleted from the file system
  D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
  E. to update the recovery catalog or control file if archived log files are deleted with operating system commands
  B. to synchronize logical backup records with physical files in backup storage
  D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
  E. to update the recovery catalog or control file if archived log files are deleted with operating system commands