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!

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Formal Languages and Automata Theory

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

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Data Warehousing and OLAP

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

Data Structures and Algorithms

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

Systems Programming

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

Digital Image Processing (DIP)

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

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Neural Networks

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