Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 71:

  Examine these commands: What is the expected result?

  

  A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

  B. Only the first row in EMP.DAT is inserted into U1.EMP.

  C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

  D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

  E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

  Correct Answer: D

• Question 72:

  Examine this command:

  

  Which two changes must you make so that TEMP_TBS is created? (Choose two.)

  A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.

  B. Add the NOLOGGING clause.

  C. Remove the SEGMENT MANAGEMENT AUTO clause.

  D. Remove the AUTOEXTEND ON clause.

  E. Remove the ONLINE clause.

  F. Add MAXSIZE for the AUTOEXTEND ON clause.

  Correct Answer: AF

  Reference: https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:374218170986

• Question 73:

  Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

  A. encryption of backups only for Enterprise Edition databases

  B. automatic daily full database backups

  C. RMAN incremental backups in a seven-day cycle

  D. encryption of backups only for High Performance and Extreme Performance database versions

  E. on-demand backups that need to be scheduled

  F. encryption for all backups

  Correct Answer: CD

• Question 74:

  Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

  A. They reveal the cause of performance problems.

  B. They are grouped into classes.

  C. They are maintained at the session and system level.

  D. They display how often a database instance performs particular operations.

  E. All events might be used by an instance regardless of parameter settings.

  Correct Answer: AB

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1117.htm#REFRN30079

• Question 75:

  Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

  A. It can be granted to any user and any role.

  B. It is overridden by any specified user space quota.

  C. It allows a user to have unlimited space in any tablespace in the database.

  D. It allows a user to have unlimited space only in his or her default permanent tablespace.

  E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

  Correct Answer: C

  Reference: https://developer.ibm.com/answers/questions/301800/is-it-required-to-grant-unlimitedtablespace-permi/

• Question 76:

  Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.)

  A. It applies only to tablespaces with uniform extent size.

  B. It overrides the DEFAULT STORAGE clause specified for a tablespace.

  C. It specifies whether used and free extents are tracked using free lists or bitmaps.

  D. It specifies whether users have direct control over space allocation for the objects in a tablespace.

  E. It applies only to permanent tablespaces.

  F. It applies only to smallfile tablespaces.

  Correct Answer: CD

• Question 77:

  Examine the command:

  

  Which two are true? (Choose two.)

  A. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.

  B. USER1 requires a quota to be able to store objects in the default permanent tablespace.

  C. USER1 will be prompted for a new passport at first login.

  D. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.

  E. USER1's account is locked.

  Correct Answer: BD

• Question 78:

  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.

  Correct Answer: AD

• Question 79:

  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.

  Correct Answer: CD

• Question 80:

  The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different

  locations.

  Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

  Examine this command:

  

  How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

  A. as SCOTT in BOSTON_DB

  B. as SYS in both the databases

  C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

  D. as SCOTT in both the databases

  E. as SCOTT in DALLAS_DB

  Correct Answer: D