网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）
A
roll back of large transactions
B
roll forward to redo a transaction
C
data concurrency for large updates
D
read consistency for long-running transactions
参考答案
参考解析
解析：
暂无解析
更多 “单选题What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）A roll back of large transactionsB roll forward to redo a transactionC data concurrency for large updatesD read consistency for long-running transactions” 相关考题
考题
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
考题
Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）A、You would configure more listeners for the database.B、You would configure the database in shared server mode to use the connection pooling feature.C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
考题
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
考题
You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） A、 SYSTEMB、 SYSAUXC、 UNDOD、 USERSE、 TEMPF、 This restore is not possible
考题
Which two operations require undo data？（）A、committing a transactionB、rolling back a transactionC、recovering from failed transactionsD、recording a transaction to redo log filesE、rolling forward during instance recovery
考题
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager （RMAN） to roll backF、Uses the System Monitor （SMON） background process to perform instance recovery
考题
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（） A、 An upper limit on how far you can flash back the database，depending on the information in the redo logsB、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
考题
What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）A、roll back of large transactionsB、roll forward to redo a transactionC、data concurrency for large updatesD、read consistency for long-running transactions
考题
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、uses undo data for roll forwardB、uses Flashback Log for recoveryC、uses online redo logs to roll backD、uses undo data to roll back the transactionE、uses Recovery Manager （RMAN） to roll backF、uses the System Monitor （SMON） background process to perform instance recovery
考题
You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）A、PMON coordinates media recovery.B、SMON coordinates instance recovery.C、PMON coordinates instance recovery.D、Undo Advisor would roll back all uncommitted transactions.E、SQL*PLUS reports an error with the message asking you to perform instance recovery.
考题
You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A、Increase the undo returnB、Create more undo segmentsC、Create another undotablespaceD、Increase the size of the undo tablespace
考题
You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）A、restore the tablespace from the backup; there is no need to apply the redo information B、restore the full database to recover the data up to the point when you performed the backup C、restore the tablespace from the backup， and then perform a recovery using the backup control fileD、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
考题
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A、hash clustersB、index clustersC、partitioned tablesD、indexorganized table （IOT）
考题
You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A、 restore the tablespace from the backup； there is no need to apply the redo informationB、 restore the full database to recover the data up to the point when you performed the backupC、 restore the tablespace from the backup and then perform a recovery using the backup control fileD、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
Which three statements are true about database recovery operations？（）A、Damaged or lost data files are restored from backups.B、Redo log file entries are used to roll forward the database.C、Undo segments are used to roll back any uncommitted transactions.D、Transactions that were active when the failure occurred are restarted.E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.
考题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（） A、You should configure the database for Read Committed Snapshot isolation. B、You should modify the stored procedure to use the Snapshot isolation level C、You should configure the database for Auto Update Statistics asynchronously D、You should modify the stored procedure to use the Repeatable Read isolation level
考题
单选题In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A
hash clustersB
index clustersC
partitioned tablesD
indexorganized table （IOT）
考题
单选题One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A
uses undo data for roll forwardB
uses Flashback Log for recoveryC
uses online redo logs to roll backD
uses undo data to roll back the transactionE
uses Recovery Manager （RMAN） to roll backF
uses the System Monitor （SMON） background process to perform instance recovery
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）A
You should configure the database for Read Committed Snapshot isolation. B
You should modify the stored procedure to use the Snapshot isolation level C
You should configure the database for Auto Update Statistics asynchronously D
You should modify the stored procedure to use the Repeatable Read isolation level
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup; there is no need to apply the redo information B
restore the full database to recover the data up to the point when you performed the backup C
restore the tablespace from the backup， and then perform a recovery using the backup control fileD
restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
考题
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A
An upper limit on how far you can flash back the database，depending on the information in the redo logsB
An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC
The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD
The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup； there is no need to apply the redo informationB
restore the full database to recover the data up to the point when you performed the backupC
restore the tablespace from the backup and then perform a recovery using the backup control fileD
restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）A
You would configure more listeners for the database.B
You would configure the database in shared server mode to use the connection pooling feature.C
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
考题
单选题You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A
Uses undo data for roll forwardB
Uses Flashback Log for recoveryC
Uses online redo logs to roll backD
Uses undo data to roll back the transactionE
Uses Recovery Manager （RMAN） to roll backF
Uses the System Monitor （SMON） background process to perform instance recovery
考题
单选题You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A
The database performance would be enhanced.B
The redo log files would be get filled more frequently.C
The overall database performance would be degraded.D
The mean time to recover （MTTR） would be increased.
热门标签
最新试卷
