The only oracle database 11g administration i 1z0 052 resources for you

It is more faster and easier to pass the Oracle oracle database 11g administration i 1z0 052 exam by using Best Quality Oracle Oracle Database 11g: Administration I questuins and answers. Immediate access to the Renew 1z0 052 pdf Exam and find the same core area 1z0 052 dumps questions with professionally verified answers, then PASS your exam with a high score now.

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:
http://www.certleader.com/1Z0-052-dumps.html

Q31. Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.

What could be the reason for this?

A. To limit the User Global Area (UGA) memory allocated to a session from the SGA

B. To limit the amount of memory to be used for the dispatcher queue of a session in SGA

C. To limit the amount of memory to be used for the request pool in System Global Area (SGA)

D. To control the amount of memory allocated in SGA for the local variables for each shared server process

Answer: A

Q32. Which two statements are true regarding a PL/SQL package body? (Choose two.)

A. It cannot be created without a package specification.

B. It cannot invoke subprograms defined in other packages.

C. It can contain only the subprograms defined in the package specification.

D. It can be changed and recompiled without making the package specification invalid.

Answer: AD

Q33. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

A. Host naming method

B. Local naming method

C. External naming method

D. Directory naming method

Answer: B

Q34. View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

ORA-01555: snapshot too old What could be the reason for this error?

Exhibit:

A. The query is unable to get a read-consistent image.

B. There is not enough space in Flash Recovery Area.

C. There is not enough free space in the flashback archive.

D. The query is unable to place data blocks in undo tablespace.

Answer: A

Q35. Which statement is true about loading data using the conventional path of SQL*Loader?

A. Redo is not generated while performing conventional path loads

B. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked

C. No exclusive locks are acquired when the conventional path loads are performed

D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

E. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

Answer: C

Q36. In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

A. if a table is not in a cluster

B. if a table has an active trigger

C. if a table has an encrypted column

D. if a table has a column of data type LONG defined on it

E. if a table has a referential integrity constraint defined on it

Answer: BCE

Q37. These are points that describe the contents of different memory components:

1: Descriptive information or metadata about schema objects that are queried by using SQL statements

2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements

3: Results of SQL queries and PL/SQL functions

4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

5: The information necessary to reconstruct changes made to the database by a transaction

Which of these will be stored in the Shared Pool if the necessary configurations are done?

A. 1 and 2

B. 2 and 5

C. 1,3, and 4

D. 3,4 and 5

E. 1,2,3 and 4

Answer: C

Q38. 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?

Exhibit:

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

Q39. View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

ORA-01555: snapshot too old

What could be the reason for this error?

Exhibit:

A. The query is unable to get a read-consistent image.

B. There is not enough space in Flash Recovery Area.

C. There is not enough free space in the flashback archive.

D. The query is unable to place data blocks in undo tablespace.

Answer: A

Q40. View the Exhibit and examine the output of the query.

What do you infer from this?

A. The SGA_TARGET is a static parameter.

B. The instance is started, but the database is not yet open.

C. The server parameter file (SPFILE) was used to start the instance.

D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.

Answer: C

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.