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

题目内容 (请给出正确答案)
单选题
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
A

 A primary key must have been created.

B

 A mapping table must have been created.

C

 An overflow tablespace must have been specified.

D

 The PCTTHRESHOLD option must have been specified.


参考答案

参考解析
解析: 暂无解析
更多 “单选题While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A  A primary key must have been created.B  A mapping table must have been created.C  An overflow tablespace must have been specified.D  The PCTTHRESHOLD option must have been specified.” 相关考题
考题 While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

考题 The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; ()A、You obtain the results retrieved from the public synonym HR created by the database administrator.B、You obtain the results retrieved from the HR table that belongs to your schema.C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

考题 If you create your database using Oracle Managed Files (OMF), what is true?()A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

考题 While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.

考题 You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file

考题 单选题You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics?()A The baseline, once created, cannot be removed.B Disable the baseline metrics in the Database Control Manage Metrics page.C The baseline will be automatically removed once the database performance has been optimized.D Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

考题 单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can have many datafilesD One datafile can contain many tablespaces

考题 单选题While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()A the CREATE TABLE .. commandB sorting of the SYSTEM tablespace’s dataC sorting of data required by recursive SQL statementsD the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE sorting of data if the users have not been allocated temporary tablespace explicitlyF sorting of data if the users have been allocated temporary tablespace explicitly

考题 单选题While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()A heap tablesB object tablesC partitioned tablesD index­organized tables (IOTs)

考题 单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A  The database will operate normally without generating any redo.B  The database will hang, and you must shut down and restart the instance.C  The database will crash, and you must recover the database from the point of failure.D  The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

考题 单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A  redo log filesB  password fileC  control fileD  change tracking file

考题 单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:   LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional,you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch?()A  The online redo log file Is not allowed to be overwritten.B  The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C  The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D  The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

考题 多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed   that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.  Identify the two events that can occur in the event of a log switch?()AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

考题 单选题In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason, you find that the mapping table segment is fragmented, leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data?()A  Export and import the mapping table.B  Drop and re-create the mapping table.C  Truncate the mapping table and reinsert the values.D  Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

考题 单选题While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A You must have change tracking enabled in your databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace, it must be in backup modeD To back up a tablespace, it must first be taken offline

考题 单选题In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason, you find that the mapping table segment is fragmented, leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data?()A export and import the mapping tableB drop and re-create the mapping tableC truncate the mapping table and reinsert the valuesD use the ALTER TABLE···REBUILD command to defragment the mapping table

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

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true?()A  You must have change tracking enabled in your databaseB  Your database must be running in NOARCHIVELOG modeC  To back up a tablespace,it must be in backup modeD  To back up a tablespace,it must first be taken offline

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database