Online Access Free 1Z0-182 Practice Test

What memory structure caches the data dictionary providing access to all database user processes?

• A.The Shared Pool
• B.The Java Pool
• C.The Large Pool
• D.The Streams Pool

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

• A.Tables with one or more extents in this data file may be queried during the execution of this command.
• B.Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
• C.It overwrites any existing file with the name sales02.dbf in /u02 by default.
• D.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• E.The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

Which advisor is used to detect missing or stale object statistics?

• A.SQL Statistics Advisor
• B.SQL Performance Analyzer
• C.SQL Access Advisor
• D.SQL Tuning Advisor

Which two statements are true about trace files produced by the Oracle Database server?

• A.Trace file names are based on the database name concatenated with a sequential number.
• B.They can be written by server processes to the Fast Recovery Area (FRA).
• C.They can be written by server processes to a file system.
• D.All trace files contain error information that requires contacting Oracle Support.
• E.They can be written by background processes to a file system.

Which three statements are true about an SPFILE?

• A.It must exist for a database instance to start.
• B.It contains only static initialization parameters.
• C.It contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.
• D.It can be used to create a PFILE.
• E.It can be created by SYS from an idle instance.