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

Q31.

Exact Numeric data type is ___________

bigint

int

smallmoney

all of the mentioned

Discuss

Answer: (d).all of the mentioned

Q32.

ntext data type falls under which category?

Exact numerics

Character strings

Unicode character strings

None of the mentioned

Discuss

Answer: (c).Unicode character strings

Q33.

A column of type __________ may contain rows of different data types.

ntext

date

smallmoney

sql_variant

Discuss

Answer: (d).sql_variant

Q34.

You want to track date and time of the last write access per row. Select the suitable option among the below.

Add TIMESTAMP column to the table

Add a DATETIME column to the table and assign getdate() as the default value

Add a DATETIME column to the table and write a trigger that sets its value

Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

Discuss

Answer: (a).Add TIMESTAMP column to the table

Q35.

________ is a spatial data type.

geometry

sql_variant

cursor

all of the mentioned

Discuss

Answer: (b).sql_variant

Q36.

Which of the following data type is not present in SQL Server?

bit

boolean

hierarchyid

geography

Discuss

Answer: (b).boolean

Q37.

______________ is monetary data type in SQL Server.

Smallmoney

sql_variant

Cursor

None of the Mentioned

Discuss

Answer: (a).Smallmoney

Q38.

Which of the data type has a storage size of 8 bytes?

timestamp

uniqueidentifier

real

smallmoney

Discuss

Answer: (a).timestamp

Q39.

______________ function returns current date and time.

SET DATEFIRST

SYSDATETIME

Cert_ID

GETDATE

Discuss

Answer: (d).GETDATE

Q40.

Which of the following function checks whether the expression is a valid date or not?

ISDATE

ISDAY

ISVALID

ISYEAR

Discuss

Answer: (a).ISDATE

Page 4 of 13

Welcome to the SQL Server Basics MCQs Page

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

DBMS

Cyber Security

Internet of Things (IoT)

Management Information Systems

Java Programming

Discrete Mathematics

Neural Networks

Software Engineering

HTML