单项选择题
You work as a database administrator for Certkiller .com. 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.
相关考题
-
单项选择题
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid？（）
A.A
B.B
C.C
D.D -
单项选择题
In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）
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 -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.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
