OracleDBA逻辑备份试题选

文章作者 100test 发表时间 2007:03:14 13:26:23
来源 100Test.Com百考试题网

q. 1 : what option of exporting allows quicker data extractions

　　1. grants =y
　　2. consistent =y
　　3. direct = true
　　4. direct=y

　　4 : direct=y option bypasses the sql layer to allow quicker data extractions

　　q. 2 : how are exports useful ?

　　1. can be used to recover to a point in time
　　2. can be used to recover from a media failure
　　3. can be used to recover 0dropped tables due a user error
　　4. none of the above

　　3

　　q. 3 : what are the 3 levels of exports

　　1. global, user, tablespace
　　2. full, user, table
　　3. full, tablespace, table
　　4. global, local, transactional

　　2

　　q. 4 : the following methods can be used to run exports

　　1. interactive dialog
　　2. export section of data manager in oem
　　3. command line interface with parameter file
　　4. all of the above

　 4

q. 5 : which of the following are valid parameters for an export utility

　　1. log
　　2. statistics
　　3. direct
　　4. all of the above

4

q. 6 : what incremental parameters can be used with exports

　　1. inctype = complete
　　2. inctype = cumulative
　　3. inctype = incremental
　　4. all of the above

　　4