Olete.in – MCQs, Mock Tests & Government Job Prep

MS SQL Server is a ?

1. Centralised database
2. Distributed database
3. Relational database
4. Personal database

✅ Correct Answer: 3

Which of the following statement are true about SQL Server?

1. It is also an ORDBMS
2. It is platform dependent
3. It is both GUI and command based software
4. All of the above

✅ Correct Answer: 4

Which programming language is used to developed MS SQL?

1. C
2. C++
3. Both A and B
4. Java

✅ Correct Answer: 3

SQL Server works in client-server architecture, supports how many types of components?

1. 2
2. 3
3. 4
4. 5

✅ Correct Answer: 1

Which of the following lies between the host machine (Windows OS) and SQL Server?

1. Storage Engine
2. SQL OS
3. Query Executor
4. Query Optimizer

✅ Correct Answer: 2

Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?

1. Automatic
2. Indirect
3. Manual
4. Internal

✅ Correct Answer: 3

How much maximum file can be there in one database?

1. 65536
2. 16384
3. 32764
4. 32767

✅ Correct Answer: 4

The size of the page is?

1. 2 kb
2. 4 kb
3. 8 kb
4. 16 kb

✅ Correct Answer: 3

Rollback operations are also logged

1. TRUE
2. FALSE
3. Can be true or false
4. Can not say

✅ Correct Answer: 1

How many types of file groups in SQL Server?

1. 1
2. 3
3. 4
4. 2

✅ Correct Answer: 4

MS SQL Server developed by?

1. Microsoft
2. IBM
3. Oracle
4. Google

✅ Correct Answer: 1

Microsoft SQL Server Initial release on?

1. 1988
2. 1989
3. 1990
4. 1991

✅ Correct Answer: 2

Which of the following is an Advantages of Instances (SQL Server)?

1. To reduce cost
2. To reduce temporary database problems
3. To separate security privileges
4. All of the above

✅ Correct Answer: 4

How many protocol SQL Server has?

1. 2
2. 3
3. 4
4. 5

✅ Correct Answer: 3

In SQL Server 2012 how many types of checkpoints there?

1. 3
2. 4
3. 5
4. 6

✅ Correct Answer: 2

Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?

1. mdf
2. .ndf
3. .ldf
4. .pdf

✅ Correct Answer: 1

Which extents are made up of only single object?

1. mixed
2. uniform
3. double
4. single

✅ Correct Answer: 2

Each log record is identified by Log Sequence Number (LSN).

1. TRUE
2. FALSE
3. Can be true or false
4. Can not say

✅ Correct Answer: 1

Which of the following prepare the execution plan as output by taking query, statistics and Algebrizer tree as input?

1. Query Parser
2. Execution Plan
3. Query Executor
4. Query Optimizer

✅ Correct Answer: 4

The recommended extension for log file is ?

1. .idf
2. .ldf
3. .udf
4. .rdf

✅ Correct Answer: 2

🧪 MS-SQL MCQ Quiz Hub

MS SQL Server MCQ