多选题For which two constraints does the Oracle Server implicitly create a unique index? （）ANOT NULLBPRIMARY KEYCFOREIGN KEYDCHECKEUNIQUE

第1题：

SQL语言中建立惟一性索引的命令是（）

• A、CREATE INDEX索引名ON基本表名（属性名）
• B、CREATE INDEX UNIQUE索引名ON基本表名（属性名）
• C、CREATE UNIQUE INDEX索引名ON基本表名（属性名）
• D、CREATE DISTINCT INDEX索引名ON基本表名（属性名）

第2题：

Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）

• A、CREATE UNIQUE INDEX idx_partno ON parts(part_no)
• B、CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
• C、CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
• D、CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

第3题：

For which two constraints does the Oracle Server implicitly create a unique index?（）

• A、NOT NULL
• B、PRIMARY KEY
• C、FOREIGN KEY
• D、CHECK
• E、UNIQUE

第4题：

在Oracle中，你需要创建索引提高薪水审查的性能，该审查要对员工薪水提高12个百分点后进行分析处理，下面哪个createindex命令能解决此问题（）。

• A、CREATE INDEX my_idx_1 ON employee（salary*1.12）
• B、CREATE UNIQUE INDEX my_idx_1 ON employee（salary）
• C、CREATE BITMAP INDEX my_idx_1 ON employee（salary）
• D、CREATE INDEX my_idx_1 ON employee（salary）REVERSE

第5题：

Which two functional areas does Oracle Application Grid provide ？（）

• A、 Processing Capacity
• B、 Programming IDE
• C、 Management network
• D、 Storage Capacity

第6题：

The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command：    SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS；    SQL> CREATE TABLESPACE INDEXES DATAFILE   ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m；   After that， you issued the following command to recreate the index：    CREATE UNIQUE INDEX sales_index_pk ON sales （order_id）   PCTFREE 10   INITRANS 2   MAXTRANS 255   TABLESPACE indexes   STORAGE （   INITIAL 1m  NEXT 1m   PCTINCREASE 0   MINEXTENTS 1   MAXEXTENTS 8192  ）   NOLOGGING   PARALLEL（ degree 4）   Which two clauses are responsible for reducing the time for the recreation of the index？（）

• A、 PCTFREE
• B、 MAXTRANS
• C、 PCTINCREASE
• D、 INITIAL
• E、 NOLOGGING
• F、 PARALLEL

第7题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（）  

• A、On the Products table, you should create a view. 
• B、On the RadioSize column, you should create a clustered index 
• C、On the RadioSize column, you should create a filtered index 
• D、On the RadioSize column, you should create a unique clustered index

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

用（）命令可以建立唯一索引。

• A、CREATE TABLE
• B、CREATE CLUSTER
• C、CREATE VIEW
• D、CREATE UNIQUE INDEX

第14题：

Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

• A、 It would be created only if a unique index is manually created first.
• B、 It would be created and would use an automatically created unique index.
• C、 It would be created and would use an automatically created nonunique index.
• D、 It would be created and remains in a disabled state because no index is specified in the command.

第15题：

Which two statements are true about constraints? （）

• A、The UNIQUE constraint does not permit a null value for the column.
• B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
• C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
• D、The NOT NULL constraint ensures that null values are not permitted for the column.

第16题：

Examine the command that is used to create a table：  SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；  Which two statements are true about the effect of the above command） （）

• A、A CHECK constraint is created on the OID column.
• B、A NOT NULL constraint is created on the OID column.
• C、The ORDERS table is the only object created in the USERS tablespace.
• D、The ORDERS table and a unique index are created in the USERS tablespace.
• E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

第17题：

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）

• A、Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B、The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C、Only the ORD_CUSTOMER_IX1 index is created.
• D、Only the ORD_CUSTOMER_IX2 index is created.
• E、Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

第18题：

You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50，000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal？（）

• A、Place a nonclustered index on the date column.
• B、Add a unique clustered index on the date column.
• C、Map each partition to a filegroup， with each filegroup accessing a different physical drive.
• D、Create a partitioning scheme that partitions the data by date.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：