1. ……………………. are predefined and maintained SQL Server and users cannot assign or directly change the values.
A) Global variables
B) Local Variables
C) Integer Variables
D) Floating Variables
2. A local variable is shown ……………………… preceding its name.
A) One @ symbol
B) Two @@ symbol
C) One # symbol
D) Two ## symbol
3. Constraint checking can be disabled on existing ……….. and …………. constraints so that any data you modify or add to the table is not checked against the constraint.
A) CHECK, FOREIGN KEY
B) DELETE, FOREIGN KEY
C) CHECK, PRIMARY KEY
D) PRIMARY KEY, FOREIGN KEY
4. ……………. and ………………. are the Transact – SQL control-of-flow key words.
A) Continue, Stop
B) Break, Stop
C) Continue, While
D) While, Going to
5. The type of constraint …………………… specifies data values that are acceptable in a column.
A) DEFAULT
B) CHECK
C) PRIMARY
D) UNIQUE
6. The ………………… constraint defines a column or combination of columns whose values match the primary key of the same or another table.
A) DEFAULT
B) CHECK
C) PRIMARY
D) FOREIGN KEY
7. The control-of-flow statement ………………… defines conditional, and optionally, alternate execution when a condition is FALSE.
A) WHILE
B) WAITFOR
C) IF……..ELSE
D) BEGIN………. END
8. In SQL Server, ………………… is based on relationships between foreign keys and primary keys or between foreign keys and unique keys.
A) Entity integrity
B) Domain integrity
C) Referential integrity
D) User-defined integrity
9. When a …………….. clause is used, each item in the select list must produce a single value for each group.
A) ORDER BY
B) GROUP
C) GROUP BY
D) GROUP IN
10. MS SQL Server uses a variant of SQL called T-SQL, or Transact SQL, an implementation of ……………… with some extensions.
A) MS SQL Server
B) Tabular Data Set
C) SQL-92
D) Tabular Data Stream
Answers:
1. A) Global variables
2. A) One @ symbol
3. A) CHECK, FOREIGN KEY
4. C) Continue, While
5. B) CHECK
6. D) FOREIGN KEY
7. C) IF……..ELSE
8. C) Referential integrity
9. C) GROUP BY
10.C) SQL-92
Read Next: Solved MCQ of PL/SQL and Oracle set-1
Read More: Collections of DBMS MCQ questions
Download: Free PDF E-book of DBMS MCQ questions
Comments are closed.