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 7 of 13

Explore more Topics under SQL Server

Q61.
What does the ALTER TABLE clause do?

a.

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

b.

The SQL ALTER TABLE clause is used to insert data into database table

c.

THE SQL ALTER TABLE deletes data from database table

d.

The SQL ALTER TABLE clause is used to delete a database table

Discuss
Answer: (a).The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
Q62.
The UPDATE SQL clause can _____________

a.

update only one row at a time

b.

update more than one row at a time

c.

delete more than one row at a time

d.

delete only one row at a time

Discuss
Answer: (b).update more than one row at a time
Q63.
The UNION SQL clause can be used with _____________

a.

SELECT clause only

b.

DELETE and UPDATE clauses

c.

UPDATE clause only

d.

All of the mentioned

Discuss
Answer: (a).SELECT clause only
Q64.
Which SQL statement is used to return only different values?

a.

SELECT DIFFERENT

b.

SELECT UNIQUE

c.

SELECT DISTINCT

d.

SELECT ALL

Discuss
Answer: (c).SELECT DISTINCT
Q65.
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

a.

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

b.

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

c.

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

d.

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Discuss
Answer: (d).UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Q66.
Which TCL command undo all the updates performed by the SQL in the transaction?

a.

ROLLBACK

b.

COMMIT

c.

TRUNCATE

d.

DELETE

Discuss
Answer: (b).COMMIT
Q67.
SQL query to find all the cities whose humidity is 95.

a.

SELECT city WHERE humidity = 95

b.

SELECT city FROM weather WHERE humidity = 95

c.

SELECT humidity = 89 FROM weather

d.

SELECT city FROM weather

Discuss
Answer: (b).SELECT city FROM weather WHERE humidity = 95
Q68.
SQL query to find the temperature in increasing order of all cities.

a.

SELECT city FROM weather ORDER BY temperature

b.

SELECT city, temperature FROM weather

c.

SELECT city, temperature FROM weather ORDER BY temperature

d.

SELECT city, temperature FROM weather ORDER BY city

Discuss
Answer: (d).SELECT city, temperature FROM weather ORDER BY city
Q69.
What is the meaning of LIKE ‘%0%0%’?

a.

Feature begins with two 0’s

b.

Feature ends with two 0’s

c.

Feature has more than two 0’s

d.

Feature has two 0’s in it, at any position

Discuss
Answer: (d).Feature has two 0’s in it, at any position
Q70.
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

a.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

b.

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

c.

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

d.

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

Discuss
Answer: (a).SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
Page 7 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!

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Software Engineering

Learn about the systematic approach to developing software with our Software...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....