Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 101:

  Which statement is true about unified auditing?

  A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
  B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
  C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.
  D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.
  A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.

  ---

  References: https://docs.oracle.com/database/121/DBSEG/audit_admin.htm#DBSEG370

• Question 102:

  Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

  A. Enterprise Manager on port 1158
  B. telnet on port 23
  C. Cloud Control on port 7799
  D. SSH on port 22
  E. SSL/TLS on port 443
  D. SSH on port 22

• Question 103:

  An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.

  A multitenant container database (CDB) instant has the following parameter set:

  THREADED_EXECUTION = FALSE

  Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

  A. You can connect as a common user by using the connect statement.
  B. You can connect as a local user by using the connect statement.
  C. You can connect by using easy connect.
  D. You can connect by using OS authentication.
  E. You can connect by using a Net Service name.
  F. You can connect as a local user by using the SET CONTAINER statement.
  A. You can connect as a common user by using the connect statement.
  C. You can connect by using easy connect.
  D. You can connect by using OS authentication.
  E. You can connect by using a Net Service name.

• Question 104:

  You performed an incremental level 0 backup of a database:

  RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;

  To enable block change tracking after the incremental level 0 backup, you issued this command:

  SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

  ` /mydir/rman_change_track.f';

  To perform an incremental level 1 cumulative backup, you issued this command:

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which three statements are true? (Choose three.)

  A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  B. The change tracking file must always be backed up when you perform a full database backup.
  C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
  D. More than one database block may be read by an incremental backup for a change made to a single block.
  E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
  A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  D. More than one database block may be read by an incremental backup for a change made to a single block.
  E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

• Question 105:

  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.

  ---

  Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th« corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption

  occurs between blocks and can only be logical corruption.

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

  VALIDATE Command Output •

• Question 106:

  Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

  A. An extent contains data blocks that are always physically contiguous on disk.
  B. An extent can span multiple segments.
  C. Each data block always corresponds to one operating system block.
  D. It is possible to have tablespaces of different block sizes.
  E. A data block is the smallest unit of I/O in data files.
  D. It is possible to have tablespaces of different block sizes.
  E. A data block is the smallest unit of I/O in data files.

• Question 107:

  You are administering a database that supports an OLTP workload.

  The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.

  The user SCOTT queries a large table during peak activity.

  The query runs for more than 15 minutes and then SCOTT receives the following error:

  ORA-01555: snapshot too old

  Which is possible reason for this?

  A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
  B. The query is unable to place data blocks in the UNDO tablespace.
  C. The flashback data archive is not enabled for the table on which the query is issued.
  D. There is not enough space in Fast Recovery Area.
  E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.
  A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

• Question 108:

  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

• Question 109:

  Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)

  A. the private SQL area
  B. the Automatic Workload Repository (AWR)
  C. the Automatic Database Diagnostic Monitor (ADDM)
  D. the shared SQL area
  E. the SQL Access Advisor
  F. the AWR Compare Periods Report
  B. the Automatic Workload Repository (AWR)
  C. the Automatic Database Diagnostic Monitor (ADDM)
  E. the SQL Access Advisor

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/sql_tune.htm#i34782

• Question 110:

  Examine the following steps:

  A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user.

  Which statement is true?

  A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
  B. HR can grant the CREATE TABLE system privilege to other users.
  C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
  D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.
  C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.

  ---

  References: http://www.dba-oracle.com/t_with_grant_admin_privileges.htm