Download Oracle.1z0-072.PracticeTest.2019-06-19.34q.tqb

Download Exam

File Info

Exam Oracle Database 12cR2 Administration
Number 1z0-072
File Name Oracle.1z0-072.PracticeTest.2019-06-19.34q.tqb
Size 145 KB
Posted Jun 19, 2019
Download Oracle.1z0-072.PracticeTest.2019-06-19.34q.tqb

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

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


  1. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
  2. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
  3. Execute DML statements in the HR schema.
  4. Log in to the database instance.
  5. Revoke the CREATE SESSION privilege from other users.
  6. Execute DDL statements in the HR schema.
Correct answer: BDE
Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm



Question 2

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? 


  1. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
  2. TBS1 must be placed in READ ONLY state.
  3. Objects in TBS1 must not be in use when the command is executed. 
  4. TBS1 must not contain any temp files.
  5. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm



Question 3

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


  1. SQL files
  2. dump files
  3. reject files
  4. log files
  5. input data files
  6. bad files
  7. control files
Correct answer: ABD
Explanation:
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files