Correct Answer: PRIMARY KEY and UNIQUE constraints
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Microsoft SQL Server MCQ Questions
The AND operator displays a row if ANY conditions listed are true. The OR operator displays a row if ALL of the conditions listed are true
What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?
Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?
What is the default maximum precision of decimal data type in SQL Server 2008?
Each table in SQL Server 2008 can have up to ______ nonclustered indexes.
Examine the description of the STUDENTS table: STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATETIME END_DATE DATETIME The aggregate functions valid on the START_DATE column are:
Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?
Consider the transaction: Begin Transaction Create table A ( x smallint , y smallint ) Create table B ( p smallint , q smallint ) Update A set x=600 where y > 700 Update B set p=78 where q=99 If @@ error != 0 Begin RollBack Transaction Return End Commit Transaction Select the correct option:
What does BLOB stand for?
Which of the following statements is not true about the table object in SQL Server?