Oracle 1Z0-072 Oracle Database 12cR2 Administration Online Training

Exam4Training Oracle 1Z0-072 Oracle Database 12cR2 Administration Online Training can not only let you pass the Oracle Database 12cR2 Administration exam easily, also can help you learn more knowledge about Oracle Database 1Z0-072 exam. Exam4Training covers all aspects of skills in the exam, by it, you can apparently improve your abilities and use these skills better at work. When you are preparing for Oracle 1Z0-072 exam and need to improve your skills, Exam4Training is absolute your best choice. Please believe Exam4Training can give you a better future

Page 1 of 3

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?


 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We do not share your personal details with anyone.