Online Access Free 1Z0-055 Practice Test

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column.
You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.
What action is required for the dependent objects when you perform online redefinition on the table?

• A.The materialized view should have a fast refresh performed after the online table redefinition is completed.
• B.The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
• C.The materialized view should have a complete refresh performed after the online table redefinition is completed.
• D.The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.

Identify the three predefined server-generated alerts. (Choose three.)

• A.Resumable Session Suspended
• B.Recovery Area Low On Free Space
• C.SYSTEM Tablespace Size Increment
• D.Drop User
• E.Tablespace Space Usage

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A.The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• B.The plan baselines can be evolved over time to produce better performance.
• C.The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
• D.The newly generated plans are directly placed into the SQL plan baseline without being verified.

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 not add the tablespace TEMP1 to any group.
• B.It will create the tablespace TEMP1 in group G3.
• C.It will create the tablespace TEMP1 in group G1.
• D.It will create the tablespace TEMP1 in the default group.

Identify the three predefined server-generated alerts. (Choose three.)

• A.Resumable Session Suspended
• B.Recovery Area Low On Free Space
• C.SYSTEM Tablespace Size Increment
• D.Drop User
• E.Tablespace Space Usage