NCERT Class-5 English Marigold – Ice Cream Man

MS SQL – Basic Concepts and Installation

1 / 25

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

A. To design database schemas

B. To write SQL queries

C. To manage server configurations like protocols and services

D. To create user accounts

2 / 25

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

A. SQL Server Integration Services (SSIS)

B. SQL Server Configuration Manager

C. SQL Server Management Studio (SSMS)

D. SQL Server Data Tools (SSDT)

3 / 25

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

A. VARCHAR

B. DATE

C. INT

D. BOOLEAN

4 / 25

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

A. master

B. msdb

C. tempdb

D. model

5 / 25

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

A. SQL Server Integration Services (SSIS)

B. SQL Server Analysis Services (SSAS)

C. SQL Server Reporting Services (SSRS)

D. SQL Server Database Engine

6 / 25

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

A. SQL Server Reporting Services (SSRS)

B. Always On Availability Groups

C. SQL Server Analysis Services (SSAS)

D. SQL Server Integration Services (SSIS)

7 / 25

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

A. To store data records

B. To delete databases

C. To create tables

D. To encapsulate a series of SQL statements for reuse

8 / 25

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

A. SQL Server Authentication

B. Windows Authentication

C. Integrated Security Mode

D. Mixed Mode Authentication

9 / 25

9. 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

10 / 25

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

A. 80

B. 8080

C. 3306

D. 1433

11 / 25

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

A. Unlimited

B. 255

C. 8000

D. 4000

12 / 25

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

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

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

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

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

13 / 25

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

A. Web development

B. Database management

C. Word processing

D. Graphic design

14 / 25

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

A. Enterprise Edition

B. Developer Edition

C. Express Edition

D. Standard Edition

15 / 25

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

A. Indexes

B. Triggers

C. Stored procedures

D. Views

16 / 25

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

A. SQL Server Integration Services

B. SQL Server Browser

C. SQL Server Database Engine

D. SQL Server Agent

17 / 25

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

A. Writing C# code

B. Designing web pages

C. Editing images

D. Managing databases and SQL Server instances

18 / 25

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

A. To monitor server performance

B. To manage database backups

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

D. To browse the internet

19 / 25

19. 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 enforce referential integrity

D. To create views

20 / 25

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

A. Querying

B. Deployment

C. Schema design

D. Configuration

21 / 25

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

A. C++

B. Python

C. Java

D. Transact-SQL (T-SQL)

22 / 25

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

A. Database

B. Trigger

C. Index

D. Schema

23 / 25

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

A. Standard Edition

B. Enterprise Edition

C. Developer Edition

D. Express Edition

24 / 25

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

A. Differential

B. Full

C. External

D. Incremental

25 / 25

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

A. SQL Server Agent

B. SQL Server Analysis Services (SSAS)

C. SQL Server Database Engine

D. SQL Server Integration Services (SSIS)

Your score is