单选题In which situation would you use the Oracle Shared Server configuration？（）A when performing export and import using Oracle Data PumpB when performing backup and recovery operations using Oracle Recovery ManagerC when performing batch processing and bul

题目
单选题
In which situation would you use the Oracle Shared Server configuration？（）
A

when performing export and import using Oracle Data Pump

B

when performing backup and recovery operations using Oracle Recovery Manager

C

when performing batch processing and bulk loading operation in a data warehouse environment 

D

in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

相似考题

1.When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.

2.You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.

3. While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

4.You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.

更多“单选题In which situation would you use the Oracle Shared Server configuration？（）A when performing export and import using Oracle Data PumpB when performing backup and recovery operations using Oracle Recovery ManagerC when performing batch processing and bul”相关问题

  • 第1题：

    Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

    • A、 use DBMS_IJOB package
    • B、 use Oracle Scheduler
    • C、 use DBMS_JOB package
    • D、 use Oracle Data Pump Export and Import

    正确答案:B

  • 第2题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第3题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第4题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第5题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第6题：

    In which situation would you use the Oracle Shared Server configuration？（）

    • A、when performing export and import using Oracle Data Pump
    • B、when performing backup and recovery operations using Oracle Recovery Manager
    • C、when performing batch processing and bulk loading operation in a data warehouse environment 
    • D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

    正确答案:D

  • 第7题：

    单选题
    In which situation would you use the Oracle Shared Server configuration？（）
    A

    when performing export and import using Oracle Data Pump

    B

    when performing backup and recovery operations using Oracle Recovery Manager

    C

    when performing batch processing and bulk loading operation in a data warehouse environment 

    D

    in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time


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

  • 第8题：

    多选题
    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）
    A

    data file

    B

    password file

    C

    archivelog file

    D

    temporary file

    E

    online redo log file

    F

    the current control file

    G

    the tnsnames.ora file

    H

    current server parameter file


    正确答案： E,B
    解析： 暂无解析

  • 第9题：

    单选题
    When performing password recovery, which command should be entered at the boot prompt?（）
    A

    boot -s

    B

    boot -r

    C

    boot single

    D

    boot recovery


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

  • 第10题：

    单选题
    You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
    A

     The target database must be in the MOUNT mode to ensure restoration of the datafiles.

    B

     You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.

    C

     The control file must be recreated.

    D

     The database must be opened with the RESETLOGS option.


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

  • 第11题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第12题：

    多选题
    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）
    A

    data file

    B

    password file

    C

    archivelog file

    D

    temporary file

    E

    online redo log file

    F

    the current control file

    G

    the tnsnames.ora file

    H

    current server parameter file


    正确答案： B,A
    解析： 暂无解析

  • 第13题：

    You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

    • A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
    • B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
    • C、 The control file must be recreated.
    • D、 The database must be opened with the RESETLOGS option.

    正确答案:C

  • 第14题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第15题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）

    • A、 data file
    • B、 password file
    • C、 archivelog file
    • D、 temporary file
    • E、 online redo log file
    • F、 the current control file
    • G、 the tnsnames.ora file
    • H、 current server parameter file

    正确答案:A,C,F,H

  • 第16题：

    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

    • A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
    • B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
    • C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
    • D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

    正确答案:A

  • 第17题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）

    • A、data file
    • B、password file
    • C、archivelog file
    • D、temporary file
    • E、online redo log file
    • F、the current control file
    • G、the tnsnames.ora file
    • H、current server parameter file

    正确答案:A,C,F,H

  • 第18题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


    正确答案： C,F
    解析： 暂无解析

  • 第19题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第20题：

    单选题
    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
    A

     Block Media Recovery must be used with RMAN.

    B

     You must perform complete recovery of individual blocks.

    C

     You must have a full RMAN backup， not an incremental backup.

    D

     You must use the DBVERIFY utility before using the Block Media Recovery feature.


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

  • 第21题：

    单选题
    Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）
    A

     use DBMS_IJOB package

    B

     use Oracle Scheduler

    C

     use DBMS_JOB package

    D

     use Oracle Data Pump Export and Import


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

  • 第22题：

    单选题
    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


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

  • 第23题：

    单选题
    When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）
    A

    Until SCN

    B

    Until time

    C

    Until cancel

    D

    Recover using backup control file.


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

  • 第24题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

相关内容