This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Wed May 1 19:51:36 2024 / +0000 GMT ___________________________________________________ Title: [2016-Jun-NEW]Braindump2go Free 1Z0-052 Oracle Certification Exam Dumps 261Q&As[NQ21-NQ30] --------------------------------------------------- 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 21 - NEW QUESTION 30: QUESTION 21View the Exhibit and examine the privileges granted to the SL_REP user.The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command? A.    The command executes successfullyB.    The command produces an error because the EMP table is owned by SCOTTC.    The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTIOND.    The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table Answer: A QUESTION 22You executed this command to create a temporary table:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE,enddate DATE,class CHAR(20)) ON COMMIT PRESERVE ROWS;Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction? A.    The rows stay in the table only until session terminationB.    The rows stay in the table only until the next transaction starts on the tableC.    The rows are visible to all current sessions after the transaction in committedD.    The rows stay available for subsequent sessions after the transaction is committed Answer: A QUESTION 23You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data types would you use for the new column? A.    CLOBB.    BLOBC.    BFILED.    LONG RAW Answer: C QUESTION 24The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER)BEGININSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);END;The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.What would you suggest to the PL/SQL developers to achieve this? A.    Create the procedure with definer's right.B.    Create the procedure with invoker's right.C.    Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D.    Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users. Answer: B QUESTION 25Examine the following 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 columnB.    A NOT NULL constraint is created on the OID columnC.    The ORDERS table is the only object created in the USERS tablespaceD.    The ORDERS table and a unique index are created in the USERS tablespaceE.    The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID column in the SYSTEM tablespace Answer: BD QUESTION 26View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? A.    The DBA is working on the incident and prefers that the incident be kept in the ADRB.    The incident is now in the Done state and the ADR can select the incident to be purgedC.    The incident has been newly created and is in the process of collecting diagnostic informationD.    The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support Answer: D QUESTION 27What can you achieve by implementing reverse key index? A.    Reverse the bytes of each column indexed including the row IDB.    Store a bitmap for each key value instead of a list of row IDs in the leaf nodeC.    Prevent contention on the highest leaf block when using sequences to generate keysD.    Remove repeated key values from the index to fit more index entries in a given amount of disk space Answer: C QUESTION 28What is the effect of this command?SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; A.    One audit record is created for every successful DROP TABLE command executed in the session of SCOTTB.    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other usersC.    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his sessionD.    One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfullyE.    One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT Answer: C QUESTION 29You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP*ERROR at line 1:ORA-01123: cannot start online backup; media recovery not enabledWhat could be the reason for this error? A.    The MTTR Advisor is disabled.B.    The database is in NOARCHIVELOG mode.C.    The tablespace is already in backup mode.D.    The Flash Recovery Area is not configured. Answer: B QUESTION 30Which statements listed below describe the data dictionary views?1. These are stored in the SYSTEM tablespace2. These are the based on the virtual tables3. These are owned by the SYS user4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE5. The V$FIXED_TABLE view can be queried to list the names of these views A.    1 and 3B.    2,3 and 5C.    1,2, and 5D.    2,3,4 and 5 Answer: A 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 08:04:27 Post date GMT: 2016-06-07 08:04:27 Post modified date: 2016-06-07 08:04:27 Post modified date GMT: 2016-06-07 08:04:27 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com