In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

A .  a list of files that require a backup within three days B .  a list of files that have not been backed up for three days C .  a list of files that RMAN recommends be backed up only once in every three days， based on low volatility D .  a list of files for which a backup has already been performed and may need a backup after three day

A .  A user table was lost at the specified time. B .  A redo log file was lost at the specified time. C .  The backup control file is on a faster disk than the current one. D .  The current control file has a different path compared with the intended time of recovery. E .  The current control file does not match the physical structure of the database at the intended time of recovery.

A . A user table was lost at the specified time. B . A redo log file was lost at the specified time. C . The backup control file is on a faster disk than the current one. D . The current control file has a different path compared with the intended time of recovery. E . The current control file does not match the physical structure of the database at the intended time of recovery.

A . loss of a tempfile B . loss of a system data file C . loss of one of the control files D . loss of one of the tablespaces E . loss of a member from each redo log group F . loss of the only member of an unarchived redo log grou

A .  The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. B .  RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group. C .  The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk. D .  ASM compatibility controls which features for the ASM will be enabled.

A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

A .  loss of one of the tablespaces B .  loss of a system data file C .  loss of one of the control files D .  loss of a tempfile E .  loss of the only member of an unarchived redo log group F .  loss of a member from each redo log grou

A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

A . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

A .  by using the Flashback Database feature B .  by using RMAN incomplete recovery C .  by performing a user-managed incomplete recovery D .  by dropping and re-creating the index tablespace

A .  it can be used to concatenate two strings. B .  it can be used to find out the total length of the string. C .  it can be used for string manipulation and searching operations. D .  it can be used to format the output for a column or expression having string data. E .  it can be used to find and replace operations for a column or expression having string data.

A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

A . recovery catalog B . Oracle Enterprise Manager Repository C . Automatic Workload Repository （AWR） D . Oracle 10g Enterprise Manager Grid Control E . Automatic Database Diagnostic Monitor （ADDM）

A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

A . Oracle Flashback uses undo information to construct consistent data.  B . You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.  C . You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.  D . Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.&e

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . a list of files that require a backup within three days B . a list of files that have not been backed up for three days C . a list of files that RMAN recommends be backed up only once in every three days， based on low volatility D . a list of files for which a backup has already been performed and may need a backup after three day

A . Writes buffers to disk  B . Writes current redo log number to datafile headers  C . Writes redo log information to disk  D . Reads information into memory for user

A . Parallel compilation of only the stored PL/SQL code B . Sequential recompilation of only the stored PL/SQL code C . Parallel recompilation of any stored PL/SQL code D . Sequential recompilation of any stored PL/SQL code E . Parallel recompilation of Java code F . Sequential recompilation of Java code

A . A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows B . All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application. C . A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows. D . A TOP-N query is created to limit the rows to 20 percent of the total row