网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 Which two statements are true regarding the starting of the database instance using the following command?()SQLSTARTUP 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.

考题 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

考题 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.

考题 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.

考题 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.

考题 Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP 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.

考题 which one of the following database elements is not updated when the design task is run?()A、formsB、viewsC、rolesD、agents

考题 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.

考题 Which two statements are true about the Automatic Diagnostic Repository (ADR)?() 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

考题 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 filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

考题 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.

考题 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.

考题 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.

考题 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.

考题 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

考题 多选题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?()AIt records the usernames and passwords of users when granted the DBA role.BIt contains the usernames and passwords of users for whom auditing is enabled.CIs used by Oracle to authenticate users for remote database administration.DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

考题 多选题Concerning the figure below, if a =b, which of the following statements must be true? (Indicate all such statements.)Ac=dBl and k are parallelCm and l are perpendicular

考题 多选题Which of the following statements are true? (Indicate all such statements.)Aτ(5) =τ(7)Bτ(5) τ(7) =τ(35)Cτ(5) + τ(7) =τ(12)

考题 多选题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?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

考题 单选题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.

考题 多选题Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g?()AOnly the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).BThe problem key is the same as the incident number.CThe database sends an incident alert to the Oracle Enterprise Manager Database Home page.DEvery problem has a problem key, which is a text string that describes the problem.EThe database makes an entry into the alert log file when problems and incidents occur.

考题 多选题Which three statements are true about database recovery operations?()ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DTransactions that were active when the failure occurred are restarted.ETransactions that were active when the failure occurred are automatically committed during the recover procedure.

考题 多选题Which of the following statements about variables and scope are true?()ALocal variables defined inside a method are destroyed when the method is exited.BLocal variables are also called automatic variables.CVariables defined outside a method are created when the object is constructed.DA method parameter variable continues to exist for as long as the object is needed in which the method is defined.

考题 多选题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? ()Athis is a multi-node installationBthis is a single node installation.Ceach hardware and software component is a single point of failure.Dthis is an example of load balancing.

考题 多选题Which two statements are true about record groups?()AThey are stored in the database.BThey are stored in local Forms memory.CThe type is specified explicitly at design time.DThe type is implied by when and how it is created.

考题 单选题Which of the following commands cannot be executed when the database open?()A RECOVER DATABASEB RECOVER TABLESPACEC RECOVER DATAFILED ALTER DATABASE RECOVER DATAFILE

考题 多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?()AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances

考题 单选题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 fireB Carbon dioxide should be applied slowly to a large engine room fireC Its total cooling effect is far greater than waterD Its smothering effect is excellent for class B fires