oracle database 11g administration i 1z0 052 (91 to 100)

♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-052 Exam Dumps (PDF & VCE):
Available on:

Exambible offers free demo for 1z0 052 dumps exam. "Oracle Database 11g: Administration I", also known as 1z0 052 pdf exam, is a Oracle Certification. This set of posts, Passing the Oracle oracle database 11g administration i 1z0 052 exam, will help you answer those questions. The 1z0 052 pdf Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle oracle database 11g administration i 1z0 052 exams and revised by experts!

Q91. View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:

A. init.ora

B. spfile.ora

C. initorcl.ora

D. spfile+ASM.ora

Answer: B

Q92. Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously.

Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

A. You would configure more listeners for the database.

B. You would configure the database in shared server mode to use the connection pooling feature.

C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

Answer: B

Q93. Which of these is true about undo tablespace?

A. Undo tablespace is a temporary tablespace

B. Undo tablespace has only one datafile

C. Undotablespace has a datafile which is reused in cyclic manner

Answer: A

Q94. Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

A. It can be increased up to the value of the SGA_MAX_SIZE parameter.

B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

Answer: AB

Q95. View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body?


A. The USE_P procedure remains valid.

B. The USE_P procedure becomes invalid.

C. The SHOW_DETAIL procedure becomes invalid.

D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

Answer: A

Q96. Examine the values for the following initialization parameters:



Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

Answer: BC

Q97. 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

Q98. View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A. The ORCL instance is registered dynamically with the listener.

B. The ORCL instance is registered statically in the listener.ora file.

C. The number of current client connections handled by the service handler is two.

D. The total number of client connections handled so far by the service handler is two.

Answer: BD

Q99. View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:


Which statement describes the consequence of this command?

A. The command performs the recovery and closes the failure

B. The command only displays the advice and the RMAN script required for recovery

C. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

Answer: D

Q100. For which database operation would you need the database to be in the MOUNT state?

A. Renaming the control files

B. Re-creating the control files

C. Dropping a user in your database

D. Dropping a tablespace in your database

E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

Answer: E

Click to learn more regarding