范文无忧网面试笔试笔试回答

OracleDBA逻辑备份笔试题

11月20日 编辑 fanwen51.com

[OracleDBA启动和关闭例程笔试题]q. 1 : the database must be in this mode for the instance to be started 1. mount 2. open 3. nomount 4. none 3 q. 2 : when oracle startups up, what happens if a...+阅读

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. mand 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

延伸阅读:

OracleDBA创建数据库笔试题q. 1 : this symbol, when you put infront of a line in the parameter file, 1. $ 2. # 3. # 4. ! 3 q. 2 : when you change a parameter value in the parameter file,...

面试要有足够的简历备份足够的简历备份。 当用人单位是由多个面试官进行集体面试的时候,他们未必都把你的简历打印了多份,带多几份简历前往面试,显示你准备得充分,这样不仅能助你获得好感,面试完了也可...

OracleDBA数据库结构笔试题OracleDBA数据库结构笔试题 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 :...

OracleDBA存储管理笔试题q. 1 : oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows. 1. true 2. false 2 q. 2...

足够的简历备份足够的简历备份。 当用人单位是由多个面试官进行集体面试的时候,他们未必都把你的简历打印了多份,带多几份简历前往面试,显示你准备得充分,这样不仅能助你获得好感,面试完了也可...

OracleDBA笔试题解释冷备份和热备份的不同点以及各自的优点 解答:热备份针对归档模式的数据库,在数据库仍旧处于工作状态时进行备份。而冷备份指在数据库关闭后,进行备份,适用于所有模式的数据...

OracleDBA数据库结构试题选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 : what is a schema 1. a physic...

OracleDBA用户管理笔试题q. 1 : the default tablespace clause in the create user mand sets the location for 1. database objects created by the user 2. temporary objects created by the u...

推荐阅读
图文推荐
栏目列表