单项选择题
In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()
A.The source PL/SQL code will be stored in native machine code.
B.The source PL/SQL code will be stored in interpreted byte code.
C.The compiled PL/SQL code will be stored in native machine code.
D.The compiled PL/SQL code will be stored in interpreted byte code.
相关考题
-
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.OnaMondaymorning,youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile,youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue?()
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
