OracleDBA逻辑备份试题选

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

　　1. grants =y consistent =y direct = true 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 can be used to recover from a media failure can be used to recover dropped tables due a user error none of the above

　　3

　　q. 3 : what are the 3 levels of exports

　　1. global, user, tablespace full, user, table full, tablespace, table global, local, transactional

　　2

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

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

　 4

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

　　1. log statistics direct all of the above

4

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

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