NCERT Class-5 English Marigold – Ice Cream Man

MS SQL – Basic Concepts and Installation

1 / 25

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

A. SQL Server Database Engine

B. SQL Server Analysis Services (SSAS)

C. SQL Server Integration Services (SSIS)

D. SQL Server Reporting Services (SSRS)

2 / 25

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

A. SQL Server Integration Services (SSIS)

B. SQL Server Database Engine

C. SQL Server Analysis Services (SSAS)

D. SQL Server Agent

3 / 25

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

4 / 25

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

A. To manage database backups

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

C. To browse the internet

D. To monitor server performance

5 / 25

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

A. Differential

B. Full

C. External

D. Incremental

6 / 25

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

A. Managing databases and SQL Server instances

B. Writing C# code

C. Designing web pages

D. Editing images

7 / 25

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

A. Views

B. Stored procedures

C. Triggers

D. Indexes

8 / 25

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

A. SQL Server Management Studio (SSMS)

B. SQL Server Data Tools (SSDT)

C. SQL Server Integration Services (SSIS)

D. SQL Server Configuration Manager

9 / 25

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

A. 8080

B. 1433

C. 80

D. 3306

10 / 25

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

A. Web development

B. Database management

C. Graphic design

D. Word processing

11 / 25

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

A. 4000

B. Unlimited

C. 255

D. 8000

12 / 25

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

A. Enterprise Edition

B. Express Edition

C. Developer Edition

D. Standard Edition

13 / 25

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

A. SQL Server Analysis Services (SSAS)

B. SQL Server Integration Services (SSIS)

C. Always On Availability Groups

D. SQL Server Reporting Services (SSRS)

14 / 25

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

A. Transact-SQL (T-SQL)

B. C++

C. Java

D. Python

15 / 25

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

A. DATE

B. BOOLEAN

C. INT

D. VARCHAR

16 / 25

16. 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 name and a valid credit card number

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

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

17 / 25

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

A. SQL Server Authentication

B. Mixed Mode Authentication

C. Windows Authentication

D. Integrated Security Mode

18 / 25

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

19 / 25

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

A. Querying

B. Schema design

C. Configuration

D. Deployment

20 / 25

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

A. Enterprise Edition

B. Standard Edition

C. Developer Edition

D. Express Edition

21 / 25

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

A. Integrated Security Mode

B. Mixed Mode Authentication

C. SQL Server Authentication

D. Windows Authentication

22 / 25

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

A. To enforce referential integrity

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

C. To store binary data

D. To create views

23 / 25

23. 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 Agent

D. SQL Server Browser

24 / 25

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

A. model

B. tempdb

C. master

D. msdb

25 / 25

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

A. Database

B. Index

C. Schema

D. Trigger

Your score is