Oracle DBA逻辑备份试题精选
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
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
[NextPage]
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
1
Q. 13 : Import Utility can be used for the following
1. Extract Data from a valid export file
2. Recover from user failure errors when a table is accidentally dropped
3. Create table definitions since they are stored in export file
4. All of the above
4
Q. 14 : What sequence is followed during an import
1. Tables, Indexes, Triggers, Constraints
2. Tables, Triggers, Constraints, Indexes
3. Tables, Indexes, Sequences, Constraints, Triggers
4. None of the above
1
Q. 15 : Which step of the query process is by passed by direct-path export
1. SQL Command Processing Layer
2. Space Management
3. Buffer Cache Management
4. All of the above
1
Q. 16 : This utility can be used to create a logical backup of an object or entire database
1. SQL LOADER
2. EXPORT
3. IMPORT
4. None of the above
2
Q. 17 : Data Loss can occur if you use an Export / Import Strategy Because
1. Rollback Segment contents are Not written to the Export file
2. Archive Log Contents Cannot be Applied After an Import
3. Export may fail due to Referential Integrity constraints
4. None of the above
2
Q. 18 : The best strategy to recover from user errors like dropped or truncated tables is
1. Complete Database Recovery
2. Incremental DB Recovery
3. Export / Import
4. None of the above
3
Q. 19 : Which of the following is a valid export command
1. EXP file= log= FULL=Y TABLE=emp
2. EXP file= log= DIRECT=Y FULL=Y
3. EXP file= log= COMPRESS=Y Access=N
4. None of the above
2 : you cannot specify 2 levels in the same statement; Access=N is not a valid Parameter
Q. 20 : The following modes of export are supported in oracle 8
1. Table
2. User
3. Full
4. All of the above
4
Q. 21 : Which of the following commands is invalid
1. exp file= full=y
2. exp file= full=y compress=y indexes=y
3. exp file= compress=n consistent=y indexes=y inctype=complete
4. None of the above
3 : Must specify full =y incase of an incremental export
Q. 22 : The following types of exports can only be performed in a full database mode
1. Complete
2. Cumulative
3. Incremental
4. All of the above
4
Q. 23 : How can you create a file containing the scripts to create indexes from the export
1. Using the INDEXFILE Option
2. Using the INDEXES option
3. All of the above
4. None of the above
1 : INDEXFILE option can be used during imports to create a file of Index and Table creation scripts.
Q. 24 : When does Import generate less redo
1. Commit=y
2. Destroy=y
3. Consistent=y
4. RecordLength=2*block_size
-
Oracle认证考试指南
小编为各位考生们整理了关于Oracle认证考试指南的专题汇总,希望对大家的复习备考有帮助,请大家抓紧时复习备考吧。报考须知Oracle认证考试介绍Oracle认证考试由Oracle公司授权国际考试认证中心对考生进行资格认证的。考生按考试标准要求参加几门课程的考试(一般...
-
2016年oracle认证常见问题汇总
Oracle认证是由Oracle公司颁布并实施的一项权威的专业技术标准,那么关于Oracle认证,考生们有什么疑惑呢?下面yjbys小编为同学们一一解读!1、问:什么是Oracle认证?都有哪些种类?答:Oracle认证是由Oracle公司颁布并实施的一项权威的专业技术标准,它是专为认证那些能够...
-
Oracle性能分析与优化
一、何时考虑性能的问题。考虑性能的问题应该贯穿于整个系统建设的各个阶段中:系统设计、数据库设计、代码开发、系统运维。1.系统设计阶段:系统架构方面:二层、三层、多层系统类型:OLAP——生成报表等,主要考虑海量数据的处理速度OLTP——主要...
-
Oracle正则表达式汇集
Oracle10g数据库内建了符合IEEEPOSIX(PortableOperatingSystemforUnix)标准的正则表达式。熟练使用正则表达式,可以写出简洁,强大的SQL语句。正则表达式有几个优点优于常见的LIKE操作符和INSTR、SUBSTR及REPLACE函数的。这些传统的SQL函数不便于进行模式匹配。只...
相关文章
- OracleDBA面试题汇总
- 初一上册英语第五单元知识点:Do you have a soccerball
- 高中生优秀英语作文:Have a break away from electronics
- Adobe认证Macromedia Flash8考试大纲
- Adobe认证Macromedia Dreamweaver8考试大纲
- Oracle DBA数据库结构精选试题及答案
- Oracle DBA启动和关闭例程精选试题及答案
- OracleDBA回滚段管理试题
- Diaspora Finance Powers Global Development美文欣赏
- BorlandC++使用BDE访问Oracle的方法