Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 51:

  Which two are true about complete and incomplete recovery? (Choose two.)

  A. Uncommitted transactions will be rolled back after complete recovery completes.
  B. The database must have FLASHBACK enabled in order to perform incomplete recovery.
  C. Uncommitted transactions will be rolled back after incomplete recovery completes.
  D. Incomplete recovery is possible only when the database is open.
  E. Only incremental backups can be used to roll forward the database while performing complete recovery.
  A. Uncommitted transactions will be rolled back after complete recovery completes.
  E. Only incremental backups can be used to roll forward the database while performing complete recovery.

• Question 52:

  As the DBA, you execute this command:

  

  BROWN then executes this command:

  

  GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;

  Which is true?

  A. You can revoke only WITH GRANT OPTION from BROWN.
  B. BROWN can revoke only WITH GRANT OPTION from SCOTT.
  C. When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
  D. When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
  E. When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.
  B. BROWN can revoke only WITH GRANT OPTION from SCOTT.

• Question 53:

  Which two are true about undo tablespaces? (Choose two.)

  A. They can be recovered only when an instance is in MOUNT state.
  B. They are always owned by SYS.
  C. They must have only one data file.
  D. There can be multiple active undo tablespaces for a single instance database.
  E. SYSDBA users can create objects in them.
  C. They must have only one data file.
  D. There can be multiple active undo tablespaces for a single instance database.

• Question 54:

  Your client application and Oracle database are located on different hosts.

  Which statement is true about establishing a connection between them?

  A. Oracle Connection Manager must be installed on the client.
  B. Net service names must be configured on both the client and database servers.
  C. The Listener Control utility must be installed on the client if you are using the default listener on the server.
  D. Only Oracle Net can be used.
  E. Oracle Net Listener is required.
  D. Only Oracle Net can be used.

• Question 55:

  Which is a machine image in Oracle Cloud?

  A. the number of OCPUs and amount of memory allocated to an instance
  B. the physical persistent block storage space allocated to an instance
  C. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance
  D. a template of a virtual hard disk of specific size without an operating system installed
  E. a template of a virtual hard disk of specific size with an installed operating system
  E. a template of a virtual hard disk of specific size with an installed operating system

• Question 56:

  Which three object types support deferred segment creation? (Choose three.)

  A. partitioned tables
  B. external tables
  C. heap organized tables
  D. clustered tables
  E. index organized tables
  F. temporary tables
  A. partitioned tables
  C. heap organized tables
  E. index organized tables

• Question 57:

  Which two are true about the default listener for a single instance database? (Choose two.)

  A. It must be defined in the LISTENER.ORA file.
  B. It must support at least one service on startup.
  C. It must be defined by using the Listener Control utility.
  D. It listens on the default port 1521.
  E. It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.
  A. It must be defined in the LISTENER.ORA file.
  D. It listens on the default port 1521.

• Question 58:

  Which three types of files are created by expdp operations? (Choose three.)

  A. SQL files
  B. dump files
  C. reject files
  D. log files
  E. input data files
  F. bad files
  G. control files
  A. SQL files
  B. dump files
  D. log files

• Question 59:

  Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

  A. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode
  B. implementing FLASHBACK DATA ARCHIVE to decrease MTBF
  C. ensuring that critical components are protected by implementing redundancy
  D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode
  E. implementing FLASHBACK DATA ARCHIVE to decrease MTTR
  C. ensuring that critical components are protected by implementing redundancy
  D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

• Question 60:

  Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

  A. It contains undo only for uncommitted transactions.
  B. It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.
  C. It can be recovered while the instance is open in READ WRITE mode.
  D. It must be a smallfile tablespace.
  E. It is a locally managed tablespace.
  A. It contains undo only for uncommitted transactions.
  D. It must be a smallfile tablespace.