1Z0-055 | What Pinpoint 1Z0-055 pdf Is?


Q121. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.) 

A. Its entries are specific to a single database. 

B. It contains file systems that have been mounted by Direct NFS. 

C. It is globally available to all Oracle 11g databases on the machine. 

D. It contains file systems that have been mounted by the kernel NFS system. 

Answer: C,D 

Q122. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? (Choose two.) 

A. The ASM-preferred mirror read feature is enabled. 

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units. 

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable. 

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group. Answer: A,B 

Q123. Evaluate the following command: 

SQL> CREATE TABLE design_data (id NUMBER, 

doc CLOB) 

LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); 

Which statement is true regarding the above command? 

A. The LOB values are automatically compressed. 

B. The LOB values are cached by default in the buffer cache. 

C. The LOB values are automatically stored in encrypted mode. 

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks. 

Answer:

Q124. Which setting enables the baselines by default in Oracle Database 11g? 

A. setting the STATISTICS_LEVEL parameter to TYPICAL 

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM) 

C. enabling Automated Maintenance Task using Oracle Enterprise Manager 

D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE 

Answer:

Q125. Examine the following PL/SQL block: 

SET SERVEROUTPUT ON 

SET LONG 10000 

DECLARE report clob; 

BEGIN 

report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); 

DBMS_OUTPUT.PUT_LINE(report); 

END; 

Which statement describes the effect of the execution of the above PL/SQL block? 

A. The plan baselines are verified with the SQL profiles. 

B. All fixed plan baselines are converted into nonfixed plan baselines. 

C. All the nonaccepted SQL profiles are accepted into the plan baseline. 

D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines. 

Answer:

Q126. View the Exhibit and examine the Data Pump architecture. 

Identify the numbered components.

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API 

B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader 

C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump 

D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump 

Answer:

Q127. You executed the following command to drop a user: 

DROP USER scott CASCADE; 

Which two statements regarding the above command are correct? (Choose two.) 

A. All the objects of scott are moved to the Recycle Bin. 

B. Any objects in the Recycle Bin belonging to scott are purged. 

C. All the objects owned by scott are permanently dropped from the database. 

D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command. 

E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command. 

Answer: B,C 

Q128. Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.) 

A. Health Monitor checks are always initiated manually when there is some critical error. 

B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption. 

C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. 

D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt, or inconsistent. 

Answer: B,D 

Q129. Evaluate the following command: 

SQL> CREATE TABLE design_data (id NUMBER, doc CLOB)

 LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); 

Which statement is true regarding the above command? 

A. The LOB values are automatically compressed. 

B. The LOB values are cached by default in the buffer cache. 

C. The LOB values are automatically stored in encrypted mode. 

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks. 

Answer:

Q130. You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: 

ALTER TABLE employees SHRINK SPACE CASCADE; 

Which statement is correct in this scenario? 

A. The EMPLOYEES table will be changed to read-only mode during the shrink operation. 

B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. 

C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. 

D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation. 

Answer: