MCQs on Introduction to SQL Server | SQL Server
SQL Server is a powerful relational database management system (RDBMS) designed for data storage, retrieval, and analytics. These 30 MCQs cover foundational topics like installation, editions, and management tools.
MCQs on SQL Server Topics
Overview of RDBMS
- What does RDBMS stand for?
- A) Relational Database Management System
- B) Random Database Management System
- C) Recursive Data Model System
- D) Redundant Data Mapping System
- Which is a core feature of an RDBMS?
- A) Object storage
- B) Relationships between tables
- C) Unstructured data handling
- D) Blockchain integration
- Which of the following best describes a table in SQL Server?
- A) A collection of documents
- B) A two-dimensional structure of rows and columns
- C) A key-value pair storage
- D) A blob storage system
- Primary keys in RDBMS are used to:
- A) Ensure that each row in a table is unique
- B) Connect multiple databases
- C) Perform data backups
- D) Encrypt data
- Which of the following is an example of an RDBMS?
- A) MongoDB
- B) SQL Server
- C) Redis
- D) Cassandra
Installation and Configuration of SQL Server
- During SQL Server installation, which account is used to run SQL Server services?
- A) System Administrator (sa)
- B) Service Account
- C) Guest Account
- D) Administrator Account
- Which component is mandatory to install SQL Server?
- A) Internet connection
- B) SQL Server Database Engine
- C) Analysis Services
- D) Integration Services
- What tool is used to configure SQL Server post-installation?
- A) SQL Server Management Studio
- B) SQL Server Configuration Manager
- C) SQL Profiler
- D) Visual Studio
- Which of these is NOT an installation option for SQL Server?
- A) Basic
- B) Custom
- C) Express
- D) Standalone Database Deployment
- To enable remote connections in SQL Server, what configuration is necessary?
- A) Allow port 1433 in the firewall
- B) Modify the Windows hosts file
- C) Install a third-party connection tool
- D) Configure database mirroring
SQL Server Editions and Components
- Which SQL Server edition is free for development purposes?
- A) Enterprise
- B) Developer
- C) Standard
- D) Express
- The main difference between SQL Server Standard and Enterprise editions is:
- A) Licensing model
- B) Scalability and advanced features
- C) Compatibility with older operating systems
- D) User interface design
- Which component of SQL Server is used for in-depth analytics and reporting?
- A) Integration Services
- B) Analysis Services
- C) Reporting Services
- D) Database Engine
- SQL Server Express is best suited for:
- A) High-transaction enterprise systems
- B) Small-scale applications or learning purposes
- C) Cloud-only deployments
- D) Distributed database systems
- What is the maximum database size supported by SQL Server Express?
- A) 4 GB
- B) 10 GB
- C) 50 GB
- D) 1 TB
SQL Server Management Studio (SSMS) Overview
- What is SQL Server Management Studio (SSMS)?
- A) A development tool for .NET applications
- B) A GUI for managing and querying SQL Server databases
- C) A tool for configuring Windows Server
- D) A cloud management platform
- Which feature in SSMS allows querying databases?
- A) Object Explorer
- B) Query Editor
- C) Activity Monitor
- D) Job Scheduler
- SSMS is primarily used to:
- A) Monitor network traffic
- B) Manage, configure, and query SQL Server instances
- C) Perform code debugging
- D) Automate report generation
- What is the default file extension for a query file in SSMS?
- A) .txt
- B) .sql
- C) .xml
- D) .dat
- To view running processes in SQL Server, which SSMS feature is used?
- A) Query Editor
- B) Activity Monitor
- C) Object Explorer
- D) SQL Profiler
General Concepts
- Which SQL command is used to create a new table?
- A) CREATE
- B) INSERT
- C) SELECT
- D) ALTER
- In SQL Server, which key enforces the uniqueness of values in a column?
- A) Foreign Key
- B) Unique Key
- C) Index Key
- D) Constraint Key
- Which of the following is a feature of SQL Server?
- A) Data compression
- B) NoSQL database integration
- C) Blockchain ledger management
- D) Manual data recovery
- What is the role of a foreign key in a database?
- A) Ensure data encryption
- B) Enforce referential integrity between tables
- C) Enhance data retrieval speed
- D) Allow bulk data imports
- SQL Server Agent is used for:
- A) Automating administrative tasks and jobs
- B) Monitoring real-time network traffic
- C) Debugging stored procedures
- D) Setting up database mirroring
- Which SQL Server tool helps in performance tuning?
- A) SQL Profiler
- B) Object Explorer
- C) Query Editor
- D) Integration Services
- What does the “master” database in SQL Server contain?
- A) User data
- B) Metadata about all other databases
- C) Temporary tables
- D) Archived data
- What is the purpose of the “tempdb” database?
- A) Backup storage
- B) Storing temporary data and intermediate results
- C) Archiving user logs
- D) Creating permanent tables
- Which file extension is used for SQL Server database files?
- A) .mdf
- B) .db
- C) .dat
- D) .sql
- SQL Server supports which language for writing stored procedures?
- A) T-SQL
- B) Python
- C) JavaScript
- D) C++
Answers Table
| Qno | Answer |
|---|---|
| 1 | A) Relational Database Management System |
| 2 | B) Relationships between tables |
| 3 | B) A two-dimensional structure of rows and columns |
| 4 | A) Ensure that each row in a table is unique |
| 5 | B) SQL Server |
| 6 | B) Service Account |
| 7 | B) SQL Server Database Engine |
| 8 | B) SQL Server Configuration Manager |
| 9 | D) Standalone Database Deployment |
| 10 | A) Allow port 1433 in the firewall |
| 11 | B) Developer |
| 12 | B) Scalability and advanced features |
| 13 | B) Analysis Services |
| 14 | B) Small-scale applications or learning purposes |
| 15 | B) 10 GB |
| 16 | B) A GUI for managing and querying SQL Server databases |
| 17 | B) Query Editor |
| 18 | B) Manage, configure, and query SQL Server instances |
| 19 | B) .sql |
| 20 | B) Activity Monitor |
| 21 | A) CREATE |
| 22 | B) Unique Key |
| 23 | A) Data compression |
| 24 | B) Enforce referential integrity between tables |
| 25 | A) Automating administrative tasks and jobs |
| 26 | A) SQL Profiler |
| 27 | B) Metadata about all other databases |
| 28 | B) Storing temporary data and intermediate results |
| 29 | A) .mdf |
| 30 | A) T-SQL |