单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）AArchive log generation is suspended until the tablespaces are taken out of hot backup mode. BDatafiles are not written to durin

题目
单选题
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）
A

 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 

B

 Datafiles are not written to during hot backups.

C

 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

D

 The datafile headers are not updated during the backup.

E

 The way data is written to the online redo logs is unchanged during the backup.

相似考题

1.Which two statements are true regarding the starting of the database instance using the following command?()SQL>STARTUP UPGRADEA. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade process.D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

2.You Execute the Following command to create a password file in the database server:$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’Which two statements are true about the password file?（）A. It records the usernames and passwords of users when granted the DBA role.B. It contains the usernames and passwords of users for whom auditing is enabled.C. Is used by Oracle to authenticate users for remote database administration.D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

3.When WebSphere Commerce， WebSphere Application Server， the web server and the database server are all located on a single machine， which of the following statements are TRUE？ （）A、this is a multi-node installationB、this is a single node installation.C、each hardware and software component is a single point of failure.D、this is an example of load balancing.

4.Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Which of the following statements is true when the database ”相关问题

  • 第1题：

    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 

    • A、 The command restores only the missing control file.
    • B、 The command restores all the control files.
    • C、 The command fails because the database is running.
    • D、 This is the correct way to address this problem.
    • E、 This is not the correct way to address this problem.

    正确答案:C,E

  • 第2题：

    which one of the following database elements is not updated when the design task is run?（）

    • A、forms
    • B、views
    • C、roles
    • D、agents

    正确答案:C

  • 第3题：

    Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） 

    • A、 The ADR base keeps all diagnostic information in binary format
    • B、 SQL*Plus provides the ADRI script， which can be used to work with ADR
    • C、 The ADR can be used for problem diagnosis only when the database is open
    • D、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
    • E、 The ADR can be used for problem diagnosis even when the database instance is down
    • F、 The ADR base is shared across multiple instances

    正确答案:E,F

  • 第4题：

    Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）  

    • A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.
    • B、 The problem key is the same as the incident number.
    • C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
    • D、 Every problem has a problem key， which is a text string that describes the problem.
    • E、 The database makes an entry into the alert log file when problems and incidents occur.

    正确答案:C,D,E

  • 第5题：

    Which two statements about Flashback Query are true？（）

    • A、It is generated by using the redo log files. 
    • B、It helps in row-level recovery from user errors.
    • C、It can be performed to recover ALTER TABLE statements 
    • D、It fails when undo data pertaining to the transaction is overwritten.
    • E、The database has to be opened with the resetlogs option after performing Flashback Query.

    正确答案:B,D

  • 第6题：

    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

    • A、When the instance is started 
    • B、When the database is mounted 
    • C、When the database is opened 
    • D、When the database is closed

    正确答案:A

  • 第7题：

    多选题
    Concerning the figure below, if a =b, which of the following statements must be true? (Indicate all such statements.)
    A

    c=d

    B

    l and k are parallel

    C

    m and l are perpendicular


    正确答案： C,B
    解析：
    根据题目中的已知信息无法推断出各直线的关系，因此B、C均不正确；而由图示可知，c和d分别是a和b的补角，由于a=b，所以c=d，A项正确。

  • 第8题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


    正确答案： B,C
    解析： 暂无解析

  • 第9题：

    多选题
    Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）
    A

    Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.

    B

    The problem key is the same as the incident number.

    C

    The database sends an incident alert to the Oracle Enterprise Manager Database Home page.

    D

    Every problem has a problem key， which is a text string that describes the problem.

    E

    The database makes an entry into the alert log file when problems and incidents occur.


    正确答案： D,E
    解析： 暂无解析

  • 第10题：

    多选题
    Which of the following statements about variables and scope are true？（）
    A

    Local variables defined inside a method are destroyed when the method is exited.

    B

    Local variables are also called automatic variables.

    C

    Variables defined outside a method are created when the object is constructed.

    D

    A method parameter variable continues to exist for as long as the object is needed in which the method is defined.


    正确答案： C,A
    解析： 本题是讨论变量的类型及作用域。

  • 第11题：

    多选题
    Which two statements are true about record groups?（）
    A

    They are stored in the database.

    B

    They are stored in local Forms memory.

    C

    The type is specified explicitly at design time.

    D

    The type is implied by when and how it is created.


    正确答案： D,A
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）
    A

    The ADR base keeps all diagnostic information in binary format

    B

    SQL*Plus provides the ADRI script, which can be used to work with ADR

    C

    The ADR can be used for problem diagnosis only when the database is open

    D

    The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

    E

    The ADR can be used for problem diagnosis even when the database instance is down

    F

    The ADR base is shared across multiple instances


    正确答案： E,F
    解析： 暂无解析

  • 第13题：

    Which two statements are true regarding the starting of the database instance using the following command?（） SQL>STARTUP UPGRADE

    • A、It enables all system triggers.
    • B、It allows only SYSDBA connections.
    • C、It ensures that all job queues remain active during the upgrade process.
    • D、It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

    正确答案:B,D

  • 第14题：

    Which of the following statements are true？（） 

    • A、 The equals（） method determines if reference values refer to the same object.
    • B、 The == operator determines if the contents and type of two separate objects match.
    • C、 The equals（） method returns true only when the contents of two objects match.
    • D、 The class File overrides equals（） to return true if the contents and type of two separate objects        match.

    正确答案:A,D

  • 第15题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第16题：

    Which two statements are true about record groups?（）

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第17题：

    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

    • A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 
    • B、 Datafiles are not written to during hot backups.
    • C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
    • D、 The datafile headers are not updated during the backup.
    • E、 The way data is written to the online redo logs is unchanged during the backup.

    正确答案:D

  • 第18题：

    多选题
    You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
    A

    It records the usernames and passwords of users when granted the DBA role.

    B

    It contains the usernames and passwords of users for whom auditing is enabled.

    C

    Is used by Oracle to authenticate users for remote database administration.

    D

    It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

    E

    It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.


    正确答案： E,B
    解析： 暂无解析

  • 第19题：

    多选题
    Which of the following statements are true? (Indicate all such statements.)
    A

    τ(5) =τ(7)

    B

    τ(5) τ(7) =τ(35)

    C

    τ(5) + τ(7) =τ(12)


    正确答案： A,B
    解析：
    5和7均只有两个正除数，因此根据题干信息，A项正确；35有四个正除数，所以B项也是正确的；12有6个正除数，因此C项错误；选择A、B两项。

  • 第20题：

    单选题
    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）
    A

     Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 

    B

     Datafiles are not written to during hot backups.

    C

     Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

    D

     The datafile headers are not updated during the backup.

    E

     The way data is written to the online redo logs is unchanged during the backup.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    Which three statements are true about database recovery operations？（）
    A

    Damaged or lost data files are restored from backups.

    B

    Redo log file entries are used to roll forward the database.

    C

    Undo segments are used to roll back any uncommitted transactions.

    D

    Transactions that were active when the failure occurred are restarted.

    E

    Transactions that were active when the failure occurred are automatically committed during the recover procedure.


    正确答案： E,A
    解析： 暂无解析

  • 第22题：

    多选题
    When WebSphere Commerce， WebSphere Application Server， the web server and the database server are all located on a single machine， which of the following statements are TRUE？ （）
    A

    this is a multi-node installation

    B

    this is a single node installation.

    C

    each hardware and software component is a single point of failure.

    D

    this is an example of load balancing.


    正确答案： D,A
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following commands cannot be executed when the database open？（）
    A

    RECOVER DATABASE

    B

    RECOVER TABLESPACE

    C

    RECOVER DATAFILE

    D

    ALTER DATABASE RECOVER DATAFILE


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Which of the following statements is true concerning carbon dioxide when used as a fire extinguishing agent?（）
    A

    Carbon dioxide is corrosive when exposed to fire

    B

    Carbon dioxide should be applied slowly to a large engine room fire

    C

    Its total cooling effect is far greater than water

    D

    Its smothering effect is excellent for class B fires


    正确答案： A
    解析： 暂无解析

相关内容