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

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

相似考题

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

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

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

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

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题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 consiste”相关问题

  • 第1题：

    Which two operations require undo data？（）

    • A、committing a transaction
    • B、rolling back a transaction
    • C、recovering from failed transactions
    • D、recording a transaction to redo log files
    • E、rolling forward during instance recovery

    正确答案:B,C

  • 第2题：

    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 logs
    • B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
    • C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
    • D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space

    正确答案:C

  • 第3题：

    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 forward
    • B、uses Flashback Log for recovery
    • C、uses online redo logs to roll back
    • D、uses undo data to roll back the transaction
    • E、uses Recovery Manager （RMAN） to roll back
    • F、uses the System Monitor （SMON） background process to perform instance recovery

    正确答案:D

  • 第4题：

    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 return
    • B、Create more undo segments
    • C、Create another undotablespace
    • D、Increase the size of the undo tablespace

    正确答案:D

  • 第5题：

    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 clusters
    • B、index clusters
    • C、partitioned tables
    • D、index­organized table （IOT）

    正确答案:B

  • 第6题：

    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.

    正确答案:A,B,C

  • 第7题：

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

    B

    index clusters

    C

    partitioned tables

    D

    index­organized table （IOT）


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

  • 第8题：

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


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

  • 第9题：

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

    D

    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


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

  • 第10题：

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

    D

     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


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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    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 forward
    • B、Uses Flashback Log for recovery
    • C、Uses online redo logs to roll back
    • D、Uses undo data to roll back the transaction
    • E、Uses Recovery Manager （RMAN） to roll back
    • F、Uses the System Monitor （SMON） background process to perform instance recovery

    正确答案:D

  • 第14题：

    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

    正确答案:D

  • 第15题：

    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. 

    正确答案:B

  • 第16题：

    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 file
    • D、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

    正确答案:D

  • 第17题：

    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 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 file
    • D、 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

    正确答案:D

  • 第18题：

    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

    正确答案:B

  • 第19题：

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

    B

    uses Flashback Log for recovery

    C

    uses online redo logs to roll back

    D

    uses undo data to roll back the transaction

    E

    uses Recovery Manager （RMAN） to roll back

    F

    uses the System Monitor （SMON） background process to perform instance recovery


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

  • 第20题：

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

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第21题：

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

    B

     An upper limit on how far you can flash back the database，depending on the information in the undo tablespace

    C

     The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space

    D

     The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space


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

  • 第22题：

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

    B

    Segment Advisor

    C

    SQL Tuning Advisor

    D

    SQL Access Advisor

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第23题：

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

    B

    Uses Flashback Log for recovery

    C

    Uses online redo logs to roll back

    D

    Uses undo data to roll back the transaction

    E

    Uses Recovery Manager （RMAN） to roll back

    F

    Uses the System Monitor （SMON） background process to perform instance recovery


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

相关内容