OracleDBA邏輯備份試題

    時(shí)間:2022-09-24 01:04:28 試題 我要投稿
    • 相關(guān)推薦

    OracleDBA邏輯備份試題

      q. 1 : what option of exporting allows quicker data extractions

    OracleDBA邏輯備份試題

      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

      4q. 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

    【OracleDBA邏輯備份試題】相關(guān)文章:

    愛(ài)情與邏輯閱讀理解 愛(ài)情與邏輯閱讀答案考試06-25

    備份恢復(fù)管理制度04-24

    邏輯狗教學(xué)總結(jié)04-27

    邏輯崗位職責(zé)01-30

    什么是數(shù)理邏輯04-30

    女人的思維與邏輯散文06-12

    語(yǔ)言學(xué)中的邏輯推理與邏輯論證的論文(通用5篇)07-22

    2.10簡(jiǎn)單的邏輯電路11-26

    邏輯學(xué)總結(jié)感想06-20

    邏輯解題三大技巧04-26

    国产一级a爱做免费播放_91揄拍久久久久无码免费_欧美视频在线播放精品a_亚洲成色在线综合网站免费

      亚洲日韩在线中文字幕线路2区 | 综合激情丁香久久狠狠男同 | 亚洲美女福利视频 | 夜夜精品一区国产 | 精品国产免费二区二区 | 日韩精品视频在线看 |