网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
热门标签
最新试卷