What is SQL Server primarily used for?

• Web development
• Graphic design
• Database management
• Operating system management

Which tool is commonly used to interact with SQL Server?

• Visual Studio Code
• SSMS
• Eclipse
• Notepad++

What does SQL stand for?

• Simple Query Language
• Structured Query Language
• Server Query Language
• Sequential Query Language

What command is used to retrieve data from a table?

• GET
• EXTRACT
• SELECT
• SHOW

Which data type is used to store textual data in SQL Server?

• INT
• VARCHAR
• BIT
• FLOAT

Which JOIN returns all matching rows from both tables?

• LEFT JOIN
• INNER JOIN
• FULL OUTER JOIN
• RIGHT JOIN

What is a view in SQL Server?

• A type of schema
• A virtual table based on a query
• A backup of a table
• A GUI for tables

What does a clustered index determine?

• Backup frequency
• Table structure
• Physical order of data in a table
• Security settings

Which command is used to modify a stored procedure?

• ALTER PROCEDURE
• UPDATE PROCEDURE
• CHANGE PROCEDURE
• MODIFY PROCEDURE

What is a CTE (Common Table Expression) used for?

• Indexing
• Recursion and temporary result sets
• Permission control
• Backup

What is the purpose of the SQL Server Buffer Pool?

• To store backups
• To improve query compilation
• To cache data pages in memory
• To manage temp tables

What does the Dynamic Management View (DMV) help with?

• Generating reports
• Query optimization and server diagnostics
• Creating stored procedures
• Encrypting data

Which of the following is NOT a high availability option in SQL Server?

• Log Shipping
• Mirroring
• Always On
• Partitioning

What is the maximum number of indexes a SQL Server table can have?

• 250
• 999
• 1000
• 1024

What does SQL Server Profiler do?

• Monitors server temperature
• Profiles user permissions
• Captures and analyzes SQL Server events
• Runs ETL jobs