搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

On your Oracle Database, you issue the following commands to create indexes:<br /> SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;<br /> SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);<br /> 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.

查看正确答案
更多“ On your Oracle Database, you issue the following commands to create indexes:<br /> SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;<br /> SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);<br /> Which two statements are true?（）”相关的问题
第1题
[单选题] View the Exhibit and examine the Data Pump architecture. Identify the numbered components.（）

A、1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API  B、1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader  C、1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump  D、1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump  

点击查看答案
第2题
[单选题] 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  

点击查看答案
第3题
[单选题] Your company network has 500 client computers that run Windows 7. Your team consists of 20 desktop support technicians. Two technicians troubleshoot a hardware-related performance issue on a computer. The technicians obtain different results by using their own User Defined Data Collector Sets. You need to create a standardized Data Collector Set on a network share that is accessible to your team. What should you create?（）

A、Event Trace Data Collector Set  B、Performance Counter Data Collector Set  C、Performance Counter Alert Data Collector Set  D、System Configuration Information Data Collector Set  

点击查看答案
第4题
[多选题] What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? （）

A、ORACLE_BASE should be set explicitly.  B、An Oracle base should have only one Oracle home created in it.  C、Flash recovery area and data file location should be on separate disks.  D、Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.  

点击查看答案
第5题
[单选题] 访问Oracle数据库需要使用的命名空间是（）。

A、System.Data.OleDb  B、System.Data.SqlClient  C、System.Data.Oracle  D、System.Data.Odbc  

点击查看答案
第6题
[单选题] 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  

点击查看答案
第7题
[单选题] 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  

点击查看答案
第8题
[多选题] 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.   

点击查看答案
第9题
[] Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). On a file server, you have a shared folder named Data. The Data folder has the permissions shown in the following table. You need to ensure that members of a group named Sales can modify content in the Data share. Sales group members must only be allowed to delete files that they create. Which additional permission should you assign to the Sales group? （） Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). On a file server, you have a shared folder named Data. The Data folder has the permissions shown in the following table.

A、A. On the Data folder, allow the Write permission.  B、B. On the Data folder, allow the Modify permission.  C、C. On the Data share, allow the Change permission.  D、D. On the Data share, allow the Full Control permission.  

点击查看答案
第10题
[单选题] The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.  B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.  C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.  D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.  E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服