单选题Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）A Define a UNIQUE constraint on the columns NEXT_STEPNO

第1题：

第2题：

Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）

• A、Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
• B、Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
• C、Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
• D、Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

第3题：

Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）

• A、Define the column MAINID as NOT UPDATABLE
• B、Define the column MAINID as a PRIMARY KEY
• C、Define the column MAINID as a FOREIGN KEY
• D、Define an UPDATE trigger on table TABLEX

第4题：

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.

第5题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第6题：

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

• A、An update in a leaf row takes place.
• B、The index becomes invalid after the update.
• C、The leaf block containing the row to be updated is marked as invalid.
• D、A row in the leaf block of the index for the key value is deleted and inserted.

第7题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）

• A、Check
• B、Range
• C、Referential
• D、Informational

第14题：

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

• A、A check constraint on the EMPLOYEE table
• B、A unique constraint on the EMPLOYEE table WORKDEPT column
• C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
• D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

第15题：

When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）

• A、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
• B、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
• C、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
• D、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.

第16题：

Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）

• A、An update in a leaf row takes place.
• B、The index becomes invalid after the update.
• C、The leaf block containing the row to be updated is marked as invalid.
• D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted

第17题：

The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）

• A、Column definitions cannot be altered to add DEFAULT values.
• B、A change to the DEFAULT value affects only subsequent insertions to the table.
• C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
• D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

第18题：

You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）

• A、Ensure that the child column and the parent column have the same names.
• B、Ensure that the child table and the parent table have the same names.
• C、Ensure that the child column and the parent column have the same data types.
• D、Ensure that each row in the child table has a corresponding row in the parent table.
• E、Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.

第19题：

Which two statements are true regarding single row functions?（）

• A、They accept only a single argument 
• B、They can be nested only to two levels 
• C、Arguments can only be column values or constants 
• D、They always return a single result row for every row of a queried table 
• E、They can return a data type value different from the one that is referenced

第20题：

第21题：

第22题：

第23题：

第24题：