Sql Server SSMS

Welcome to your Sql Server SSMS

Name

Email

1.

What is the primary purpose of SQL Server Management Studio (SSMS)?

Deselect Answer

To write Java applications

To manage and administer SQL Server databases

To debug Python code

To design mobile apps

2.

Which keyword is used to create a new database in SQL Server?

Deselect Answer

INSERT

CREATE DATABASE

NEW DATABASE

MAKE DATABASE

3.

Which data type should you use to store a large text value in SQL Server?

Deselect Answer

INT

VARCHAR(MAX)

FLOAT

BOOLEAN

4.

What is a Primary Key in a SQL table?

Deselect Answer

A column with duplicate values

A unique identifier for each row in a table

A foreign column in another table

A random value generator

5.

Which statement is used to remove a table from a database?

Deselect Answer

DELETE TABLE

DROP TABLE

REMOVE TABLE

ERAZE TABLE

6.

What is the purpose of a `JOIN` clause in SQL?

Deselect Answer

To combine rows from two or more tables

To update table rows

To delete specific records

To create new tables

7.

7. What is the result of using a `LEFT JOIN`?

Deselect Answer

Only matching rows from both tables

Only rows from the right table

All rows from both tables

All rows from the left table and matching rows from the right table

8.

How can you retrieve only unique values from a column?

Deselect Answer

Use the DISTINCT keyword

Use the UNIQUE keyword

Use the SELECT keyword

Use the WHERE keyword

9.

What does the `TRUNCATE TABLE` statement do?

Deselect Answer

Deletes all rows and deallocates storage for the table

Deletes all rows but keeps the table structure intact

Renames the table

Deletes a single row from the table

10.

Which function returns the current date and time in SQL Server?

Deselect Answer

NOW()

SYSDATE

CURRENT_DATE

GETDATE()

11.

What is a transaction in SQL Server?

Deselect Answer

A set of commands treated as a single unit of work

A method to import data

A query that modifies indexes

A process to back up databases

12.

How do you define a temporary table in SQL Server?

Deselect Answer

Prefix the table name with #

Use the keyword TEMP TABLE

Define the table in a temporary database

Add a temporary column

13.

What is the maximum size of a row in SQL Server?

Deselect Answer

512 KB

64 KB

8 KB

UNLIMITED

14.

Which command is used to modify an existing table structure?

Deselect Answer

UPDATE TABEL

MODIFY TABLE

ALTER TABLE

CHANGE TABLE

15.

What is the default isolation level in SQL Server?

Deselect Answer

Read Uncommitted

Repeatable Read

Read Committed

Serializable

16.

Which SQL clause is used to filter groups after aggregation?

Deselect Answer

WHERE

HAVING

GROUP BY

ORDER BY

17.

How do you restart the identity column value in SQL Server?

Deselect Answer

DROP the table

ALTER the identity column

Use the DBCC CHECKIDENT command

Use RESET IDENT

18.

What is the purpose of the `USE` command in SQL Server?

Deselect Answer

To create a database

To select a database to work with

To define a user

To enable specific SQL features

19.

What is the purpose of a clustered index?

Deselect Answer

To improve the performance of inserts

To physically sort rows in the table

To prevent duplicate values

To track table relationships

20.

Which tool in SSMS can you use to analyse query performance?

Deselect Answer

Object Explorer

Activity Monitor

Query Editor

Execution Plan

Please fill in the comment box below.

Leave a Reply Cancel reply