Solved MCQ of SQL Server Set-2

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

Get 1000's of DBMS MCQs as pdf E-Book on Free Download Now