itgle.com

单选题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

题目
单选题
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.


相似考题
更多“单选题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题:

    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


    参考答案:A

  • 第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.

    正确答案:C

  • 第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

    正确答案:D

  • 第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.

    正确答案:B,D

  • 第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

    正确答案:B

  • 第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.

    正确答案:D

  • 第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.’

    正确答案:B

  • 第8题:

    单选题
    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.


    正确答案: A
    解析: 暂无解析

  • 第9题:

    单选题
    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()
    A

    Unique

    B

    Check

    C

    Referential

    D

    Informational


    正确答案: C
    解析: 暂无解析

  • 第10题:

    单选题
    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.


    正确答案: D
    解析: 暂无解析

  • 第11题:

    单选题
    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.’


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    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


    正确答案: C
    解析: 暂无解析

  • 第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

    正确答案:A

  • 第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

    正确答案:D

  • 第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.

    正确答案:C

  • 第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

    正确答案:D

  • 第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.

    正确答案:B

  • 第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.

    正确答案:C

  • 第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

    正确答案:D,E

  • 第20题:

    单选题
    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


    正确答案: D
    解析: 暂无解析

  • 第21题:

    单选题
    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


    正确答案: B
    解析: 暂无解析

  • 第22题:

    单选题
    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


    正确答案: B
    解析: 暂无解析

  • 第23题:

    单选题
    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


    正确答案: D
    解析: 暂无解析

  • 第24题:

    单选题
    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.


    正确答案: A
    解析: 暂无解析