单选题ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()

题目
单选题
ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()
A

parallel image copy backup 

B

backup with MAXPIECESIZE configured for the channel 

C

parallel backup with MAXPIECESIZE configured for the channel 

D

intrafile parallel backup


相似考题
更多“单选题ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()”相关问题
  • 第1题:

    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently?()  

    • A、 parallel image copy backup
    • B、 backup with MAXPIECESIZE configured for the channel
    • C、 parallel backup with MAXPIECESIZE configured for the channe
    • D、 intrafile parallel backup

    正确答案:D

  • 第2题:

    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()

    • A、 take data files from the read-only tablespace offline before performing a recovery
    • B、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
    • C、 drop the read-only tablespace and re-create the tablespace after recovery
    • D、 perform a recovery; status of the tablespace in control file will be changed automatically

    正确答案:A

  • 第3题:

    You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()

    • A、FULL
    • B、SCHEMAS
    • C、REMAP_SCHEMA
    • D、REMAP_DATAFILES
    • E、REMAP_TABLESPACE

    正确答案:C

  • 第4题:

    You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()

    • A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
    • B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
    • C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
    • D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

    正确答案:B

  • 第5题:

    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()

    • A、Multiplex all database files.
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter

    正确答案:C

  • 第6题:

    You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task()

    • A、FULL
    • B、SCHEMAS
    • C、TRANSFORM
    • D、REMAP_SCHEMA
    • E、REMAP_TABLESPACE

    正确答案:D

  • 第7题:

    单选题
    You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()
    A

    FULL

    B

    SCHEMAS

    C

    REMAP_SCHEMA

    D

    REMAP_DATAFILES

    E

    REMAP_TABLESPACE


    正确答案: B
    解析: 暂无解析

  • 第8题:

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()
    A

    Multiplex all database files

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter.


    正确答案: C
    解析: 暂无解析

  • 第9题:

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file, just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


    正确答案: A
    解析: 暂无解析

  • 第10题:

    单选题
    You work as a database administrator for Certkiller .com. In your production  database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task?()
    A

    You must have started the database instance in restricted mode.

    B

    You must have started the database instance inNORMALmode.

    C

    You must have started the database instance with server parameter file.

    D

    You must have started the database instance but must not have mounted.

    E

    You must have started the database instance but must not have opened.


    正确答案: E
    解析: 暂无解析

  • 第11题:

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()
    A

    Multiplex all database files.

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter


    正确答案: A
    解析: 暂无解析

  • 第12题:

    多选题
    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()
    A

    The RMAN parallelizes the backup although the parallelism is not set for a channel.

    B

    The backup piece size will be limited to 300 MB.

    C

    The operation is accomplished using the default channel available.

    D

    Three channels for the tape drive must be configured by setting the parallelism to three.


    正确答案: B,D
    解析: 暂无解析

  • 第13题:

    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()

    • A、SQL*Plus
    • B、iSQL*Plus
    • C、Management Server
    • D、Management Repository
    • E、Oracle Enterprise Manager 10g Database Control

    正确答案:E

  • 第14题:

    You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    • A、The backups would be consistent.
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure

    正确答案:B,C,E

  • 第15题:

    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()

    • A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
    • B、 The backup piece size will be limited to 300 MB.
    • C、 The operation is accomplished using the default channel available.
    • D、 Three channels for the tape drive must be configured by setting the parallelism to three.

    正确答案:B,C

  • 第16题:

    ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()

    • A、parallel image copy backup 
    • B、backup with MAXPIECESIZE configured for the channel 
    • C、parallel backup with MAXPIECESIZE configured for the channel 
    • D、intrafile parallel backup

    正确答案:D

  • 第17题:

    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task?()

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第18题:

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    • A、Multiplex all database files
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:C

  • 第19题:

    单选题
    You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task()
    A

    FULL

    B

    SCHEMAS

    C

    TRANSFORM

    D

    REMAP_SCHEMA

    E

    REMAP_TABLESPACE


    正确答案: A
    解析: 暂无解析

  • 第20题:

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently?()
    A

     parallel image copy backup

    B

     backup with MAXPIECESIZE configured for the channel

    C

     parallel backup with MAXPIECESIZE configured for the channe

    D

     intrafile parallel backup


    正确答案: B
    解析: 暂无解析

  • 第21题:

    单选题
    You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:   RMAN>BACKUP SECTION SIZE 300M TABLESPACE users;   What configuration should be effected to accomplish faster and optimized backups by using the above command?()
    A

     The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1

    B

     The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0

    C

     The SBT channel must be configured, with the parallelism setting for the SBT device set to 3

    D

     The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB


    正确答案: C
    解析: 暂无解析

  • 第22题:

    单选题
    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()
    A

    SQL*Plus

    B

    iSQL*Plus

    C

    Management Server

    D

    Management Repository

    E

    Oracle Enterprise Manager 10g Database Control


    正确答案: D
    解析: 暂无解析

  • 第23题:

    单选题
    ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()
    A

    parallel image copy backup 

    B

    backup with MAXPIECESIZE configured for the channel 

    C

    parallel backup with MAXPIECESIZE configured for the channel 

    D

    intrafile parallel backup


    正确答案: A
    解析: 暂无解析

  • 第24题:

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?()
    A

    parallel image copy backup

    B

    backup with MAXPIECESIZE configured for the channel

    C

    parallel backup with MAXPIECESIZE configured for the channel

    D

    intrafile parallel backup


    正确答案: D
    解析: 暂无解析