MSSQL Day-1

What is MS SQL Server?

• Operating System

• Programming Language

• Relational Database Management System

• Web Server

What is the default port number used by MS SQL Server?

• 80

• 1433

• 3306

• 1521

A ____________ is a virtual table based on the result-set of an SQL statement.

To remove a specific row based on a condition, use the ____________ statement.

Which pane in SSMS shows a hierarchical view of databases, tables, and other objects?

• Query Editor

• Object Explorer

• Solution Explorer

• Properties Window

What does the Storage Engine in SQL Server primarily manage?

• Query parsing

• Physical data storage

• Network communication

• Job scheduling

The ____________ manager caches frequently accessed data pages in memory to improve performance.

SQL Server stores transaction log information primarily to support ____________.

Which command is used to delete a database permanently?

• DELETE DATABASE

• REMOVE DATABASE

• ERASE DATABASE

• DROP DATABASE

What is a SQL Server instance?

• A backup file

• A running copy of SQL Server

• A database

• A client application