In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） 

相似题目

• You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

  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

  查看最佳答案

• Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

  A . Avoid coding unnecessary long-running transactions. B . Allow the database to handle locks in default locking mode. C . Always explicitly code the locks as per the requirement of the application. D . Allow escalation of row locks to block locks if too many row locks cause problem.

  查看最佳答案

• Which two statements are true regarding transactions in an Oracle database（）

  A . Multiple transactions can use the same undo segment. B . A transaction is assigned an undo segment when it is started. C . More than one transaction cannot share the same extent in the undo tablespace. D . The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

  查看最佳答案

• You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

  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.

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  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.

  查看最佳答案

• You performed an incomplete recovery on your Oracle Database 10g database using the following command：  SQL> RECOVER DATABASE  2 UNTIL TIME ’2004­08­05：12：10：03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required？（）

  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.

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  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

  查看最佳答案

• You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

  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.

  查看最佳答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  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.

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

  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.

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  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

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  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）.

  查看最佳答案

• Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

  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.

  查看最佳答案

• 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 .  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

  查看最佳答案

• Which tablespaces are mandatory in an Oracle database for it to be operational（）

  A . Undo tablespace B . USERS tablespace C . SYSAUX tablespace D . SYSTEM tablespace E . Temporary tablespace

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  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）.

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  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.

  查看最佳答案

• In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

  A . Password file  B . Initialization file  C . Datafile  D . Control file  E . Nothing - SYSDBA privileges are not required for these actio

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

  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

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  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.

  查看最佳答案

• Which two are valid locking levels that are used by transactions in an Oracle database？（）

  A . row level B . block level C . object level D . schema level E . database level

  查看最佳答案

• You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

  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.

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案