单项选择题

You used the IMMEDIATE option to shut down your databas……

You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened：
1. SGA is allocated.
2. Control file is read.
3. Redo log files are opened.4. Instance recovery is started.
5. Background processes are started.
6. Data file headers are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur（）

A.7， 1， 5， 2， 3， 6， 4
B.1， 5， 7， 2， 3， 6； step 4 is not required
C.7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from =>> http：//www.amaderforum.com
D.1， 2， 3， 5， 6， 4； step 7 is not required

<上一题目录下一题>

热门试题

单项选择题Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have onthe database（）

A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten

单项选择题Youwanttoenablearchivingonyourdatabase.Presently，thedatabaseisrunninginNOARCHIVELOGmode.Givenbelowarethestepstoaccomplishthetaskinrandomorder： 1.Shutdowntheinstance. 2.ExecutetheALTERDATABASEARCHIVELOGcommand. 3.Startuptheinstanceandmountthedatabase. 4.SettheDB_RECOVERY_FILE_DESTinitializationparameterto$ORACLE_HOME dest_1. 5.Openthedatabase. Whichisthecorrectsequenceofstepsforaccomplishingthetask（）

A.4， 1， 3， 2， 5
B.1， 3， 4， 5， 2
C.1， 3， 2， 5； 4 not required
D.4， 1， 5， 2； 3 not required
E.1， 3， 4， 5； 2 not required

单项选择题WhichstatementistrueabouttheUNDO_RETENTIONparameterwhenretentionguaranteeisnotenabled（）

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