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

题目内容 (请给出正确答案)
单选题
Which statement is true regarding checkpoints and recovery?()
A

A checkpoint defines the highest system change number (SCN).

B

All redo entries higher or at the SCN are known to be written to the data files.

C

Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.

D

The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.


参考答案

参考解析
解析: 暂无解析
更多 “单选题Which statement is true regarding checkpoints and recovery?()A A checkpoint defines the highest system change number (SCN).B All redo entries higher or at the SCN are known to be written to the data files.C Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.” 相关考题
考题 Which statement is true regarding IPsec VPNs?() A. There are five phases of IKE negotiation.B. There are two phases of IKE negotiation.C. IPsec VPN tunnels are not supported on SRX Series devices.D. IPsec VPNs require a tunnel PIC in SRX Series devices.

考题 Which statement is true regarding Backup tasks in Cisco UCS?()A、 They are created automatically and stored on the FIB、 They are created manually and exported to a remote serverC、 They are automatically scheduled to run every 24 hoursD、 They are manually scheduled and stored on the FI

考题 Which statement is true regarding the forwarding plane?()A、The forwarding plane is contained within the Routing Engine (RE)B、The forwarding plane processes and evaluates exception trafficC、The forwarding plane contains the Packet Forwarding Engine (PFE)D、The forwarding plane is not present on all platforms running the Junos OS

考题 Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

考题 Which statement is true regarding syslog on Junos devices?()A、No logging is enabled by defaultB、By default the information is stored in all file named eventsC、Only the message severity level must be configuredD、You can configure the router to send log messages to the console

考题 Which statement is true regarding RMAN components?()A、Each target database requires its own recover catalog. B、RMAN scripts can be stored in the recovery catalog or the target control file. C、A channel is a stream of data to a device type and corresponds to one server session. D、The RMAN executable interprets sever session commands and establishes connections to the target database.

考题 You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 Which two statements are true regarding the ORDER BY clause? ()A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause

考题 Which of the following statement is incorrect regarding RMAN?()A、It detects corrupt blocks.B、It performs only offline database backups.C、It omits empty blocks during backups.D、It performs tablespace point-in-time recovery (TSPITR).

考题 Which statement is true regarding Flashback Version Query? ()A、 It returns versions of rows only within a transaction.B、 It can be used in subqueries contained only in a SELECT statement.C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

考题 Which statement is true regarding checkpoints and recovery?()A、A checkpoint defines the highest system change number (SCN).B、All redo entries higher or at the SCN are known to be written to the data files.C、Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D、The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.

考题 You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).

考题 Which of the following statements is true regarding implementing a Flashback Table recovery?  ()A、 An SCN is never used to perform a Flashback Table recovery.B、 If a significant number of changes have been made to the table, row movement must be enabled.C、 The tablespace must be offline before performing a Flashback Table recovery.D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true?()A Transactions are rolled back using redo log files.B Transactions are rolled forward using redo log files.C Transactions are rolled back using redo log files and archived log files.D Transactions are rolled forward using redo log files and rolled back using redo log files.

考题 单选题Evaluate the following statement:   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()A  They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.B  They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.C  They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.D  The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.

考题 单选题Which of the following statements is true regarding implementing a Flashback Table recovery?  ()A  An SCN is never used to perform a Flashback Table recovery.B  If a significant number of changes have been made to the table, row movement must be enabled.C  The tablespace must be offline before performing a Flashback Table recovery.D  Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

考题 单选题Which of the following statement(s)is/are TRUE regarding a twin pedestal crane set().A The cranes may be operated independentlyB The cranes may be interconnected for twin operationC When twinned,the crane rotation on the foundation assembly is unlimitedD All of the above

考题 单选题Which statement regarding the contents of the V$PARAMETER view is true?()A displays only the list of default valuesB displays only the list of all basic parametersC displays the currently in effect parameter valuesD displays only the list of all advanced parametersE displays the list of all the parameter files of a database

考题 单选题Which statement is true regarding the password-recovery process?()A You must have a console connectionB You cannot set the console port to an insecure modeC You must press the Enter key so that you can boot into single-user modeD When prompted to enter the full pah name of the shell you must press the Enter key

考题 单选题Which statement is true regarding NAT?()A NAT is not supported on SRX Series devices.B NAT requires special hardware on SRX Series devices.C NAT is processed in the control plane.D NAT is processed in the data plane.

考题 单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A  You do not need to restore all the data files.B  You do not need to open the database with the RESETLOGS operationC  You do not need to perform a full backup after the RESETLOGS operation.D  You do not need to recover all the data files to the same system change number (SCN).

考题 单选题Which statement is true regarding checkpoints and recovery?()A A checkpoint defines the highest system change number (SCN).B All redo entries higher or at the SCN are known to be written to the data files.C Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.

考题 单选题Which statement is true regarding the password-recovery process?()A You must have a console connection.B You cannot set the console port to an insecure mode.C You must press the Enter key so that you can boot into single-user mode.D When prompted to enter the full pathname of the shell, you must press the Enter key.

考题 单选题Which statement is true regarding syslog on Junos devices?()A No logging is enabled by defaultB By default the information is stored in all file named eventsC Only the message severity level must be configuredD You can configure the router to send log messages to the console

考题 单选题Which statement is true regarding IPsec VPNs?()A There are five phases of IKE negotiation.B There are two phases of IKE negotiation.C IPsec VPN tunnels are not supported on SRX Series devices.D IPsec VPNs require a tunnel PIC in SRX Series devices.

考题 单选题Which statement is true regarding synonyms?()A Synonyms can be created only for a table B Synonyms are used to reference only those tables that are owned by another user C A public synonym and a private synonym can exist with the same name for the same table D The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

考题 单选题Which of the following statement is incorrect regarding RMAN?()A It detects corrupt blocks.B It performs only offline database backups.C It omits empty blocks during backups.D It performs tablespace point-in-time recovery (TSPITR).

考题 单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A  The target database must be in the MOUNT mode to ensure restoration of the datafiles.B  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C  The control file must be recreated.D  The database must be opened with the RESETLOGS option.