[2018 Update] 1Z0-052 Oracle Database 11g: Administrator I questions

The passing rate of the Oracle 1Z0-052 Test is incredibly low. The purpose of Certqueen 1Z0-052 Oracle Database 11g: Administrator I questions are to promote Oracle 1Z0-052 Certification. It’s surely not an easy task to do but doing the Oracle 1Z0-052 Training by using our 1Z0-052 Oracle Database 11g: Administrator I questions will ensure and encourage that you can earn the Oracle 1Z0-052 Certification. We have years of experience and is backed by some of the top class industrious and Certified IT Professionals who keep changing the 1Z0-052 Oracle Database 11g: Administrator I questions with the change in Exam Objectives.
Share some 11g 1Z0-052 exam questions and answers below.
Examine 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 instance
B. The objects owned by the SKD user are not accessible to any user
C. The other users can access the objects owned by the SKD user, on which they have access
D. The password for the SKD user expires and the user is forced to change the password at the next login
Answer: AC

Which two statements about the background process of the database writer are true? (Choose two.)
A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
C.It writes dirty buffers, if any, to data files whenever a transaction commits.
D.It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.
Answer: AB

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.
Answer: A

Note the functionalities of various background processes:
1: Perform recovery at instance startup.
2: Free the resources used by a user process when it fails.
3: Cleanup the database buffer cache when a process fails.
4: Dynamically register database services with listeners.
5: Monitor sessions for idle session timeout.
6: Cleanup unused temporary segments.
7: Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
A.Checkpoint (CKPT): 1, 2, 5
B.System Monitor (SMON): 1, 6
C.Process Monitor (PMON): 4, 6, 7
D.Database Writer (DBWR): 1, 3, 4
Answer: B

Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables
B. Both the data and structure of temporary tables can be exported
C. Temporary tables are always created in a user’s temporary tablespace
D. The data inserted into a temporary table in a session is available to other sessions
E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
Answer: ACE

You 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 termination
B. The rows stay in the table only until the next transaction starts on the table
C. The rows are visible to all current sessions after the transaction in committed
D. The rows stay available for subsequent sessions after the transaction is committed
Answer: A

The 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

The 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 recovery
B. Online and archived redo files are required to accomplish instance recovery
C. All redo log entries after the last checkpoint are applied from redo log files to data files
D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
Answer: C

Identify 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

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
Answer: C

Moreover the 1Z0-052 Oracle Database 11g: Administrator I questions are worked out by I.T. experts who enable you to practice test questions in order to achieve your goal. All most all IT professionals are familiar with the Oracle 1Z0-052 exam and dream to have that top most demanding certification. This is the top level certification from Oracle that is accepted universally. You can get your desired career which you dreamed with passing Oracle 1Z0-052 test and getting the certificate.

Leave a Reply

Your email address will not be published. Required fields are marked *