adplus-dvertising

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.

frame-decoration

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

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

a.

DELETE

b.

REMOVE

c.

DROP

d.

TRUNCATE

Discuss
Answer: (d).TRUNCATE
Q52.
Which of the following is not a DDL command?

a.

UPDATE

b.

TRUNCATE

c.

ALTER

d.

None of the Mentioned

Discuss
Answer: (a).UPDATE
Q53.
Which of the following are TCL commands?

a.

UPDATE and TRUNCATE

b.

SELECT and INSERT

c.

GRANT and REVOKE

d.

ROLLBACK and SAVEPOINT

Discuss
Answer: (d).ROLLBACK and SAVEPOINT
Q54.
________________ is not a category of SQL command.

a.

TCL

b.

SCL

c.

DCL

d.

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 ______________

a.

ASC

b.

DESC

c.

There is no default value

d.

None of the mentioned

Discuss
Answer: (a).ASC
Q56.
What is the purpose of the SQL AS clause?

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

b.

The AS clause is used with the JOIN clause only

c.

The AS clause defines a search condition

d.

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?

a.

Different Mode Level

b.

Data Model Language

c.

Data Mode Lane

d.

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”?

a.

SELECT * FROM Persons WHERE FirstName=’a’

b.

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

c.

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

d.

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”?

a.

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

b.

SELECT * FROM Persons ORDER FirstName DESC

c.

SELECT * FROM Persons SORT ‘FirstName’ DESC

d.

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?

a.

SELECT COUNT() FROM Persons

b.

SELECT COLUMNS() FROM Persons

c.

SELECT COLUMNS(*) FROM Persons

d.

SELECT COUNT(*) FROM Persons

Discuss
Answer: (a).SELECT COUNT() FROM Persons
Page 6 of 13

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Compiler Design

Unravel the process of translating source code into executable programs with our...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...