O ra c l e D BA逻辑备份试题精选
文档信息
主题 关于“IT计算机”中“数据库”的参考范文。
属性 F-0A H AA4d oc格式正文4522字。质优实惠欢迎下载
适用、
正文
OracleDBA逻辑备份试题精选
Oracle DBA逻辑备份试题精选
Q.1:What option of Exporting al lows quicker data extractio
1.Grants=y
2.Coistent=y
3.Direct=true
4.Direct=y
4:Direct=yoption bypasses the SQL layer to al lowquickerdataextractio
Q.2:How are exports useful ?
1.Can be used to recoverto a point in time
2.Can be used to recoverfrom a media fai lure
3.Can be used to recoverdropped tables due a usererror
4.None of the above
Q.3:What are the 3 levels of Exports
1.GLOBAL USER tableSPACE
2. FULL USER table
3. FULL tableSPACE table
4.GLOBAL LOCAL TRAACTIONAL
Q.4:The fol lowing methods can be used to run exports
1. Interactive Dialog
2. ExportSection of Data Manager inOEM
3.Command Line Interface with parameterfi le
4.All of the above
Q.5:Which of the fol lowing are val id paramete foran Exportuti l ity
1.LO G
2.STATISTICS
3.DI RECT
4.All of the Above
Q.6:What Incremental Paramete can be used with exports
1. INCTYPE=complete
2. INCTYPE=cumulative
3. INCTYPE=Incremental
4.All of the above
Q.7:What canyoudoto reducethe burdenon a rol lbacksegmentduring the importof a large table
1.Assign a Large Rol lbackSegment
2.SET TRAACTION USE ROLLBACK SEGMENT RBSLARGE
3.COMMIT=Y
4.None of the above
Q.8:What is anIncremental Export
1. Exportof 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
Q.9:AnIncremental Export is a good strategyfor
1.Appl icatiowithfewlargetablesand lessdatachanges
2.Appl icatiowhere changes are scattered across smal l tables
3.All of the above
4.None of the above
Q.10:What is a Cumulative Export
1. Exportof the objects that have changed since last export
2. Exportof objects that have changed since lastcumulative orcomplete export
3. Exportor rows that have changed since lastcumulative orcomplete export
4.None of the above
Q.11:What option of export uti l ity al lows forfasterextraction ofdata
1. FULL=y
2.DI RECT=Y
3.SQL=N
4.All of the above
[NextPage]
Q.12:Why is Direct Path Export Faster
1.This option By Passes the SQL Layer
2.Al l SGAis used for Export
3.All of the above
4.None of the above
Q.13: Import Uti l itycan be used for the fol lowing
1. Extract Data from a val id export fi le
2.Recoverfrom userfai lure errowhena table isaccidental lydropped
3.Create table definitio since theyare stored in exportfi le
4.All of the above
Q.14:Whatsequence is fol lowed during an import
1.Tables Indexes Trigge Cotraints
2.Tables Trigge Cotraints Indexes
3.Tables Indexes Sequences Cotraints Trigge
4.None of the above
Q.15:Which step of the queryprocess is bypassed bydirect-path export
1.SQL Command Processing Layer
2.Space Management
3.Buffer Cache Management
4.All of the above
Q.16:Thisuti l itycan be used tocreate a logical backupof anobjectorentire database
1.SQL LOADER
2.EXPO RT
3. I M PO RT
4.None of the above
Q.17:Data Loss can occur if you use an Export/ImportStrategyBecause
1.Rol lback Segment contents are Not written to the Export fi le
2.Archive Log Contents Cannot be Appl ied After an Import
3. Export may fai l due to Referential Integrity cotraints
4.None of the above
Q.18:The best strategyto recoverfrom user erro l ike droppedortruncatedtables is
1.Complete Database Recovery
2. Incremental DB Recovery
3.Export/Im port
4.None of the above
Q.19:Whichof thefol lowing is aval id exportcommand
1. EXPfi le= log= FULL=Ytable=emp
2. EXP fi le= log=DIRECT=Y FULL=Y
3. EXP fi le= log=COMPRESS=Y ACCESS=N
4.None of the above
2:you cannotspecify2 levels inthe same statement;Access=Nis not a val id Parameter
Q.20:The fol lowing modes of exportare supported in oracle 8
1.Table
2.User
3. Full
4.All of the above
Q.21:Whichof thefol lowing commands is inval id
1.exp file=full=y
2.exp fi le=ful l=ycompress=y indexes=y
3.exp fi le=compress=n coistent=y indexes=y inctype=complete
4.None of the above
3:Mustspecifyful l =yincase of an incremental export
Q.22:The fol lowing types of exports can only be performed in aful l database mode
1.Complete
2.Cumulative
3. Incremental
4.All of the above
Q.23:Howcan you create a fi le containing the scripts to createindexes from the export
1.UsingtheINDEXFILEOption
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 afi leof Indexand Table creationscripts。
Q.24:Whendoes Importgenerate less redo
1.Commit=y