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 6 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

Q51.

___________removes all rows from a table without logging the individual row deletions.

DELETE

REMOVE

DROP

TRUNCATE

Discuss

Answer: (d).TRUNCATE

Q52.

Which of the following is not a DDL command?

UPDATE

TRUNCATE

ALTER

None of the Mentioned

Discuss

Answer: (a).UPDATE

Q53.

Which of the following are TCL commands?

UPDATE and TRUNCATE

SELECT and INSERT

GRANT and REVOKE

ROLLBACK and SAVEPOINT

Discuss

Answer: (d).ROLLBACK and SAVEPOINT

Q54.

________________ is not a category of SQL command.

TCL

SCL

DCL

DDL

Discuss

Answer: (b).SCL

Q55.

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

ASC

DESC

There is no default value

None of the mentioned

Discuss

Answer: (a).ASC

Q56.

What is the purpose of the SQL AS clause?

The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

All of the mentioned

Discuss

Answer: (a).The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

Q57.

What does DML stand for?

Different Mode Level

Data Model Language

Data Mode Lane

Data Manipulation language

Discuss

Answer: (d).Data Manipulation language

Q58.

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

Discuss

Answer: (c).SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

Q59.

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT ‘FirstName’ DESC

SELECT * FROM Persons ORDER BY FirstName DESC

Discuss

Answer: (d).SELECT * FROM Persons ORDER BY FirstName DESC

Q60.

With SQL, how can you return the number of not null records in the “Persons” table?

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

Discuss

Answer: (a).SELECT COUNT() FROM Persons

Page 6 of 13

Welcome to the SQL Server Basics MCQs Page

SQL Server Basics MCQs | Page 6 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

Data Science

JavaScript

DBMS

Hadoop

C Programming

Python

HTML

MySQL Database

Management Information Systems