What is the purpose of SQL Server Management Studio (SSMS)?
SQL Server Management Studio provides a graphical interface for managing SQL Server instances, running queries, and configuring settings.
Which language is used to interact with SQL Server databases?
Transact-SQL (T-SQL) is Microsoft's proprietary extension to SQL used to interact with SQL Server databases.
Which SQL command is used to remove a table from the database?
The DROP command permanently deletes a table and its data from the database.
What is normalization in SQL databases?
Normalization is the process of organizing data to reduce redundancy and improve data integrity.
Which system database in SQL Server stores login accounts and system configuration?
The master database is crucial as it stores system-level information such as login credentials and configurations.
What is the function of the PRIMARY KEY constraint?
A primary key uniquely identifies each record in a table and does not allow NULL values.
Loading Questions...
Which command is used to retrieve data from a SQL Server table?
The SELECT statement is used to query and retrieve data from one or more tables.
Which feature in SQL Server provides data recovery after a system failure?
SQL Server transaction logs help in restoring data and ensuring database recovery in case of a crash.
What is the purpose of the SQL Server Agent?
SQL Server Agent is a component used to schedule and automate administrative tasks like backups and jobs.