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

Explore more Topics under SQL Server

Q71.
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

a.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

b.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

c.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

d.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

Discuss
Answer: (c).SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
Q72.
Find all the tuples having a temperature greater than ‘Paris’.

a.

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

b.

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)

c.

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)

d.

SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

Discuss
Answer: (a).SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
Q73.
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

a.

SELECT * FROM weather WHERE humidity IN (63 to 79)

b.

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

c.

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

d.

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Discuss
Answer: (c).SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
Q74.
The command to remove rows from a table ‘CUSTOMER’ is __________________

a.

DROP FROM CUSTOMER

b.

UPDATE FROM CUSTOMER

c.

REMOVE FROM CUSTOMER

d.

DELETE FROM CUSTOMER WHERE

Discuss
Answer: (d).DELETE FROM CUSTOMER WHERE
Q75.
The following SQL is which type of join: 
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

a.

Equi-join

b.

Natural join

c.

Outer join

d.

Cartesian join

Discuss
Answer: (a).Equi-join
Q76.
The following SQL is which type of join: 
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T

a.

Equi-join

b.

Natural join

c.

Outer join

d.

Cartesian join

Discuss
Answer: (d).Cartesian join
Q77.
Which is not a type of join in T-SQL?

a.

Equi-join

b.

Natural join

c.

Outer join

d.

Cartesian join

Discuss
Answer: (b).Natural join
Q78.
Which of the following is not a limitation of view?

a.

ORDER BY Does Not Work

b.

Index Created on View Used Often

c.

Cross Database Queries Not Allowed in Indexed View

d.

Adding Column is Expensive by Joining Table Outside View

Discuss
Answer: (b).Index Created on View Used Often
Q79.
SQL Server has mainly how many types of views?

a.

one

b.

two

c.

three

d.

four

Discuss
Answer: (b).two
Q80.
Dynamic Management View is a type of ___________

a.

System Defined Views

b.

User Defined View

c.

Simple View

d.

Complex View

Discuss
Answer: (a).System Defined Views
Page 8 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!

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Neural Networks

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

Human Computer Interaction

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

Compiler Design

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

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...