1Z0-055 | The Secret of Oracle 1Z0-055 practice test

Q101. What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.) 

A. selection of SQL plan baselines 

B. partitioning of tables and indexes 

C. creation of index-organized tables 

D. creation of bitmap, function-based, and B-tree indexes 

E. optimization of materialized views for maximum query usage and fast refresh 

Answer: B,D,E 

Q102. Which two statements regarding the Flashback Table feature are correct? (Choose two.) 

A. Flashback Table can be performed on system tables. 

B. Flashback Table operation does not shrink the segments. 

C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements. 

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks. 

Answer: B,D 

Q103. View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. 

You executed the following commands: 

SQL> VAR tname VARCHAR2(60); 

SQL> BEGIN 

:tname := 'my_instance_analysis_mode_task' 

DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT'); 

END; 

Which statement describes the consequence? 

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT 

schema. 

B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only. 

C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state. 

D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema. 

Answer: C 

Q104. What are the advantages of variable extent size support for large ASM files? (Choose two.) 

A. It improves performance in the extended cluster configuration by reading from a local copy of an extent. 

B. It improves resync operations when the disk comes online after being taken offline for maintenance purposes. 

C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents. 

D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool. 

Answer: C,D 

Q105. You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task? 

A. Data Pump Export and Import 

B. conventional export and import 

C. the CONVERT command of RMAN 

D. the BACKUP AS COPY.. command of RMAN 

Answer: D 

Q106. Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure? 

A. only encryption and compression settings for all SecureFile LOBs 

B. only encryption and deduplication settings for only SecureFile CLOBs 

C. deduplication, encryption, and compression settings for all SecureFile LOBs 

D. deduplication, encryption, and compression settings only for SecureFile CLOBs 

Answer: C 

Q107. Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions? 

A. point-in-time recovery 

B. execute the ROLLBACK command with transaction number 

C. flashback the database to before the transaction was committed 

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery 

Answer: D 

Q108. View the Exhibit for some of the current parameter settings. 

A user logs in to the HR schema and issues the following commands: 

SQL> CREATE TABLE emp 

(empno NUMBER(3), 

ename VARCHAR2(20), 

sal NUMBER(8,2)); 

SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES'); 

At this moment, a second user also logs in to the HR schema and issues the following command: 

SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2); 

What happens in the above scenario? 

A. A deadlock is created. 

B. The second user's command executes successfully. 

C. The second user's session immediately produces the resource busy error. 

D. The second user's session waits for a time period before producing the resource busy error. 

Answer: D 

Q109. You have three temporary tablespace groups named G1, G2, and G3 in your database. 

You are creating a new temporary tablespace as follows: 

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '' 

Which statement regarding the above command is correct? 

A. It will create the tablespace TEMP1 in group G1. 

B. It will create the tablespace TEMP1 in group G3. 

C. It will not add the tablespace TEMP1 to any group. 

D. It will create the tablespace TEMP1 in the default group. 

Answer: C 

Q110. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 

10.1 catalog schema owned by the user RCAT10. 

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands: 

RMAN> CONNECT CATALOG rco11/password@catdb 

RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER; 

Which two statements are true regarding the tasks accomplished with these commands? (Choose two.) 

A. They import all metadata from the RCAT10 catalog. 

B. They unregister the database from the RCAT10 catalog. 

C. They do not register the databases registered in the RCAT10 catalog. 

D. They register all databases registered in the RCAT10 catalog. 

Answer: A,D