Online Access Free 1Z0-045 Exam Questions

The SQL Access Advisor may recommend additional structures to improve the performance of SQL statements. You can select the type of structure recommended by the SQL Access Advisor. Which two structures can you select? (Choose two.)

• A.Partitions
• B.Indexes
• C.Sequences
• D.Synonyms
• E.Materialized views
• F.Index-Organized Table
• G.Database links
• H.Hash or index clusters

The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

• A.Both init<SID>.ora parameters and SPFILE values are updated.
• B.Only init<SID>.ora parameters are updated.
• C.Only SPFILE values are updated.
• D.Both SPFILE and MEMORYmemory values are updated.
• E.Only MEMORY is updated.

The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)

• A.a Data Dictionary copy stored in an operating system flat file
• B.information in the control file
• C.the current online data dictionary
• D.separate supplemental log file
• E.redo information stored within the redo vectors of the DML operation
• F.a Data Dictionary copy stored in the redo log file

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.Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
• B.The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• C.The data in the segment will be compacted but the high water mark will not be adjusted.
• D.The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• E.The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

CORRECT TEXT
View the Exhibit and examine the sparsely populated EMP table segment.
You execute the following SQL command: ALTER TABLE emp SHRINK SPACE;
Identify how the data in the segment will be reorganized as a result of the above statement.

• A.Option
• B.Option
• C.Option
• D.Option