View Count: 0
Duration: 65 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 15
Which of the following is not a class of constraint in SQL Server ? 
Options:
  1. NOT NULL
  2. CHECK
  3. NULL
  4. UNIQUE
View Answer/Explanation:
c
Explanation:

Question No: 2 of 15
Constraints can be applied on : 
Options:
  1. Column
  2. Table
  3. Field
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:
Constraints can be column constraints or table constraints.

Question No: 3 of 15
How many types of constraints are present in SQL Server ? 
Options:
  1. 4
  2. 5
  3. 6
  4. 7
View Answer/Explanation:
c
Explanation:
Constraints are Primary key, Foreign Key, Unique Key, Not Null, Check

Question No: 4 of 15
What is true about Unique and primary key? 
Options:
  1. Unique can have multiple NULL values but Primary can’t have.
  2. Unique can have single NULL value but Primary can’t have even single.
  3. Both can have duplicate values
  4. None of the Mentioned
View Answer/Explanation:
b
Explanation:
primary key doesn’t allow Null values and Unique key allows Null value, but only one Null value.

Question No: 5 of 15
Which key accepts multiple NULL values? 
Options:
  1. Foreign Key
  2. Unique Key
  3. Primary Key
  4. None of the Mentioned
View Answer/Explanation:
a
Explanation:
A foreign key is a key used to link two tables together. This is sometimes called a referencing key.Foreign Key is a column or a combination of columns whose values match a Primary Key in a different table.

Question No: 6 of 15
Point out the correct statement : 
Options:
  1. CHECK constraints enforce domain integrity
  2. UNIQUE constraints enforce the uniqueness of the values in a set of columns
  3. In a UNIQUE constraint, no two rows in the table can have the same value for the columns
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:
Constraints let you define the way the Database Engine automatically enforces the integrity of a database.

Question No: 7 of 15
How to add a Constraint: 
Options:
  1. ALTER TABLE ADD CONSTRAINT Constraint (column name)
  2. ADD TABLE
  3. ADD CONSTRAINT Constaint (column name)
  4. ALTER TABLE
  5. ADD CONSTRAINT
  6. All the above
  7. View Answer/Explanation:
    a
    Explanation:

    Question No: 8 of 15
    Which key columns of the child table is always linked to either primary key or unique column of the parent table It can be used only when   1. The referenced table has a unique or primary key constraint defined on the appropriate column 2. Data types of the referencing table columns exactly match the data types of the referenced table 
    Options:
    1. Primary Key
    2. Default
    3. Check
    4. Foreign Key
    View Answer/Explanation:
    d
    Explanation:

    Question No: 9 of 15
    Which of the following code applies not null constraint on the fname column of the employees table 
    Options:
    1. Create table employees (eid int, Fname varchar 20 notnull)
    2. Create table employees (eid int, Fname varchar 20 not null)
    3. Create table employees (eid int, Fname varchar 20 foreign key)
    4. All the above
    View Answer/Explanation:
    b
    Explanation:

    Question No: 10 of 15
    Is it possible to insert null values in the foreign key  constraint column 
    Options:
    1. yes
    2. No
    View Answer/Explanation:
    a
    Explanation:

      1