【oracle】Oracle DBA 逻辑备份试题选
【shitiku.jxxyjl.com--Oracle试题集锦】
q. 1 : what option of exporting allows quicker data extractions1. 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 dropped 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
q. 7 : what can you do to reduce the burden on a rollback segment during the import of a large table
1. assign a large rollback segment
2. set transaction use rollback segment rbslarge
3. commit=y
4. none of the above
3
q. 8 : what is an incremental export
1. export of the objects that have changed since last export
2. export of rows that have changed since last export
3. incremental exports cannot be performed in oracle
4. none of the above
1
q. 9 : an incremental export is a good strategy for
1. applications with few large tables and less data changes
2. applications where changes are scattered across small tables
3. all of the above
4. none of the above
2
q. 10 : what is a cumulative export
1. export of the objects that have changed since last export
2. export of objects that have changed since last cumulative or complete export
3. export or rows that have changed since last cumulative or complete export
4. none of the above
2
q. 11 : what option of export utility allows for faster extraction of data
1. full=y
2. direct=y
3. sql=n
4. all of the above
2
q. 12 : why is direct path export faster
1. this option by passes the sql layer
2. all sga is used for export
3. all of the above
4. none of the above
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 dropped 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
q. 7 : what can you do to reduce the burden on a rollback segment during the import of a large table
1. assign a large rollback segment
2. set transaction use rollback segment rbslarge
3. commit=y
4. none of the above
3
q. 8 : what is an incremental export
1. export of the objects that have changed since last export
2. export of rows that have changed since last export
3. incremental exports cannot be performed in oracle
4. none of the above
1
q. 9 : an incremental export is a good strategy for
1. applications with few large tables and less data changes
2. applications where changes are scattered across small tables
3. all of the above
4. none of the above
2
q. 10 : what is a cumulative export
1. export of the objects that have changed since last export
2. export of objects that have changed since last cumulative or complete export
-
国外某公司的营业部经理是一位年轻的女士_国外某公司的Oracle DBA试题详细阅读
oracle dba interview questions by b g 1 how many memory layers are in the shared pool? 2 how do you find out from the rman catalog if a particular a...
-
【oracledba面试题及答案】OracleDBA创建数据库试题精选详细阅读
q 1 : this symbol, when you put infront of a line in the parameter file, 1 $ 2 @ 3 4 ! q 2 : when you change a parameter value...
-
oracle_Oracle DBA 审计数据库试题选详细阅读
q 1 : what feature in oracle allows you to monitor suspicious activity on the datbase 1 replication 2 auditing 3 monitoring 4 tuning...
-
[oracledba面试题及答案]OracleDBA数据库结构题选1详细阅读
q 1 : physical disk resources in an oracle database are 1 control files 2 redo log files 3 data files 4 all of the above 4 q 2 : wha...