网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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

参考答案

更多 “ 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” 相关考题
考题 You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?()A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 Which three statements are true about Oracle Data Pump export and import operations?() A. You can detach from a data pump export job and reattach later.B. Data pump uses parallel execution server processes to implement parallel import.C. Data pump import requires the import file to be in a directory owned by the oracle owner.D. The master table is the last object to be exported by the data pump.E. You can detach from a data pump import job and reattach later.

考题 You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the 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 the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

考题 Which  statements are true regarding the Oracle Data Pump export and import operations()A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported

考题 You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

考题 Which three statements are true about Oracle Data Pump export and import operations?()A、You can detach from a data pump export job and reattach later.B、Data pump uses parallel execution server processes to implement parallel import.C、Data pump import requires the import file to be in a directory owned by the oracle owner.D、The master table is the last object to be exported by the data pump.E、You can detach from a data pump import job and reattach later.

考题 You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based?()A、 column sizesB、 column data typesC、 PCTFREED、 projected number of rowE、 PCTUSED

考题 You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter

考题 You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 Which two statements are true regarding the Oracle Data Pump export and import operations()A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported.

考题 Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?() A、 Generate reports on data failure such as data file failures.B、 You can track the Service Request (SR) and implement repairs.C、 You can package and upload diagnostic data to Oracle Support.D、 You can manually run health checks to gather diagnostic data for a problem.

考题 单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A SYSTEM B OUTLN C INTERNAL D SYS

考题 单选题You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A  by using the DBMS_REPAIR packageB  by using the DBVERIFY utilityC  by using Block Media RecoveryD  by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ,you issued the following ASMCMD command:   ASMCMD lsdsk -I -d DATA   Which statement is true regarding the outcome of this command?()A  The command succeeds but it retrieves only the disk names.B  The command produces an error because the ASM instance is down.C  The command succeeds but it shows only the status of the ASM instance.D  The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

考题 多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.

考题 单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the 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 the SQL*Loader utility.D Use the INSERT INTO...SELECT command to load the data.

考题 单选题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 backupB backup with MAXPIECESIZE configured for the channelC parallel backup with MAXPIECESIZE configured for the channelD intrafile parallel backup

考题 单选题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 backupB  backup with MAXPIECESIZE configured for the channelC  parallel backup with MAXPIECESIZE configured for the channeD  intrafile parallel backup

考题 多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger

考题 单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands:   RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK;   What are the implications of this command?()A  It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B  It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C  It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D  It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()A  One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.B  One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.C  One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.D  One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.

考题 单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the database is closed

考题 单选题You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based?()A  column sizesB  column data typesC  PCTFREED  projected number of rowE  PCTUSED

考题 单选题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.

考题 单选题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 populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

考题 单选题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

考题 单选题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 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

考题 单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()A The command succeeds but it retrieves only the disk names.B The command produces an error because the ASM instance is down.C The command succeeds but it shows only the status of the ASM instance.D The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.