1Z0-072 study tools >> Certify Oracle Database 12cR2 Administration

1Z0-072 practice exam ,vce exam collection and vce engine .

Pass 1Z0-072 Oracle Database 12cR2 Administration Exam Quickly using Certkillers.net new dumps .



1Z0-072 Full Version Download Available at https://www.certkillers.net/Exam/1Z0-072

Questions & Answers PDF Page 2 Version: 8.0 Question: 1 The ORCL database has DEFERREDSEGMENTCREATION set to TRUE. UNDOTBS2 is the active undo tablespace. Examine these commands: USER1 executes DML, which generates more than 2 MB of UNDO. What is the result and why? A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2. B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE. C. It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2. D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE. E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace. F. It returns an error because UNDOTBS2 is fixed size. Answer: F Question: 2 Which three failures require intervention for recovery? (Choose three.) A. a user error such as dropping the wrong table https://www.certkillers.net

Questions & Answers PDF Page 3 B. network interface card (NIC) failure C. user process failure D. statement failure E. media failure Answer: A,C,E Question: 3 Which three are true about Oracle Managed Files (OMF)? (Choose three.) A. If DBCREATEFILEDEST is specified but DBCREATEONLINELOGDESTn is not, the redo logs and control files are placed in DBCREATEFILEDEST by default. B. If DBRECOVERYFILEDEST is specified, at least two different locations must be specified for DBCREATEONLINELOGDESTn. C. If only DBCREATEFILEDEST is specified, only the data files and temp files are OMF. D. If DBRECOVERYFILEDEST is specified but DBCREATEONLINELOGDESTn is not, the redo logs and control files are placed in DBRECOVERYFILEDEST by default. E. If DBCREATEONLINELOGDEST1 is specified but DBCREATEFILEDEST is not, the data files and temp files are placed in DBCREATEONLINELOGDEST1 by default. F. If only DBCREATEONLINELOGDESTn is specified, only the redo logs and control files are OMF. Answer: A,B,F Question: 4 Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them? A. Oracle Connection Manager must be installed on the client. B. Net service names must be configured on both the client and database servers. C. The Listener Control utility must be installed on the client if you are using the default listener on the server. D. Only Oracle Net can be used. E. Oracle Net Listener is required. Answer: D Question: 5 In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMPENOPK resides in TBS1. USER1.EMPIDX 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. https://www.certkillers.net

Questions & Answers PDF Page 4 The SYSTEM user in TESTDB executes this command: [oracle@host01 ~]$ impdp system/oracle directory=expdir dumpfile=u1.dmp tablespace=tbs1 What is the result and why? A. It imports EMP, EMPENOPK, and the unique index associated with EMPENOPK and EMPIDX. B. It imports only EMP, EMPENOPK, and the unique index associated with EMPENOPK. C. It fails because TESTDB has TBS1. D. It imports only EMP. E. It fails because TESTDB does not have TBS2 to create EMPIDX. Answer: B Question: 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.) A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users. B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users. C. Execute DML statements in the HR schema. D. Log in to the database instance. E. Revoke the CREATE SESSION privilege from other users. F. Execute DDL statements in the HR schema. Answer: B,D,E Question: 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? A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command. B. TBS1 must be placed in READ ONLY state. C. Objects in TBS1 must not be in use when the command is executed. D. TBS1 must not contain any temp files. E. DBCREATEFILEDEST must refer to an Oracle Automatic Storage Management (ASM)disk group. Answer: A https://www.certkillers.net

Questions & Answers PDF Page 5 Thank You for trying 1Z0-072 PDF Demo To Buy Latest 1Z0-072 Full Version visit link below https://www.certkillers.net/Exam/1Z0-072 Start Your 1Z0-072 Preparation [Limited Time Offer] Use Coupon “NOJOB” for special 10% discount on your purchase. Test your 1Z0-072 preparation with actual exam questions. https://www.certkillers.net Search Google for 1Z0-072 Search Bing for 1Z0-072

1Z0-072 bootcamp ~ Best real q&a to Pass Quickly and Easily without Any Fear.