Welcome to the SQL Server Basics MCQs Page

Dive deep into the fascinating world of SQL Server Basics with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of SQL Server Basics, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of SQL Server Basics, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

Check out the MCQs below to embark on an enriching journey through SQL Server Basics. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of SQL Server Basics. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

SQL Server Basics MCQs | Page 9 of 13

Explore more Topics under SQL Server

01

Data Modification and Constraints

02

Beyond Relational

03

Data Definition Language

04

Development with SQL Server

05

Data Connectivity

06

Enterprise Data Management

07

Data Security

08

Monitoring and Auditing

09

Performance Tuning and Optimization

10

Business Intelligence and Reporting Services

Q81.

Syntax for creating views is __________

CREATE VIEW AS SELECT

CREATE VIEW AS UPDATE

DROP VIEW AS SELECT

CREATE VIEW AS UPDATE

Discuss

Answer: (a).CREATE VIEW AS SELECT

Q82.

You can delete a view with ___________ command.

DROP VIEW

DELETE VIEW

REMOVE VIEW

TRUNCATE VIEW

Discuss

Answer: (a).DROP VIEW

Q83.

What is SCHEMABINDING a VIEW?

Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view

These are stored only in the Master database

These types of view are defined by users on a specified schema

These are used to show database self describing information

Discuss

Answer: (b).These are stored only in the Master database

Q84.

Which of the following is not a SQL Server INFORMATION_SCHEMA view?

INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

sys.dm_exec_connections

Discuss

Answer: (d).sys.dm_exec_connections

Q85.

___________ is stored only in the Master database.

Database-scoped Dynamic Management View

Complex View

Catalog View

None of the mentioned

Discuss

Answer: (d).None of the mentioned

Q86.

If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

Distinct

Count

Avg

Primary key

Discuss

Answer: (a).Distinct

Q87.

All aggregate functions except __________ ignore null values in their input collection.

Count(attribute)

Count(*)

Avg

Sum

Discuss

Answer: (a).Count(attribute)

Q88.

A Boolean data type that can take values true, false, and ____________

Null

Unknown

Discuss

Answer: (d).Unknown

Q89.

Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?

SELECT DISTINCT course id
FROM SECTION
WHERE semester = ’Fall’ AND YEAR= 2009 AND
course id NOT IN (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010);

SELECT DISTINCT course_id
FROM instructor
WHERE name NOT IN (’Fall’, ’Spring’);

SELECT course id
FROM SECTION
WHERE semester = 'Spring' AND YEAR= 2010);

SELECT COUNT (DISTINCT ID)
FROM takes
WHERE (course id, sec id, semester, YEAR) IN (SELECT course id, sec id, semester, YEAR
FROM teaches
WHERE teaches.ID= 10101);

Discuss

Answer: (a).SELECT DISTINCT course id
FROM SECTION
WHERE semester = ’Fall’ AND YEAR= 2009 AND
course id NOT IN (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010);

Q90.

The phrase “greater than at least one” is represented in SQL by ___________

< all

< some

> all

> some

Discuss

Answer: (d).> some

Page 9 of 13

Welcome to the SQL Server Basics MCQs Page

SQL Server Basics MCQs | Page 9 of 13

Explore more Topics under SQL Server

Data Modification and Constraints

Beyond Relational

Data Definition Language

Development with SQL Server

Data Connectivity

Enterprise Data Management

Data Security

Monitoring and Auditing

Performance Tuning and Optimization

Business Intelligence and Reporting Services

Suggested Topics

Computer Architecture

Computer Hardware

CSS

Object Oriented Programming

C# programming

Python

MySQL Database

UNIX

Microprocessor