网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
A
point-in-time recovery
B
execute the ROLLBACK command with transaction number
C
flashback the database to before the transaction was committed
D
determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A point-in-time recoveryB execute the ROLLBACK command with transaction numberC flashback the database to before the transaction was committedD determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery” 相关考题
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()A、Use a flashback query to retrieve the rows that were deletedB、Useconventialincremental export and then import the affected objectC、Shutdown the database inNORMALmode and restart the database instanceD、Use DBMS_META package to reconstruct the object using undo segmentsE、UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the dataF、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()A、 To recover a dropped table.B、 To recover a dropped schema.C、 To recover data from a truncated table.D、 To view changes made by all the transactions during a given period of time.E、 To view changes made by a single transaction during a given period of time.
考题
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) A list of changes made along with the transaction identifier of each change. b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?()A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.
考题
You have a login.ascx control and to display it in a view which method u would use()A、http.displayB、http.partialC、http.loadD、http.get
考题
Which event would you use to run a method immediately after serialization occurs?()A、 OnSerializingB、 OnDeserializingC、 OnSerializedD、 OnDeserialized
考题
单选题You have a login.ascx control and to display it in a view which method u would use()A
http.displayB
http.partialC
http.loadD
http.get
考题
单选题Which of the following changes to sentence 7 would best improve the coherence of the first paragraph?A
Change you to their children.B
Change use to also use.C
Begin the sentence with Nevertheless.D
Begin the sentence with For instance.E
Change to behave to behaving.
考题
单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A
VERSIONS_STARTSCNB
VERSIONS_STARTTIMEC
VERSIONS_XIDD
VERSIONS_OPERATION
考题
单选题You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01, SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The database server configuration, such as IP address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()A
Host namingB
Local namingC
Easy ConnectD
External namingE
directory naming
考题
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.
考题
单选题You enter configuration mode with the configure command. You need to abort the changes that you have made and start again with a fresh copy of the active configuration. Which command should you use?()A
rollback 0B
load activeC
reset configD
clear candidate config
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
单选题Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified timeE
to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
单选题Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified time
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A
use DBMS_IJOB packageB
use Oracle SchedulerC
use DBMS_JOB packageD
use Oracle Data Pump Export and Import
考题
单选题You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use?()A
Only hostB
Only localC
Either host or localD
Both host and local
考题
单选题Which event would you use to run a method immediately after serialization occurs?()A
OnSerializingB
OnDeserializingC
OnSerializedD
OnDeserialized
考题
单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) a list of changes made along with the transaction identifier of each change b) the necessary SQL statements to undo the erroneous changes Which option would you choose?()A
RMAN onlyB
Flashback Table onlyC
Flashback Versions Query onlyD
Flashback Database and Flashback Transaction QueryE
Flashback Versions Query and Flashback Transaction Query
考题
单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) A list of changes made along with the transaction identifier of each change. b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?()A
RMAN only.B
Flashback Table only.C
Flashback Version Query only.D
Flashback Database and Flashback Transaction Query.E
Flashback Version Query and Flashback Transaction Query.
热门标签
最新试卷