On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

题目

On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

A、Only the ORD_CUSTOMER_IX1 index created.
B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

A、The database is in mount state.
B、One of the tablespaces is offline.
C、One of the tablespaces is read only.
D、The database operates in ARCHIEVELOG mode.
E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第2题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）

A、 by using the RMAN utility
B、 by using the export/import utility
C、 by using the ALTER DATABASE command
D、 by enabling the change tracking feature

正确答案:C

第3题：

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

参考答案：B

第4题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第5题：

While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）

A、Oracle Managed Files
B、Oracle Grid Architecture
C、Optimal Flexible Architecture
D、Oracle database architecture

正确答案:C

第6题：

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

A、Application Server Control
B、Oracle Management Service
C、Oracle Enterprise Manager Repository
D、Oracle Enterprise Manager Database Control

正确答案:C,D

第7题：

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

A、The Oracle kernel will be placed in this location.
B、The Oracle software will be placed in this location.
C、The server parameter file （SPFILE） will be placed in this location.
D、The database files will be placed in this location， if not specified explicitly.
E、The location will be considered for the base of Oracle Managed Files （OMF）.
F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

正确答案:F

第8题：

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

A、Database Control
B、Management Server
C、Management Repository
D、Application Server Control
E、Oracle Management Agent

正确答案:E

第9题：

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

第10题：

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.

正确答案:D

On your Oracle Database, you is

题目

相似问题和答案

更多相关问题

相关内容