Microsoft SQL Server Database Quiz Questions

T-SQL, or Transact-SQL, is an extension of SQL used by Microsoft SQL Server.

SQL Server can be installed on both Windows and Linux operating systems.

A primary key can be composed of multiple columns, known as a composite key.

SSMS is an integrated environment for managing any SQL infrastructure.

A database can have multiple schemas to logically group database objects.

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, called jobs.

A view is a virtual table that consists of a subset of data contained in a table.

Always On is a suite of high availability and disaster recovery solutions in SQL Server.

A clustered index defines the physical order of data in a table, improving the performance of queries.

Foreign key constraints enforce referential integrity between tables in SQL Server.

Database mirroring is deprecated in newer versions of SQL Server, with Always On being the recommended replacement.

FILESTREAM allows SQL Server-based applications to store unstructured data such as documents and images on the file system.

MDS enables organizations to manage master data and maintain consistent data across the enterprise.

Replication is a set of technologies for copying and distributing data and database objects from one database to another.

Log Shipping is a high availability and disaster recovery solution that involves automating the backup and restore process of transaction logs.

T-SQL is the primary language used to interact with Microsoft SQL Server.

SQL Server Management Studio (SSMS) is the primary tool for managing SQL Server databases.

A primary key is used to uniquely identify each record in a SQL Server table.

The FILESTREAM feature in SQL Server allows storing and managing unstructured data such as documents and images.

SQL Server Agent is used for automating administrative tasks and managing jobs.

Always On Availability Groups provide high availability and disaster recovery solutions in SQL Server.

A clustered index determines the physical order of data in a table, improving the performance of queries.

Replication in SQL Server allows maintaining consistent data across multiple databases.

SQL Server Analysis Services (SSAS) provides a platform for data mining and Online Analytical Processing (OLAP).

A foreign key in SQL Server is used to enforce referential integrity between two tables.

SQL Server Integration Services (SSIS) is used for Extraction, Transformation, and Loading (ETL) processes.

SQL Server Analysis Services (SSAS) supports real-time analytics through OLAP and data mining.

SQL Server Reporting Services (SSRS) is used to generate and manage reports.

Master Data Services (MDS) provides a central repository for managing and maintaining master data.

SQL Server provides built-in features for backup and restore operations to ensure data protection.

Always On Availability Groups, Database Mirroring, and Log Shipping are high availability features in SQL Server.

The SQL Server BI stack includes SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services).

Clustered, Non-Clustered, and Full-Text are types of indexes available in SQL Server.

SQL Profiler and Performance Monitor are tools used for performance monitoring in SQL Server.

SSIS provides ETL capabilities, data warehousing, and data migration solutions.

SSAS provides OLAP and data mining features.

Primary keys, foreign keys, and check constraints are used to enforce data integrity in SQL Server.

SSIS, SSAS, and SSRS are components used for business intelligence in SQL Server.

SSRS provides tools for report creation, management, and delivery.

SQL Server provides features such as encryption, authentication, and authorization for security.

Always On Availability Groups, Database Mirroring, and Log Shipping support disaster recovery in SQL Server.

Full, differential, and transaction log backups are available in SQL Server.

Indexes, query optimization, and partitioning are features used for performance optimization in SQL Server.

SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are used for database development.

SSIS, SSAS, and partitioning support data warehousing in SQL Server.