Oracle 1Z0-072 Online Practice Questions and Exam Preparation

Oracle 1Z0-072 Online Questions & Answers

• Question 1:

  What two are benefits of Data Pump? (Choose two.)

  A. It can execute in parallel.
  B. It can restart failed export jobs.
  C. It makes use of client system resources.
  D. It can export data into sequential media, such as tapes.
  E. It represents database metadata information as DDL statements in the dump file.
  A. It can execute in parallel.
  B. It can restart failed export jobs.

• Question 2:

  Which is true about roles?

  A. A role can be granted to other roles.
  B. Roles can be created only by SYS or SYSTEM.
  C. Roles containing object privileges can be created only by the object owner.
  D. All roles belong to the SYSTEM schema.
  E. A role can be password-protected only if it has been granted system privileges.
  E. A role can be password-protected only if it has been granted system privileges.

• Question 3:

  Which is true about unexpired undo?

  A. It is required when a transaction rolls back.
  B. It may be used to support flashback queries.
  C. It consists of undo only for uncommitted transactions.
  D. It is always retained for the time specified in UNDO__RETENTION.
  E. It is the first type of undo overwritten when trying to avoid out-of-space errors.
  D. It is always retained for the time specified in UNDO__RETENTION.

• Question 4:

  Which statement is true about smallfile tablespaces?

  A. Extent location metadata is stored in the data dictionary by default.
  B. The number of data files is constrained only by the size of the storage array.
  C. Maximum file size can be set to unlimited only if the logical volume manager supports striping.
  D. Segments can span multiple tablespaces.
  E. Segments can span multiple data files.
  E. Segments can span multiple data files.

• Question 5:

  Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

  A. control files
  B. bad files
  C. input files
  D. password files
  E. server parameter files (SPFILE)
  F. dump files
  B. bad files
  C. input files
  D. password files

• Question 6:

  Which action helps in applying the principle of least privilege?

  A. disabling audit for users with system privileges
  B. revoking all system privileges from the SYSTEM user
  C. setting the REMOTE_OS_AUTHENT parameter to true
  D. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true
  E. restricting access to directory objects in the database
  E. restricting access to directory objects in the database

• Question 7:

  You execute this command to connect to an instance from a client on a different machine:

  

  No name servers are configured.

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

  A. It must contain the address protocol for only one listener.
  B. It must contain only one address protocol for one listener.
  C. It must be defined in the tnsnames.ora file on the client side.
  D. It must be defined in the tnsnames.ora file on the server side.
  E. It must have the same name as the SERVICE_NAME defined in it.
  D. It must be defined in the tnsnames.ora file on the server side.
  E. It must have the same name as the SERVICE_NAME defined in it.

• Question 8:

  DATADIR1 and DATADIR2 are database directory objects.

  Examine this command:

  

  Which two are true about the expdp operation? (Choose two.)

  A. It creates a dump file for the entire database.
  B. It fails if the total size of the dump file is more than 2 GB.
  C. It creates a dump file only for objects in the SYSTEM schema.
  D. It creates a master table to store details of the export operation.
  E. It starts only when four worker processes are available.
  A. It creates a dump file for the entire database.
  E. It starts only when four worker processes are available.

• Question 9:

  Examine this command and its partial output:

  

  Why does the DB01.abc.com service show unknown status?

  A. The listener does not listen on the default port 1521.
  B. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.
  C. The service is dynamically registered.
  D. The service is statically registered.
  E. The LOCAL_LISTENER parameter list does not contain LISTENER_1.
  B. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.

• Question 10:

  Which is true about revoking roles?

  A. Only users who are granted the DBA role can revoke a role.
  B. Only users who are granted SYSDBA can revoke a role.
  C. Users who have the GRANT ANY ROLE privilege can revoke any role.
  D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.
  E. Users can revoke a role that is granted to them through other roles.
  D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.