Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 61:

  A user complains about poor database performance. You suspect that the user's session is losing time waiting for events to complete.

  You want to verify this.

  Which view reveals on what events a session has spent time waiting in the past?

  A. V$SESSION_WAIT_CLASS
  B. V$SYSTEM_EVENT
  C. V$SESSION
  D. V$SESSION_EVENT
  E. V$SESSION_WAIT
  C. V$SESSION

• Question 62:

  Examine this extract from the show parameters command:

  

  How are SGA and PGA memory managed by an instance using these parameter settings?

  A. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.
  B. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.
  C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).
  D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.
  E. SGA and PGA memory are manually managed.
  C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).

• Question 63:

  In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.

  UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.

  Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?

  A. It succeeds and the generated undo is stored in SYSAUX.
  B. It succeeds and the generated undo is stored in TEMP.
  C. It fails and returns the error message "Snapshot too old".
  D. It succeeds and the generated undo is stored in SYSTEM.
  E. It fails and returns the error message "ORA=30036": unable to extend segment by 8 in undo tablespace `UNDOTBS1'".
  F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.
  F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.

• Question 64:

  Which two are true about the roles? (Choose two.)

  A. All privileges and roles granted to a user are enabled by default when the user logs in.
  B. The SET ROLE statement can be used once per session.
  C. The SET ROLE statement enables as well as disables roles in a session.
  D. A role must be disabled before it can be revoked from a user.
  E. The ALTER USER statement must be used to set specific default roles for a user.
  A. All privileges and roles granted to a user are enabled by default when the user logs in.
  C. The SET ROLE statement enables as well as disables roles in a session.

• Question 65:

  Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

  A. Only users granted SYSDBA can query or update tables in all user schemas.
  B. Only users granted SYSDBA can take a complete backup of a database.
  C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.
  D. Users granted either SYSDBA or SYSOPER can mount or open a database.
  E. Only users granted SYSDBA can start up and shut down a database instance.
  F. Users granted either SYSDBA or SYSOPER can query data in all user schemas.
  B. Only users granted SYSDBA can take a complete backup of a database.
  C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.

• Question 66:

  What three are true about Oracle Flashback technology? (Choose three.)

  A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
  B. FLASHBACK TABLE can be used to rewind a table back in time.
  C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
  D. FLASHBACK TABLE can be used to undo dropping a column from a table.
  E. FLASHBACK QUERY can be used to view committed data at any given point in time.
  A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
  C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
  D. FLASHBACK TABLE can be used to undo dropping a column from a table.

• Question 67:

  A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.

  You want to verify this.

  Which two views may reveal for what the user's session is currently waiting? (Choose two.)

  A. V$SYSTEM_EVENT
  B. V$SESSION_EVENT
  C. V$SESSION_WAIT_CLASS
  D. V$SESSION_WAIT
  E. V$SESSION
  B. V$SESSION_EVENT
  D. V$SESSION_WAIT

• Question 68:

  Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

  A. Third-party tools can be used with database instances in the cloud.
  B. Oracle-supplied tools can be used with database instances in the cloud.
  C. Database instances in the cloud can be accessed only by using SSH.
  D. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.
  E. Database instances in the cloud can be accessed only by using Oracle*Net.
  B. Oracle-supplied tools can be used with database instances in the cloud.
  C. Database instances in the cloud can be accessed only by using SSH.

• Question 69:

  Which two are true about instance recovery? (Choose two.)

  A. It is guaranteed to complete within fast_start_mttr_target number of seconds.
  B. Archived REDO log files are required to perform instance recovery.
  C. The database opens after the roll forward phase of instance recovery.
  D. It is performed when mounting a database.
  E. Archived REDO log files are never required to perform instance recovery.
  F. It occurs after a SHUTDOWN IMMEDIATE.
  A. It is guaranteed to complete within fast_start_mttr_target number of seconds.
  C. The database opens after the roll forward phase of instance recovery.

• Question 70:

  Which statement is true about database links?

  A. Private database link creation requires the same user to exist in both the local and the remote database.
  B. A database link can be created only between Oracle databases.
  C. A public database link can be used by a user in the local database to connect to any schema in the remote database.
  D. A database link created in a database allows a connection from that database instance to another, but not vice versa.
  E. A public database link can be created only by SYS.
  D. A database link created in a database allows a connection from that database instance to another, but not vice versa.