NCERT Class-5 English Marigold – Ice Cream Man

MS SQL – Basic Concepts and Installation

1 / 25

1. What is the maximum number of characters that can be stored in a VARCHAR(MAX) column in SQL Server?

A. 255

B. Unlimited

C. 8000

D. 4000

2 / 25

2. What is the purpose of the SQL Server Browser service?

A. To browse the internet

B. To manage database backups

C. To monitor server performance

D. To help clients locate and connect to SQL Server instances

3 / 25

3. Which system database stores system metadata and information about database objects in SQL Server?

A. model

B. tempdb

C. msdb

D. master

4 / 25

4. Which of the following is NOT a valid data type in SQL Server?

A. VARCHAR

B. BOOLEAN

C. INT

D. DATE

5 / 25

5. What is the default port number for SQL Server when connecting over TCP/IP?

A. 1433

B. 3306

C. 80

D. 8080

6 / 25

6. Which SQL Server component helps developers design, develop, and manage business intelligence solutions?

A. SQL Server Integration Services (SSIS)

B. SQL Server Database Engine

C. SQL Server Reporting Services (SSRS)

D. SQL Server Analysis Services (SSAS)

7 / 25

7. In SQL Server, a collection of tables, views, and procedures is known as:

A. Schema

B. Trigger

C. Index

D. Database

8 / 25

8. What is the primary purpose of Microsoft SQL Server?

A. Database management

B. Web development

C. Graphic design

D. Word processing

9 / 25

9. Which SQL Server service is responsible for managing scheduled tasks and jobs?

A. SQL Server Agent

B. SQL Server Integration Services (SSIS)

C. SQL Server Analysis Services (SSAS)

D. SQL Server Database Engine

10 / 25

10. Which SQL Server edition is designed for mission-critical applications and high availability?

A. Enterprise Edition

B. Developer Edition

C. Standard Edition

D. Express Edition

11 / 25

11. The process of installing SQL Server on a computer is known as:

A. Configuration

B. Deployment

C. Schema design

D. Querying

12 / 25

12. What is the purpose of an index in SQL Server?

A. To optimize data retrieval by providing a fast lookup mechanism

B. To store binary data

C. To create views

D. To enforce referential integrity

13 / 25

13. Which SQL Server feature ensures data consistency and integrity during hardware failures?

A. SQL Server Reporting Services (SSRS)

B. SQL Server Integration Services (SSIS)

C. Always On Availability Groups

D. SQL Server Analysis Services (SSAS)

14 / 25

14. Which of the following is NOT a SQL Server data backup type?

A. Differential

B. External

C. Full

D. Incremental

15 / 25

15. To connect to a SQL Server instance, what information is typically required?

A. Server's name and a list of available databases

B. Server's IP address and a valid email address

C. Server's name and a valid credit card number

D. Server's name or IP address and valid authentication credentials

16 / 25

16. What is the purpose of the SQL Server Configuration Manager?

A. To manage server configurations like protocols and services

B. To create user accounts

C. To design database schemas

D. To write SQL queries

17 / 25

17. Which authentication mode in SQL Server allows both Windows and SQL Server logins?

A. SQL Server Authentication

B. Integrated Security Mode

C. Windows Authentication

D. Mixed Mode Authentication

18 / 25

18. In SQL Server, what is the purpose of a stored procedure?

A. To create tables

B. To encapsulate a series of SQL statements for reuse

C. To delete databases

D. To store data records

19 / 25

19. SQL Server uses a query language to interact with databases called:

A. Transact-SQL (T-SQL)

B. C++

C. Java

D. Python

20 / 25

20. Which of the following is NOT a SQL Server authentication mode?

A. Mixed Mode Authentication

B. SQL Server Authentication

C. Windows Authentication

D. Integrated Security Mode

21 / 25

21. Which SQL Server tool is used to import, export, and transform data between different data sources?

A. SQL Server Data Tools (SSDT)

B. SQL Server Integration Services (SSIS)

C. SQL Server Management Studio (SSMS)

D. SQL Server Configuration Manager

22 / 25

22. SQL Server Management Studio (SSMS) is used for:

A. Editing images

B. Managing databases and SQL Server instances

C. Writing C# code

D. Designing web pages

23 / 25

23. Which SQL Server edition is free and suitable for lightweight applications and learning purposes?

A. Developer Edition

B. Express Edition

C. Enterprise Edition

D. Standard Edition

24 / 25

24. Which SQL Server feature allows you to track changes made to database tables?

A. Indexes

B. Stored procedures

C. Views

D. Triggers

25 / 25

25. The component of SQL Server responsible for storing and managing data is called:

A. SQL Server Database Engine

B. SQL Server Integration Services

C. SQL Server Browser

D. SQL Server Agent

Your score is