This page was exported from Braindump2go IT Exam Questions Free Download [ ] Export date:Fri Dec 14 13:16:46 2018 / +0000 GMT ___________________________________________________ Title: [2016-Jun-NEW]Where can I download the new 1Z0-052 Exam Questions?[NQ61-NQ70] --------------------------------------------------- 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! 100% Exam Pass Guaranteed! NEW QUESTION 61 - NEW QUESTION 70:   QUESTION 61See the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?A.    The user must enable the role explicitlyB.    The user can grant the role to other usersC.    The user cannot user the role until the DBA enables it explicitlyD.    The user can start using the role immediately without any changes Answer: A QUESTION 62To make audit information more productive, the DBA executes the following command before starting an audit operations:SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;Which statement is true regarding the audit record generated when auditing starts after restarting the database?A.    It contains only the plan for the SQL statement executed by the userB.    It contains the SQL text executed by the user and the bind variables used with itC.    It contains the plan and statistics associated with the SQL statement executed by the userD.    It contains the plan for the SQL statement executed by the user and the bind variables used with it Answer: B QUESTION 63database, DEVDB, to the production database, PRODDB. A database link is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hrflashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037:unable to obtain file statusWhat would you do to overcome the error?A.    Add the user, SYSTEM, to the schemas option.B.    Add the network_link = option.C.    Change the dumpfile option to    Replace the schemas option with the network_link =    Replace the dumpfile option with the network_link = Answer: E QUESTION 64Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.    The ADDM requires at least four AWR snapshots for analysisB.    The ADDM runs after each AWR snapshot is collected automatically by MMONC.    The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)D.    The ADDM analysis provides only diagnostics information but does not provide recommendationsE.    The ADDM calls other advisors if required, but does not provide recommendations about the advisors Answer: BC QUESTION 65Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?A.    Run the script.B.    Create the oraInst.loc file.C.    Create the tnsnames.ora file.D.    Run the script. Answer: B QUESTION 66You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:1) Shut down the instance.2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.3) Execute the ALTER DATABASE FLASHBACK OFF command.4) Start up the instance and mount the database.5) Execute the ALTER DATABASE FLASHBACK ON command.6) Open the database.Select the correct order in which these tasks need to be performed.A.    2, 1, 4, 3, 5, 6B.    1, 4, 3, 2, 6, 5C.    1, 4, 2, 6, 3, 5D.    3, 2, 1, 4, 5, 6 Answer: A QUESTION 67You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation?A.    The online redo log files and archived redo log files are required to accomplish the recoveryB.    The uncommitted transaction will be committed at the next startup of the database instanceC.    The uncommitted transaction is rolled back automatically at the next opening of the databaseD.    The DBA has to perform the recovery on the database to recover the uncommitted transaction Answer: C QUESTION 68View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this?A.    The database instance is running with manual PGA management.B.    The database instance is running with manual shared memory management.C.    The database instance has the MEMORY_TARGET value set to a nonzero value.D.    All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed. Answer: C QUESTION 69Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;What would be the outcome of this command?A.    The command succeeds only if Automatic Memory Management is not enabled.B.    The command succeeds, but you need to restart the database for changes to take effect.C.    The command returns an error because the size of the redo log buffer cannot be changed dynamically.D.    The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA). Answer: C QUESTION 70The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:1. Shut down the instance, if not already done.2. Copy one of the remaining control files to a new location.3. Change the value of the CONTROL_FILES initialization parameter to correspond to the newlocation of the control files.4. Start up the database instance to the NOMOUNT stage.5. Recover the database to the point of failure of the control file.6. Open the database.Identify the correct sequence of steps?A.    1, 2, 4, 3, 5, 6B.    2, 4, 3, 5, 6; 1 not requiredC.    4, 5, 6, 2, 3; 1 not requiredD.    5, 2, 3, 4; 1 and 6 not required Answer: A 2016 Valid Oracle 1Z0-052 Exam Study Materials:   1.| Latest Oracle 1Z0-052 Exam PDF and VCE Dumps 261q from Braindump2go: [100% Exam Pass Guaranteed!]   2.| New Oracle 1Z0-052 Exam Questions and Answers - Google Drive:     MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-052 Exam 100%!—————————— Pass All IT Exams at the first Try! --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2016-06-08 03:35:42 Post date GMT: 2016-06-08 03:35:42 Post modified date: 2016-06-08 03:35:42 Post modified date GMT: 2016-06-08 03:35:42 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from