NCERT Class-5 English Marigold – Ice Cream Man

MS SQL – Basic Concepts and Installation

1 / 25

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

A. Mixed Mode Authentication

B. Integrated Security Mode

C. Windows Authentication

D. SQL Server Authentication

2 / 25

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

A. Always On Availability Groups

B. SQL Server Analysis Services (SSAS)

C. SQL Server Integration Services (SSIS)

D. SQL Server Reporting Services (SSRS)

3 / 25

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

A. Web development

B. Graphic design

C. Word processing

D. Database management

4 / 25

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

A. SQL Server Analysis Services (SSAS)

B. SQL Server Agent

C. SQL Server Database Engine

D. SQL Server Integration Services (SSIS)

5 / 25

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

A. Express Edition

B. Developer Edition

C. Standard Edition

D. Enterprise Edition

6 / 25

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

A. Trigger

B. Database

C. Schema

D. Index

7 / 25

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

8 / 25

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

A. Developer Edition

B. Enterprise Edition

C. Express Edition

D. Standard Edition

9 / 25

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

A. Writing C# code

B. Editing images

C. Designing web pages

D. Managing databases and SQL Server instances

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. In SQL Server, what is the purpose of a stored procedure?

A. To delete databases

B. To create tables

C. To encapsulate a series of SQL statements for reuse

D. To store data records

12 / 25

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

A. SQL Server Agent

B. SQL Server Browser

C. SQL Server Database Engine

D. SQL Server Integration Services

13 / 25

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

A. Java

B. Transact-SQL (T-SQL)

C. Python

D. C++

14 / 25

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

15 / 25

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

A. VARCHAR

B. DATE

C. INT

D. BOOLEAN

16 / 25

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

A. Unlimited

B. 8000

C. 255

D. 4000

17 / 25

17. 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)

18 / 25

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

A. Views

B. Stored procedures

C. Indexes

D. Triggers

19 / 25

19. 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 monitor server performance

D. To browse the internet

20 / 25

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

A. Differential

B. Incremental

C. Full

D. External

21 / 25

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

A. msdb

B. model

C. tempdb

D. master

22 / 25

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

A. To store binary data

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

C. To enforce referential integrity

D. To create views

23 / 25

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

A. To write SQL queries

B. To design database schemas

C. To create user accounts

D. To manage server configurations like protocols and services

24 / 25

24. 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 Integration Services (SSIS)

C. SQL Server Configuration Manager

D. SQL Server Data Tools (SSDT)

25 / 25

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

A. Querying

B. Configuration

C. Deployment

D. Schema design

Your score is