Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

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 . You must use Oracle predefined names to identify raw partitions that will hold OMF structures.  B . You must define directories for two online redo log groups and three copies of the control file.  C . If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.  D . You must use only OMF data files when adding new tablespaces or data files to your database in the future.

A .  All passwords automatically become case-sensitive. B .  All passwords remain non-case-sensitive till they are changed. C .  All passwords remain non-case-sensitive and cannot be changed. D .  All passwords remain non-case-sensitive until their password attribute in the profile is altered.

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 .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

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 . It creates the pointer file. B . It creates the base directory. C . It creates the Inventory pointer file. D . It creates the Oracle user for installation. E . It modifies the Unix kernel parameters to match Oracle’s requirement.

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 .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

A .  One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B .  One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C .  One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D .  One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

A . average row size B . last analyzed date C . size of table in bytes D . size of table in database blocks E . number of free blocks in the free list F . number of extents present in the table

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 .  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 .  MMAN B .  PMON C .  MMON D .  MMNL

A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

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 . JOIN子句 B . START WITH子句和CONNECT BY子句 C . GROUP BY子句 D . ORDER BY子句

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 . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.