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

相似考题

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

2.A system administrator receives a new server and has booted the system for the first time. The administrator has set up the terminals and users. The user start to log on. Root is logged in on the console. When additional users start to log in, an error is displayed stating that All available login sessions are in use. Which of the following steps should be followed to resolve this problem?（）A、Permissions on /etc/security were changed in error; do a chmod 755 on /etc/security directory.B、Increase the number of licenses; using smit chaili censeC、Change the Maximum number of PROCESSES allowed per user variable; using smit chgsys.D、Change User can logi field from false to true: using smit chuser.

3.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 RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）

4.Which statement correctly describes the change tracking writer （CTWR） background process？（）A、 It keeps track of changes in the background processes.B、 It records the system change number （SCN） in the control file.C、 It writes audit records for user changes to the change tracking file.D、 It records any changes to the listened configuration in the listener.ora file.E、 It records any changes to the database parameters in the change tracking file.F、 It records the physical location of all the changes that are made to the database in the change tracking file.

更多“单选题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题：

    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

    • A、Perform Export before TSPITR and Import after TSPITR
    • B、Move objects to another schema that has the same tablespace assigned
    • C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
    • D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

    正确答案:A

  • 第2题：

    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

    • A、 the SQL text
    • B、 the execution plan
    • C、 the execution context
    • D、 the execution frequency
    • E、 the system change number （SCN）

    正确答案:A,C,D

  • 第3题：

    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 option
    • B、open the database with the RESTRICTED option
    • C、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

    正确答案:A,C

  • 第4题：

    What methods of point-in-time recovery are available？（）

    • A、 Change-based
    • B、 Cancel-based
    • C、 Time-based
    • D、 Sequence number-based
    • E、 Transaction number-based

    正确答案:A,B,C,D

  • 第5题：

    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.

    正确答案:C

  • 第6题：

    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

    • A、the SQL text SQL
    • B、the execution plan
    • C、the execution context
    • D、the execution frequency
    • E、the system change number (SCN)

    正确答案:A,C,D

  • 第7题：

    单选题
    Which statement correctly describes the change tracking writer （CTWR） background process？（）
    A

     It keeps track of changes in the background processes.

    B

     It records the system change number （SCN） in the control file.

    C

     It writes audit records for user changes to the change tracking file.

    D

     It records any changes to the listened configuration in the listener.ora file.

    E

     It records any changes to the database parameters in the change tracking file.

    F

     It records the physical location of all the changes that are made to the database in the change tracking file.


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

  • 第8题：

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


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

  • 第9题：

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


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

  • 第10题：

    单选题
    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 operation

    C

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


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

  • 第11题：

    单选题
    Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
    A

     Perform Export before TSPITR and Import after TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


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

  • 第12题：

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


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

  • 第13题：

    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）

    • A、Complete Recovery with online redo log
    • B、Complete Recovery with archived redo log
    • C、Tablespace Point-in-Time Recovery (TSPITR)
    • D、Incomplete Recovery with system change number (SCN)

    正确答案:C

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    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 663571
    • B、perform Flashback Transaction Query with SCN 663571
    • C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
    • D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    正确答案:D

  • 第16题：

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

    正确答案:D

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    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 operation
    • C、 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）.

    正确答案:C

  • 第19题：

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


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

  • 第20题：

    单选题
    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 663571

    B

    perform Flashback Transaction Query with SCN 663571

    C

    execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


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

  • 第21题：

    单选题
    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


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

  • 第22题：

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


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

  • 第23题：

    单选题
    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 ROLLBACK command with SCN 663571.

    B

     Perform Flashback Transaction Query with SCN 663571.

    C

     Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

    D

     Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.


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

  • 第24题：

    单选题
    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
    A

    Perform Export before TSPITR and Import after TSPITR

    B

    Move objects to another schema that has the same tablespace assigned

    C

    Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

    D

    Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)


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

相关内容