多项选择题

A.The database files are synchronized.B.Uncommitted cha……

What are the consequences of executing the SHUTDOWN ABORT command？（）

A.The database files are synchronized.
B.Uncommitted changes are not rolled back.
C.The database is closed， but the instance is still started.
D.Database buffers and redo buffers are not written to the disk.
E.The database undergoes automatic media recovery during the next startup.

<上一题目录下一题>

热门试题

多项选择题Datafilesofwhichthreetablespacescanberecoveredbyperforminganopenrecovery？（）

A.TEMP
B.UNDO
C.INDEX
D.SYSAUX
E.SYSTEM

单项选择题Youwanttomigrateyourapplicationfromthedevelopmentenvironmenttotheproductionenvironment.Whiledoingthetask，youwantthedatabaseobjectsownedbytheuserDEVUSERinthedevelopmentenvironmenttobemovedtotheuserAPPSintheproductionenvironment.WhichoptionofOracleDataPumpImportwouldyouusetoachievethisobjective？（）

A.owner
B.touser
C.include
D.schemas
E.fromuser
F.transform
G.remap_schema
H.remap_datafile
I.reuse_datafiles
J.remap_tablespace

单项选择题Inyourdatabase，UNDO_RETENTIONhasbeensetto600secandUNDOtablespaceisconfiguredforRETENTIONGUARANTEE.WhichstatementregardingRETENTIONGUARANTEEistrue？（）

A.Undo data is retained until the next full database backup.
B.No committed undo data will be overwritten for 10 minutes.
C.Committed undo data will be kept forever if not overwritten within 600 seconds.
D.Guarantees that requested undo information are available until the instance is shut down.

单项选择题Exhibit： View the Exhibit to see the information on existing tablespaces of the PROD database. You observe that a large volume of INSERTs and DELETEs are happening on the TRANS table residing in the USERS tablespace， and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find the information about table fragmentation？（）

A.Memory Advisor
B.Segment Advisor
C.SQL Tuning and Access Advisors
D.Automatic Workload Repository （AWR）
E.Automatic Database Diagnostic Monitor （ADDM）

单项选择题WhilerunningtheOracleUniversalInstalleronaUnixplatformtoinstallOracleDatabase10gsoftware，youarepromptedtorunorainstRoot.shscript.Whatdoesthisscriptaccomplish？（）

A.It creates the pointer file.
B.It creates the base directory.
C.It creates the Inventory pointer file.
D.It creates the Oracle user for installation.
E.It modifies the Unix kernel parameters to match Oracle’s requirement.