单项选择题

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）

A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

<上一题目录下一题>

热门试题

单项选择题View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. What happens to the new DML operations in this scenario（）

A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces.
C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

单项选择题You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）

A.CLOB
B.BLOB
C.BFILE
D.LONG RAW

单项选择题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）

A.Archiver Process （ARCn）： 1， 2， 5
B.System Monitor Process （SMON）： 1， 4， 5
C.Process Monitor Process （PMON）： 4， 5， 6
D.Database Writer Process （DBWn）： 1， 3， 4

单项选择题You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler（）

A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D.Recovery Manager （RMAN） script

单项选择题in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）

A.Optimizer statistics are collected automatically.
B.Only timed operating system （OS） statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.