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

You Might also view the following Related Posts

• Solved MCQ of SQL Server set-1
• MCQ of SQL With Answer Set -2
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of C set-1
• Solved MCQ of Data Structure Set-2  
• Solved MCQ of Data Structure Set-1
• Solved MCQ of DBMS Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8
•  

For other more Multiple Choice Questions (MCQs): Click Here