Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 61:

  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.

  Correct Answer: AB

  Reference: http://www.acehints.com/2011/05/oracle-data-pump-advantages.html

• Question 62:

  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.

  Correct Answer: D

  Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97970

• Question 63:

  orcl.dmp contains a full export of the ORCL database.

  This command is executed to load data from orcl.dmp into the TESTDB database:

  

  Which two are true? (Choose two.)

  A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.

  B. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.

  C. It skips all indexes of ORCL:SH and ORCL:OE.

  D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

  E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

  Correct Answer: DE

• Question 64:

  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.

  Correct Answer: AD

• Question 65:

  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.

  Correct Answer: DE

• Question 66:

  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.

  Correct Answer: AC

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10004.htm

• Question 67:

  Which two tasks can you perform by using DBCA for a new database?

  A. Register it with an available Enterprise Manager Management server.

  B. Configure a nonstandard block size.

  C. Configure incremental backups.

  D. Enable flashback.

  E. Create user tablespaces.

  Correct Answer: AE

• Question 68:

  When is a SID_LIST_ section required in a LISTENER.ORA file?

  A. when the listener uses multiple port numbers for different database instances

  B. when a static listener is used

  C. when a dynamic listener is used

  D. when multiple dynamic listeners are used

  E. when the list of existing database services must be defined

  Correct Answer: B

  You can use the SID_LIST section of the listener.ora to statically configure service information for the listener.

  Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm#NETRF300

• Question 69:

  Which three are true about Oracle Managed Files (OMF)? (Choose three.)

  A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.

  B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

  C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

  D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

  E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.

  F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

  Correct Answer: ABF

• Question 70:

  Which two are true about Oracle recovery and data protection solutions? (Choose two.)

  A. RMAN can be used to FLASHBACK a database.

  B. RMAN can be used to roll back committed transactions.

  C. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.

  D. Data Recovery Advisor can be used to validate backup strategies.

  E. Oracle Data Guard can prevent data loss caused by a site failure.

  Correct Answer: AE