1Z0-052 Oracle Database 11g: Administrator I dumps from Certqueen are prepared by our top certified IT professionals and experienced experts, who have years of experience on training IT certification learners. Certqueen provides the most recent Oracle 1Z0-052 preparation questions. Development online practice tests combined with Certqueen 1Z0-052 Oracle Database 11g: Administrator I dumps as they are very easy sources to study for this exam.
Share some 11g 1Z0-052 exam questions and answers below.
Note the following functionalities of various background processes:
1: Record the checkpoint information in data file headers.
2: Perform recovery at instance startup.
3: Cleanup unused temporary segments.
4: Free the resources used by a user process when it fails.
5: Dynamically register database services with listeners.
6: Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A.Archiver Process (ARCn): 1, 2, 5
B.System Monitor Process (SMON): 1, 4, 5
C.Process Monitor Process (PMON): 4, 5, 6
D.Database Writer Process (DBWn): 1, 3, 4
Which 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 starts.
C.Shared SQL Area will be allocated in the large pool always.
D.Private SQL Area will be allocated in the Program Global Area (PGA) always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
Which is the correct description of a pinned buffer in the database buffer cache?
A.The buffer is currently being accessed.
B.The buffer is empty and has not been used.
C.The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
D.The buffer is a candidate for immediate aging out and its contents are synchronized with the block
contents on the disk.
The 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) BEGIN INSERT 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.
Identify the memory component from which memory may be allocated for:
1: Session memory for the shared server
2: Buffers for I/O slaves
3: Oracle Database Recovery Manager (RMAN) backup and restore operations
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area (PGA)
Which two statements are true about alerts? (Choose two.)
A. Clearing an alert sends the alert to the alert history
B. Response actions cannot be specified with server-generated alerts
C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified
What 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 SCOTT
B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
Note the following points describing various utilities in Oracle Database 11g:
1: It enables the high-speed transfer of data from one database to another.
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3: It enables the loading of data from an external file into an Oracle database.
4: It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup?
E.1, 2, and 4
F.1, 2, 3, and 4
Which two statements are true regarding Oracle Data Pump? (Choose two.)
A. EXPDP and IMPDP are the client components of Oracle Data Pump
B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Release
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands
You 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.
Certqueen 1Z0-052 Oracle Database 11g: Administrator I dumps for Oracle certification 1Z0-052 exam is developed by the study of Certqueen experts team to use their knowledge and experience. Certqueen expert team has developed the latest 1Z0-052 Oracle Database 11g: Administrator I dumps for Oracle certification 1Z0-052 exam. After training they can not only quickly master a lot of knowledge, but also consolidate their original knowledge. So they can easily pass Oracle certification 1Z0-052 exam and it is much more cost-effective for them than those who spend a lot of time and energy to prepare for the examination.