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
-
计算机二级c++主要考试内容
C++是一种面向对象的计算机程序设计语言。C++这个词在中国大陆的程序员圈子中通常被读做C加加,而西方的程序员通常读做Cplusplus,CPP。下面是小编整理的关于计算机二级c++主要考试内容,欢迎参考!基本要求1.掌握C++语言的基本语法规则。2.熟练掌握有关类与对象的相...
-
2016年最新J2EE面试题及答案
J2EE核心是一组技术规范与指南,其中所包含的各类组件、服务架构及技术层次,均有共同的标准及规格,让各种依循J2EE架构的不同平台之间,存在良好的兼容性,解决过去企业后端使用的信息产品彼此之间无法兼容,企业内部或外部难以互通的窘境。下面本站小编为大家整理了关于...
-
2016年J2EE认证试题(附答案)
J2EE用来建设大型的分布式企业级应用程序。或者用更时髦的名词说就是电子商务应用程序。下面本站小编为大家推荐的是J2EE认证考试题,希望对大家有所帮助!一、基础问答1.下面哪些类可以被继承?java.lang.Thread(T)java.lang.Number(T)java.lang.Double(F)java.la...
-
2017年计算机二级office备考相关知识积累
多媒体技术从不同的角度有着不同的定义。比如有人定义多媒体计算机是一组硬件和软件设备;结合了各种视觉和听觉媒体,能够产生令人印象深刻的视听效果。下面是小编整理的关于计算机二级office备考相关知识积累,欢迎大家参考!一、多媒体技术的概念与应用。1.多媒体...