1z0-182

1z0-182 practice questions, page 3 of 6, with answer review and explanations.

Question 11

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

  1. All trace files contain error information that require contacting Oracle Support.
  2. They can be written by server processes to the Fast Recovery Area (FRA).
  3. They can be written by background processes to a file system.
  4. They can be written by server processes to a file system.
  5. Trace file names are based on the database name concatenated with a sequential number.

Question 12

Which three tools are components of the Oracle Database Optimizer? (Choose three.)

  1. Statistic Advisor
  2. Estimator
  3. Index Detector
  4. Query Transformer
  5. Plan Generator
  6. The DMBS_STATS P/L SQL package

Question 13

Which two statements are true about the configuration and use of UNDO_RETENTION with no GUARANTEED RETENTION? (Choose two.)

  1. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
  2. UNDO_RETENTION specifies how long all types of UNDO are retained.
  3. Active UNDO is always retained.
  4. Unexpired UNDO is always retained.
  5. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

Question 14

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database: The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully? (Choose two.)

  1. Add the AUTOEXTEND ON clause with NEXT set to 100M.
  2. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.
  3. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.
  4. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
  5. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

Question 15

Which two tasks can you perform using DBCA for databases? (Choose two.)

  1. Configure a nonstandard block size for a new database.
  2. Register a new database with an available Enterprise Manager Management server.
  3. Enable flashback database for an existing database.
  4. Configure incremental backups for a new database.
  5. Change the standard block size of an existing database.