Our pass rate is high to 98.9% and the similarity percentage between our 1z0 052 pdf study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle oracle database 11g administration i 1z0 052 exam in just one try? I am currently studying for the Oracle oracle database 11g administration i 1z0 052 exam. Latest Oracle 1z0 052 pdf Test exam practice questions and answers, Try Oracle 1z0 052 pdf Brain Dumps First.


♥♥ 2021 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.surepassexam.com/1Z0-052-exam-dumps.html

Q111. Note the following structures in your database server:

1. Extents

2. OS Blocks

3. Tablespace

4. Segments

5. Oracle Data Block

Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 5, 2, 1, 3, 4

D. 2, 1, 5, 4, 3

Answer: A


Q112. Your database is in shutdown state. What will happend if you issue next command:

SQL> startup

A. instance will started

B. instance started and DB is mounted

C. instance started, DB opened and finally mounted

D. instance started, DB mounted and finally opened

Answer: D


Q113. Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)

A. Undo tablespace

B. USERS tablespace 

C. SYSAUX tablespace 

D. SYSTEM tablespace 

E. Temporary tablespace

Answer: CD


Q114. Examine the commands executed in the following sequence:

Which statement is true about the above commands?

A. The commands execute successfully.

B. Command 6 produces an error because of circular role grant.

C. Command 5 produces an error because a role cannot be granted to another role.

D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.

E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

Answer: B


Q115. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

A. Validate the index structure using the ANALYZE .... INDEX command

B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command

C. Change the block space utilization parameters using the ALTER INDEX command

D. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command

Answer: B


Q116. View the Exhibit and examine the initialization parameter settings.

Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

A. LOG_BUFFER

B. SORT_AREA_SIZE

C. JAVA_POOL_SIZE

D. STREAMS_POOL_SIZE

E. DB_16K_CACHE_SIZE

F. DB_KEEP_CACHE_SIZE

Answer: AEF


Q117. Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

A. You can load data into multiple tables during the same load session

B. You can load data from multiple files to a table during the same load session

C. You cannot perform selective data loading based on the values available in the records

D. You can use an export file generated by the EXPDP utility as an input data file to load the data

E. You can load data only if the input file is available on the disk and tape but not a named pipes

Answer: AB


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


Q119. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; 

REASON                        METRIC_VALUE 

------------------------------                ---------------------- 

Tablespace [TEST] is [28 perce nt] full     28.125 

What could be the reason for the elimination of the other rows in the output?

Exhibit:

A. An Automatic Workload Repository snapshot has been taken recently.

B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

Answer: C


Q120. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:

Warning (%): 90

Critical (%): 95

Which background process is responsible for issuing alerts when the threshold is crossed?

A. System monitor (SMON)

B. Process monitor (PMON)

C. Memory manager process (MMAN)

D. Manageability Monitor process (MMON)

Answer: D