CS/IT MCQ Collections

Solved MCQ of SQL Server Set-2

Pinterest LinkedIn Tumblr

Here are the collections of solved multiple choice questions on SQL server about the fundamental of SQL server and the basic commands used on SQL server.

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

Author

Shuseel Baral is a web programmer and the founder of InfoTechSite has over 8 years of experience in software development, internet, SEO, blogging and marketing digital products and services is passionate about exceeding your expectations.

Comments are closed.