NCERT Class-5 English Marigold – Ice Cream Man

MS SQL – Basic Concepts and Installation

1 / 25

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

A. Web development

B. Graphic design

C. Word processing

D. Database management

2 / 25

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

A. SQL Server Database Engine

B. SQL Server Agent

C. SQL Server Integration Services

D. SQL Server Browser

3 / 25

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

A. 80

B. 8080

C. 1433

D. 3306

4 / 25

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

A. Windows Authentication

B. Mixed Mode Authentication

C. SQL Server Authentication

D. Integrated Security Mode

5 / 25

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

A. SQL Server Analysis Services (SSAS)

B. SQL Server Integration Services (SSIS)

C. SQL Server Agent

D. SQL Server Database Engine

6 / 25

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

A. Standard Edition

B. Developer Edition

C. Enterprise Edition

D. Express Edition

7 / 25

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

A. Enterprise Edition

B. Standard Edition

C. Developer Edition

D. Express Edition

8 / 25

8. 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 Reporting Services (SSRS)

D. SQL Server Integration Services (SSIS)

9 / 25

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

A. To enforce referential integrity

B. To store binary data

C. To create views

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

10 / 25

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

A. To browse the internet

B. To manage database backups

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

D. To monitor server performance

11 / 25

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

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

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

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

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

12 / 25

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

A. Python

B. Java

C. Transact-SQL (T-SQL)

D. C++

13 / 25

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

A. Designing web pages

B. Editing images

C. Writing C# code

D. Managing databases and SQL Server instances

14 / 25

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

A. SQL Server Configuration Manager

B. SQL Server Management Studio (SSMS)

C. SQL Server Integration Services (SSIS)

D. SQL Server Data Tools (SSDT)

15 / 25

15. 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 Reporting Services (SSRS)

D. SQL Server Integration Services (SSIS)

16 / 25

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

A. INT

B. VARCHAR

C. BOOLEAN

D. DATE

17 / 25

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

A. To create user accounts

B. To design database schemas

C. To write SQL queries

D. To manage server configurations like protocols and services

18 / 25

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

19 / 25

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

A. Index

B. Schema

C. Trigger

D. Database

20 / 25

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

A. Mixed Mode Authentication

B. Windows Authentication

C. Integrated Security Mode

D. SQL Server Authentication

21 / 25

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

A. Full

B. Differential

C. Incremental

D. External

22 / 25

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

A. To create tables

B. To delete databases

C. To store data records

D. To encapsulate a series of SQL statements for reuse

23 / 25

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

A. master

B. msdb

C. tempdb

D. model

24 / 25

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

A. Configuration

B. Schema design

C. Querying

D. Deployment

25 / 25

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

A. Stored procedures

B. Views

C. Triggers

D. Indexes

Your score is