单选题What does the SCN represent?（）A The system change number, which is a point in time relative to transactions within a given database. B A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C The security change numbe

题目

单选题

What does the SCN represent?（）

The system change number, which is a point in time relative to transactions within a given database.

A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.

The security change number, which represents the security code that is needed to access any database structure.

A conversion factor that converts internal database time to external clock time.

UTC time in the database, providing a standardized way of tracking time in Oracle.

更多“单选题What does the SCN represent?（）A The system change number, which is a point in time relative to transactions within a given database. B A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C The security change numbe”相关问题

第1题

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

点击查看答案
第2题

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）A、open the database with the RESETLOGS optionB、open the database with the RESTRICTED optionC、recover all the data files to the same system change number （SCN）D、recover to the required SCN only that data file in which the error occurred

点击查看答案
第3题

You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）A、use the ROLLBACK command with SCN 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

点击查看答案
第4题

What methods of point-in-time recovery are available？（）A、 Change-basedB、 Cancel-basedC、 Time-basedD、 Sequence number-basedE、 Transaction number-based

点击查看答案
第5题

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案
第6题

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.

点击查看答案
第7题

What does the SCN represent？（） A、 The system change number， which is a point in time relative to transactions within a given database.B、 A number that represents time. Thus， at 1300 hours， the SCN is the same on all databases. C、 The security change number， which represents the security code that is needed to access any database structure.D、 A conversion factor that converts internal database time to external clock time.E、 UTC time in the database，providing a standardized way of tracking time in Oracle.

点击查看答案

单选题What does the SCN represent?（）A The system change number, which is a point in time relative to transactions within a given database. B A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C The security change numbe

题目

更多“单选题What does the SCN represent?（）A The system change number, which is a point in time relative to transactions within a given database. B A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases. C The security change numbe”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容