Quick Test (Intermediate)

Welcome to your Quick Test (Intermediate)

1.

What is the main purpose of the Object Explorer in SSMS?

Deselect Answer

To monitor SQL Server performance

To design database diagrams

To browse and manage SQL Server objects

To execute SQL queries

2.

How can you create a new database in SSMS?

Deselect Answer

Right-click on the server and select “New Database”

Go to File > New > Database

Use the Import/Export Wizard

3.

Which SSMS feature allows you to import and export data?

Deselect Answer

Data Import/Export Wizard

Query Editor

Database Tuning Advisor

Object Explorer

4.

Deselect Answer

5.

In SSMS, how can you view the properties of a database?

Deselect Answer

Right-click on the database and select “Properties”

Use the Database Properties Viewer

Click on the database name

Use the Tools menu

6.

How can you back up a database in SSMS?

Deselect Answer

Right-click on the database, select Tasks > Backup

Use the Backup Database Wizard

Go to Tools > Backup

Use the Query Editor to write a BACKUP DATABASE command

7.

Which SSMS feature allows you to write and test SQL code?

Deselect Answer

Object Explorer

Query Editor

Activity Monitor

Template Explorer

8.

What is the purpose of the "Activity Monitor" in SSMS?

Deselect Answer

To manage database security

To design tables

To monitor active processes and server activity

To backup and restore databases

9.

How can you restore a database in SSMS?

Deselect Answer

Right-click on the server, select Tasks > Restore

Right-click on the database, select Tasks > Restore

Use the Database Restore Wizard

Use the Query Editor to write a RESTORE DATABASE command

10.

What is the purpose of the "Template Explorer" in SSMS?

Deselect Answer

To organize and manage SQL script templates

To create database backups

To design database diagrams

To monitor SQL Server performance

11.

How can you create a new table in a database using SSMS?

Deselect Answer

Right-click on the Tables folder and select “New Table”

Use the Query Editor to write a CREATE TABLE statement

Go to File > New > Table

Use the Table Designer

12.

Which tool in SSMS can help you analyse and optimize SQL queries?

Deselect Answer

SQL Profiler

Query Editor

Database Engine Tuning Advisor

Activity Monitor

13.

What is the purpose of the "SQL Server Agent" in SSMS?

Deselect Answer

To design and create databases

To automate administrative tasks

To monitor database performance

To manage user permissions

14.

In SSMS, how can you generate a script for an existing database object?

Deselect Answer

Right-click on the object and select “Script As”

Use the Script Generator Wizard

Use the Query Editor

Go to Tools > Generate Script

15.

What does the "IntelliSense" feature in SSMS provide?

Deselect Answer

Automatic backup and restore

Syntax highlighting and code completion

Database performance analysis

User permission management

16.

How can you schedule a regular backup of a database in SSMS?

Deselect Answer

Use the Backup Scheduler Wizard

Use the SQL Server Agent to create a backup job

Manually run backups each time

Use the Activity Monitor

17.

How can you filter the results displayed in the Object Explorer?

Deselect Answer

Use the Filter button on the Object Explorer toolbar

Go to Tools > Options > Object Explorer

Right-click on the Object Explorer and select “Filter”

Use the Query Editor to write a filter command

18.

In SSMS, how can you view the execution plan of a query?

Deselect Answer

Use the Activity Monitor

Use the Query Editor and click “Display Estimated Execution Plan”

Right-click on the query and select “View Execution Plan”

Use the Database Engine Tuning Advisor

19.

How can you export query results to a CSV file in SSMS?

Deselect Answer

Use the Export Data Wizard

Right-click on the results and select “Save Results As”

Use the Query Editor to write an export command

Go to Tools > Export Data

20.

What is the primary function of the "SQL Server Profiler" in SSMS?

Deselect Answer

To design and create tables

To capture and analyse SQL Server events

To monitor disk usage

To manage database security

Please fill in the comment box below.

Leave a Reply Cancel reply