This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Thu May 2 2:51:47 2024 / +0000 GMT ___________________________________________________ Title: [2016-Jun-NEW]1Z0-052 Questions and Answers Free 261q Files Offered by Braindump2go[NQ11-NQ20] --------------------------------------------------- 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 11 - NEW QUESTION 20:   QUESTION 11Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.) A.    Shared SQL Area will be allocated in the shared pool B.    Shared SQL Area will be allocated when a session startsC.    Shared SQL Area will be allocated in the large pool alwaysD.    The whole of Private SQL Area will be allocated in the Program Global Area (PGA) alwaysE.    Shared SQL Area and Private SQL Area will be allocated in the PGA or large poolF.    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter Answer: AF QUESTION 12Which three statements are correct about temporary tables? (Choose three.) A.    Indexes and views can be created on temporary tablesB.    Both the data and structure of temporary tables can be exportedC.    Temporary tables are always created in a user's temporary tablespaceD.    The data inserted into a temporary table in a session is available to other sessionsE.    Data Manipulation Language (DML) locks are never acquired on the data of temporary tables Answer: ACE QUESTION 13Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.) A.    Failure when no standby database is configuredB.    Failure because a data file is renamed accidentallyC.    Failure that requires no archive logs to be applied for recoveryD.    Failure due to loss of connectivity-for example, an unplugged disk cable Answer: BD QUESTION 14Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two) A.    An extent cannot spread across data files.B.    A segment cannot spread across data files.C.    A data file can belong to only one tablespace.D.    A data file can have only one segment created in it.E.    A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks. Answer: AC QUESTION 15Which two statements are true regarding a tablespace? (Choose two.) A.    It can span multiple databasesB.    It can consist of multiple data filesC.    It can contain blocks of different filesD.    It can contains segments of different sizesE.    It can contains a part of nonpartitioned segment Answer: BD QUESTION 16Which two statements are true regarding Oracle Data Pump? (Choose two.) A.    EXPDP and IMPDP are the client components of Oracle Data PumpB.    DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clientsC.    Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilegeD.    Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.xE.    EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands Answer: AB QUESTION 17Identify the two situations in which the alert log file is updated with details. (Choose two.) A.    Running a query on a table returns "ORA-600: Internal Error"B.    Inserting a value in a table returns "ORA-01722: Invalid Number"C.    Creating a table returns "ORA-00955: name is already used by an existing object'D.    Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."E.    Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578:ORACLE data block corrupted (file # 14, block @ 50)."F.    Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578:ORACLE data block corrupted (file #14, block #50)." Answer: AE QUESTION 18Which two statements are true about alerts? (Choose two.) A.    Clearing an alert sends the alert to the alert historyB.    Response actions cannot be specified with server-generated alertsC.    The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS viewD.    Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified Answer: AD QUESTION 19Examine the following steps performed on a database instance:1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION2. The SKD user creates a table3. The SKD user grants the CREATE TABLE system privilege to the HR user4. The HR user creates a table5. The DBA revokes the CREATE TABLE system privilege from SKDWhich statement is true after step 5 is performed? A.    The table created by SKD is not accessible and SKD cannot create new tablesB.    The tables created by SKD and HR remain, but both cannot create new tablesC.    The table created by HR remains and HR still has the CREATE TABLE system privilegeD.    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users Answer: C QUESTION 20You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;Which two statements are true about the effect of the command? (Choose two.) A.    No flashback is possible to bring back the ITEM table.B.    The ORDERS table is dropped along with the ITEM table.C.    The dependent referential integrity constraints in the ORDERS table are disabled.D.    The dependent referential integrity constraints in the ORDERS table are removed.E.    The table definition of the ITEM table and associated indexes are placed in the recycle bin. Answer: AD 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 07:24:27 Post date GMT: 2016-06-07 07:24:27 Post modified date: 2016-06-07 07:24:27 Post modified date GMT: 2016-06-07 07:24:27 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com