Oracle Database 12cR2 Administration - 1Z0-072 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two are segment types? (Choose two.)

A. table partition B. materialized views on a prebuilt container C. stored procedure D. view E. sequence F. table

Discussion 0

Correct Answer: A,F Vote an answer

Question 2

Which is true about roles?

A. Roles can be created only by SYS or SYSTEM. B. A role can be password-protected only if it has been granted system privileges. 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 granted to other roles.

Discussion 0

Correct Answer: B Vote an answer

Question 3

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

A. encryption for all backups B. automatic daily full database backups C. encryption of backups only for High Performance and Extreme Performance database versions D. encryption of backups only for Enterprise Edition databases E. RMAN incremental backups in a seven-day cycle F. on-demand backups that need to be scheduled

Discussion 0

Correct Answer: C,E Vote an answer

Question 4

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

A. expdp and impdp are its client components. B. The DBMS_DATAPUMP package can be used only with Data Pump clients C. It cannot be used to export data as of a previous SCN. D. impdp can change target data file names, schemas, and tablespaces during import. E. impdp always uses conventional path inserts when importing data.

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

Examine this command and its partial output:

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 6

Which two are true about conventional path SQL load? (Choose two.)

A. It cannot load data into clustered tables. B. It always generates redo. C. It locks objects being processed. D. It does not generate UNDO. E. It enforces referential integrity constraints.

Discussion 0

Correct Answer: D,E Vote an answer

Question 7

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:
[oracle@host01 ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp The TESTDB database has a TBS1 tablespace but no TBS2.
The SYSTEM user in TESTDB executes this command:
[oracle@host01 ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1 What is the result and why?

A. It fails because TESTDB does not have TBS2 to create EMP_IDX. B. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX. C. It fails because TESTDB has TBS1. D. It imports only EMP. E. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

Discussion 0

Correct Answer: E Vote an answer

Question 8

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
DROP TABLESPACE tbs1;
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

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

Discussion 0

Correct Answer: D Vote an answer

Question 9

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

A. V$SESSION_EVENT B. V$SESSION_WAIT C. V$SESSION_WAIT_CLASS D. V$SYSTEM_EVENT E. V$SESSION

Discussion 0

Correct Answer: A,B Vote an answer