Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
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.
第1题:
A.Check
B.Range
C.Referential
D.Informational
第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?()
第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?()
第4题:
Which two statements are true about constraints? ()
第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?()
第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?()
第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?()
第8题:
Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
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.
第9题:
Unique
Check
Referential
Informational
第10题:
Ensure that the child column and the parent column have the same names.
Ensure that the child table and the parent table have the same names.
Ensure that the child column and the parent column have the same data types.
Ensure that each row in the child table has a corresponding row in the parent table.
Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.
第11题:
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.
Define the new column as NOT NULL with a default value of ’Undefined.’
Define the new column as NULL. Use application logic to enforce the data constraint.
Define the new column as NULL with a default value of ’Undefined.’
第12题:
A check constraint on the EMPLOYEE table
A unique constraint on the EMPLOYEE table WORKDEPT column
A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
第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?()
第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?()
第15题:
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?()
第16题:
Which statement describes the effect on an index, when the indexed column for the rows is updatedin the base table()
第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?()
第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? ()
第19题:
Which two statements are true regarding single row functions?()
第20题:
Check
Range
Referential
Informational
第21题:
An update in a leaf row takes place.
The index becomes invalid after the update.
The leaf block containing the row to be updated is marked as invalid.
A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
第22题:
Rows
Totals
Columns
Cells
Data
第23题:
Define the column MAINID as NOT UPDATABLE
Define the column MAINID as a PRIMARY KEY
Define the column MAINID as a FOREIGN KEY
Define an UPDATE trigger on table TABLEX
第24题:
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.
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.
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.
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.