Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 41:

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

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

• Question 42:

  Which two are true about direct path load?

  A. It enforces only primary key, unique, and not NULL, constraints.
  B. DML statements may occur on tables being loaded.
  C. It fires insert triggers, if any.
  D. It writes only to blocks above the high-water mark.
  E. It uses the database buffer cache.
  B. DML statements may occur on tables being loaded.
  C. It fires insert triggers, if any.

• Question 43:

  You execute this command:

  

  Which two statements are true about the SALES tablespace? (Choose two.)

  A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
  B. It is read-only by default.
  C. DML operations performed on objects in this tablespace are not logged by default.
  D. It uses the default blocksize used at database creation.
  E. It is a locally managed tablespace.
  F. It is offline by default.
  A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
  D. It uses the default blocksize used at database creation.

• Question 44:

  Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

  

  Which two actions are performed? (Choose two.)

  A. The control file is read.
  B. The online data files are opened.
  C. The online redo logs are opened.
  D. The Oracle background processes are started.
  E. The alert log records the execution details.
  F. The initialization parameter file is read.
  A. The control file is read.
  D. The Oracle background processes are started.

• Question 45:

  Which two types of files are opened by a database instance in the NOMOUNT state?

  A. control files
  B. the alert log
  C. the initialization parameter file
  D. data files
  E. online redo logs
  C. the initialization parameter file
  D. data files

• Question 46:

  Which two are true about RETENTION GUARANTEE? (Choose two.)

  A. It is a tablespace attribute.
  B. It prevents FLASHBACK DATABASE operation failure.
  C. It prevents out-of-space errors.
  D. It prevents "Snapshot too old" errors.
  E. It is a static parameter.
  A. It is a tablespace attribute.
  B. It prevents FLASHBACK DATABASE operation failure.

• Question 47:

  In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.

  Examine this command: Which table segments are created?

  

  A. T1 and an index segment created for the primary key only
  B. T1, an index segment for the primary key, a LOB segment, and lobindex segment
  C. T1 only
  D. T1, an index segment for the primary key, and a LOB segment only
  D. T1, an index segment for the primary key, and a LOB segment only

• Question 48:

  Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  A. re-creating control files
  B. full database recovery
  C. enabling online redo log archiving
  D. renaming data files
  E. creating a database
  A. re-creating control files
  E. creating a database

• Question 49:

  TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). Examine this command:

  

  Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

  A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
  B. TBS1 must be placed in READ ONLY state.
  C. Objects in TBS1 must not be in use when the command is executed.
  D. TBS1 must not contain any temp files.
  E. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
  A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.

• Question 50:

  Which two tasks does DBUA perform by default? (Choose two.)

  A. setting user tablespaces to "read only" before starting the upgrade
  B. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade
  C. running the Pre-Upgrade information tool
  D. starting the source database instance if not started
  E. enabling flashback in the source database if not enabled
  A. setting user tablespaces to "read only" before starting the upgrade
  C. running the Pre-Upgrade information tool