1、which two steps are performed the first time any UPDATE statment is issued after the instance is started?choose two
A creating the parse tree of the statment
B wirting the modified data blocks to the data files
C writing the modified data to the archived redo log files
D updating the control file to indicate the most recent checkpoint
E uodating the data file header to indicate the most recent checkpoint
答案 C D
2、Inyour cerkiller.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 archive 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 modfy the value for LDAP_DIRECTORY_ACCESS parameter in the
parameter file
D modify the value for PLSQL_NATIVE_LIBRARY_DIR parameter in the
parameter file
E create a directory object referring to the operating system path, and
grant read and wirte privilege on the directory object to the database
users
答案:A
帮忙看看答案对吗?
第一题少写了一个答案
F. Reading the blocks to database buffer cache if they are not already there
我觉得应该选A,F
选项C, 应该在Commit以后执行
选项D, 应该在Checkpoint事件发生以后执行
这是我个人的理解, 我也是初学, 还希望高手给出权威答案
第二题我在网上查了一下,找了一下帮助。
UTL_FILE_DIR应该是9i以前使用utl_file包使用的参数,如果UTL_FILE_DIR=*,即可以访问任意目录。
9i以后有了directory,oracle推荐使用directory方法。