Oracle Database 12cR2 Administration 1Z0-072 Exam Dumps

1. The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.

UNDOTBS2 is the active undo tablespace.

Examine these commands:

USER1executes DML, which generates more than 2 MB of UNDO.

What is the result and why?

2. Which three failures require intervention for recovery? (Choose three.)

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

4. Your client application and Oracle database are located on different hosts.

Which statement is true about establishing a connection between them?

5. 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:

[[email protected] ~]$ 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:

[[email protected] ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1

What is the result and why?

6. In your database, you create a user, HR, and then execute this command:

GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which three actions can HR perform? (Choose three.)

7. 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?

8. Which three types of files are created by expdp operations? (Choose three.)

9. DATADIR1 and DATADIR2 are database directory objects.

Examine this command:

[[email protected] ~] expdp system/oracle

> FULL=y

> DUMPFILE=datadir1: full%U.dmp, datadir2: full2%U.dmp

> FILESIZE=2G

> PARALLEL=4

> LOGFILE= datadir1:/expfull.log

> JOB_NAME= expfull

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

10. Which statement is true about smallfile tablespaces?

11. Which two are true about RETENTION GUARANTEE? (Choose two.)

12. EExamine this command:

CREATE TEMPORARY TABLESPACE temp_tbs

TEMPFILE ‘temp01.dbf’ SIZE 10M AUTOEXTEND ON

ONLINE

SEGMENT MANAGEMENT AUTO;

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

13. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

14. What three are true about Oracle Flashback technology? (Choose three.)

15. Which two can you use to recover a dropped table? (Choose two.)

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

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

[[email protected] ~] impdp system/oracle

> SHEMAS=sh,oe

> REMAP_SCHEMA=sh:hr

> DUMPFILE=orcl.dmp

> EXCLUDE=index

> TABLE_EXISTS_ACTION=replace

> LOGFILE=impdp.log

Which two are true? (Choose two.)

17. Which is true about roles?

18. Which is true about security rules on a compute node?

19. In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.

Examine this command:

SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);

Which table segments are created?

20. Which is a machine image in Oracle Cloud?

21. The DATA tablespace uses Automatic Segment Space Management.

Examine this query and its output:

A block in EMP is 90% full.

At what percentage of free space will INSERT operations into the block again be possible?

22. Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.

Which three actions could help in handling a large number of concurrent users?

23. 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.)

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

25. Which two are true about complete recovery? (Choose two.)

26. Which two functions are performed by a listener?

27. Which three failures do not require intervention for recovery? (Choose three.)

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