网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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.” 相关考题
考题
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.
考题
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.
考题
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.
考题
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）
考题
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 TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
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 logB、Complete Recovery with archived redo logC、Tablespace Point-in-Time Recovery (TSPITR)D、Incomplete Recovery with system change number (SCN)
考题
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 textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number （SCN）
考题
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.
考题
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
考题
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
考题
What methods of point-in-time recovery are available？（）A、 Change-basedB、 Cancel-basedC、 Time-basedD、 Sequence number-basedE、 Transaction number-based
考题
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
考题
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.
考题
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.
考题
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 SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
考题
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 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 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 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.
考题
单选题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
考题
单选题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.
考题
单选题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 logB
Complete Recovery with archived redo logC
Tablespace Point-in-Time Recovery (TSPITR)D
Incomplete Recovery with system change number (SCN)
考题
单选题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）.
考题
单选题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
考题
单选题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 TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D
Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
考题
单选题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.
考题
单选题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.
考题
单选题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 TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
热门标签
最新试卷
