Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 11:

  Which two functions are performed by a listener?

  A. creating a user session in the System Global Area (SGA)

  B. verifying the service name in an incoming user request

  C. verifying a user's authentication credentials

  D. maintaining the connection to a client's user process until the user request is completed

  E. returning the results of processing from the server process to the user process

  F. connecting a user process to a server process

  Correct Answer: EF

• Question 12:

  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.

  Correct Answer: D

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN02803

• Question 13:

  In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:

  

  The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

  

  What is the result and why?

  A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.

  B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

  C. It fails because TESTDB has TBS1.

  D. It imports only EMP.

  E. It fails because TESTDB does not have TBS2 to create EMP_IDX.

  Correct Answer: B

• Question 14:

  For which three purposes is UNDO used? (Choose three.)

  A. flashback queries

  B. B. FLASHBACK TABLE TO BEFORE DROP operations

  C. the roll forward phase of instance recovery

  D. RESTORE DATABASE operations

  E. ROLLBACK operations

  F. read consistency

  Correct Answer: AEF

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/undo001.htm#ADMIN11460

• Question 15:

  Which two statements are true about Oracle Data Pump? (Choose two.)

  A. expdp and impdp are its client components.

  B. impdp always uses conventional path inserts when importing data.

  C. The DBMS_DATAPUMP package can be used only with Data Pump clients

  D. It cannot be used to export data as of a previous SCN.

  E. impdp can change target data file names, schemas, and tablespaces during import.

  Correct Answer: AC

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 16:

  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.

  Correct Answer: D

• Question 17:

  Which two are prerequisites for shrinking a table online?

  A. It must have a unique key constraint.

  B. It must not have any referential integrity constraints.

  C. It must not have any DML triggers.

  D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .

  E. It must have row movement enabled.

  Correct Answer: AB

• Question 18:

  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

  Correct Answer: ACE

• Question 19:

  Which is always true about privileges?

  A. Connections as SYSTEM can use only the SYSOPER privilege.

  B. Connections as SYS must be made using the SYSDBA privilege

  C. System privileges can be granted only to users.

  D. The owner of a schema is granted all object privileges within the schema by default.

  E. The SYSDBA privilege can be granted to a user or role.

  Correct Answer: D

  A user automatically has all object privileges for schema objects contained in his or her schema. A user can grant any object privilege on any schema object he or she owns to any other user or role. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any specified object privilege to another user with or without the GRANT OPTION of the GRANT statement. Otherwise, the grantee can use the privilege, but cannot grant it to other users.

  Reference: https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1010570

• Question 20:

  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.

  Correct Answer: E