This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Nov 22 7:35:05 2024 / +0000 GMT ___________________________________________________ Title: [2016-Jun-NEW]New Exam 1Z0-052 Preparation Materials 261q from Braindump2go for Free Downloading[NQ1-NQ10] --------------------------------------------------- 2016 June Oracle Official News: 1Z0-052 Oracle Database 11g: Administration I Exam Questions New Updated Today! Free Download 1Z0-052 PDF and VCE Dumps 261Q&As in Braindump2go.com! 100% Exam Pass Guaranteed! NEW QUESTION 1 - NEW QUESTION 10:   QUESTION 1The instance abnormally terminates because of a power outage.Which statement is true about redo log files during instance recovery? A.    Inactive and current redo log files are required to accomplish recoveryB.    Online and archived redo files are required to accomplish instance recoveryC.    All redo log entries after the last checkpoint are applied from redo log files to data filesD.    All redo log entries recorded in the current log file until the checkpoint position are applied to data files Answer: C QUESTION 2Examine the command:SQL>ALTER USR skd ACCOUNT LOCK;Which two statements are true after the command is executed? (Choose two.) A.    The SKD user cannot log in to the database instanceB.    The objects owned by the SKD user are not accessible to any userC.    The other users can access the objects owned by the SKD user, on which they have accessD.    The password for the SKD user expires and the user is forced to change the password at the next log in Answer: AC QUESTION 3For which database operation would you need the database to be in the MOUNT state? A.    Renaming the control filesB.    Re-creating the control filesC.    Dropping a user in your databaseD.    Dropping a tablespace in your databaseE.    Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes Answer: E QUESTION 4The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.Which statement is true in this scenario? A.    The statistics collection continues until all objects are processed.B.    The job is terminated and the statistics collected are restored to a time before the job started.C.    This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.D.    The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened. Answer: D QUESTION 5You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task? A.    FULLB.    SCHEMASC.    TRANSFORMD.    REMAP_SCHEMAE.    REMAP_TABLESPACE Answer: D QUESTION 6You executed the following command to create a password file in the database server:$ orapwd file = orapworcl entries = 5 ignorecase=NWhich statement describes the purpose of the above password file? A.    It records usernames and passwords of users when granted the DBA roleB.    It contains usernames and passwords of users for whom auditing is enabledC.    It is used by Oracle to authenticate users for remote database administratorD.    It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups Answer: C QUESTION 7Which two statements are true regarding the MRKT tablespace? (Choose two.)SQL> CREATE BIGFILE TABLESPACE MRKT2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;Tablespace created.SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;Database altered. A.    No more data files can be added to the tablespace.B.    Segment space is managed by free lists in the tablespace.C.    A user created without being assigned a default tablespace uses this tablespace.D.    The tablespace can be dropped with the current setting with segments present in it. Answer: AC QUESTION 8View the Exhibit and examine the privileges granted to the MGR_ROLE role.The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;Which statement is true about the user SKD after he/she is granted this role?  A.    The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in itB.    The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantorC.    The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTIOND.    The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them Answer: A QUESTION 9After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true? (Choose two.) A.    The online redo log files and online data files are openedB.    All the online data files headers are checked for consistencyC.    Instance recovery is performed before opening the databaseD.    The path and existence of all the log file members are checked Answer: AB QUESTION 10Examine the command that is used to create a table:SQL> CREATE TABLE orders (oid NUMBER(6) PRIMARY KEY,odate DATE,ccode NUMBER (6),oamt NUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command? (Choose two.) A.    A CHECK constraint is created on the OID column.B.    A NOT NULL constraint is created on the OID column.C.    The ORDERS table is the only object created in the USERS tablespace.D.    The ORDERS table and a unique index are created in the USERS tablespace.E.    The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace. Answer: BD 2016 Valid Oracle 1Z0-052 Exam Study Materials:   1.| Latest Oracle 1Z0-052 Exam PDF and VCE Dumps 261q from Braindump2go: http://www.braindump2go.com/1z0-052.html [100% Exam Pass Guaranteed!]   2.| New Oracle 1Z0-052 Exam Questions and Answers - Google Drive: https://drive.google.com/folderview?id=0B75b5xYLjSSNT1YxVElVOWxKbmM&usp=sharing     MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-052 Exam 100%!————— Braindump2go.com————— Pass All IT Exams at the first Try! --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2016-06-07 06:21:28 Post date GMT: 2016-06-07 06:21:28 Post modified date: 2016-06-07 06:21:28 Post modified date GMT: 2016-06-07 06:21:28 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com