单项选择题

You work as a database administrator for Supportcenter.cn. 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.

<上一题目录下一题>

热门试题

单项选择题InyourSupportcenter.cnproductiondatabase，youfindthatthedatabaseusersareabletocreateandreadfileswithunstructureddata，availableinanylocationonthehostmachinefromanapplication.Youwanttorestrictthedatabaseuserstoaccessfilesinaspecificlocationonthehostmachine.Whatcoulddotoachievethis？（）

A.Modify the value for the UTL_FILE_DIR parameter in the parameter file
B.Grant read and write privilege on the operating system path to the database users
C.Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
D.Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
E.Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Yourdatabaseisconfiguredforautomaticundomanagement.UNDO_RETENTIONissetto3hours.Youwanttoflashbackatablethatwascreatedlastyear.Howfarbackcantheflashbackquerygo？（）

A.3 hours
B.6 months
C.until last year
D.until last commit
E.until the point when the undotablespacewas refreshed
F.until the database is shut down and the memory erased

单项选择题TheoperatingsystemfilecratabintheLinuxplatformgetsupdatedwheneveryoucreateanewdatabaseonthesamehostmachine.Whatkindofinformationisstoredisstoredinthisfile？（）

A.OracleSIDsonly
B.Oracle homes only
C.Oracle install timestamp
D.Oracle inventory pointer files
E.Oracle database creation timestamp
F.OracleSIDsand Oracle homes only
G.OracleSIDs， Oracle homes and flag for auto startup

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto u01 app oracle.Whichobjectivewillbeachievedbythissetting？（）

A.The Oracle kernel will be placed in this location.
B.The Oracle software will be placed in this location.
C.The server parameter file （SPFILE） will be placed in this location.
D.The database files will be placed in this location， if not specified explicitly.
E.The location will be considered for the base of Oracle Managed Files （OMF）.
F.The location will be considered for the base of Optimal Flexible Architecture （OFA）.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YoufindthatuserswithDBAroleareusingmoreCPUresourcesthanwhatisallocatedintheirprofiles.Whichactionwouldyoutaketoensurethatresourceslimitsareimposedontheseusers？（）

A.Assign the DEFAULT profile to the users
B.Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
C.Create a new profile with CPU restrictions and assign it to the users
D.Specify the users as members of the DEFAULT_CONSUMER_GROUP
E.Revoke the DBA role and grant CONNECT and RESOURCE role to the users