CMS专题

单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A Undo data becomes obsolete after 1，000 seconds.B Undo data gets refreshed after every 1，0

题目
单选题
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）
A

Undo data becomes obsolete after 1，000 seconds.

B

Undo data gets refreshed after every 1，000 seconds.

C

Undo data will be stored permanently after 1，000 seconds.

D

Committed undo data would be retained for 1，000 seconds if free undo space is available.

E

Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）

A. Set the DB_SECUREFILE parameter to PERMITTED

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL

D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL


参考答案：B

第2题：

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  

  • A、 database buffer cache
  • B、 shared pool
  • C、 PGA
  • D、 large pool

正确答案:B

第3题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value


参考答案：D

第4题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

  • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
  • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
  • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
  • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

正确答案:A

第5题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

  • A、The command would return an error because LOG_BUFFER is a static parameter.
  • B、The parameter value would be changed and it would come into effect immediately.
  • C、You need to restart the database so that parameter changes can come into effect.
  • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

正确答案:A

第6题：

View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()

A. 90 MB

B. 272 MB

C. 362 MB

D. 1,440 MB


参考答案：C

第7题：

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? （）

  • A、Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  • B、Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  • C、Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
  • D、Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

正确答案:A,D

第8题：

The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）

A. ARCHIVELOG mode must be enabled

B. Row Movement must be enabled for the table

C. FLASHBACK must be set to ON for the database

D. The UNDO_MANAGEMENT parameter must be set to AUTO

E. The UNDO_RETENTION parameter must be set appropriately


参考答案：D, E

第9题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  • A、 The database will not start.
  • B、 The database will start but will not retain the undo data in the undo segment.
  • C、 The database will start， and the undo segment will contain the undo data for at least one hour.
  • D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

正确答案:D

第10题：

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

  • A、Set the UNDO_RETENTION parameter to AUTO.
  • B、Create an initial undo segment in undotablespace.
  • C、Set the UNDO_RETENTION parameter to 900 or more
  • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
  • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

正确答案:D,E

更多相关问题
相关内容