MS-SQL/MS SQL Server MCQ Sample Test,Sample questions

  1. Home

Question: 
 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

Question: 
 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

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

1.TRUE

2.FALSE

3.Can be true or false

4.Can not say

Question: 
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

Question: 
How many protocol SQL Server has?

1.2

2.3

3.4

4.5

Question: 
How many types of file groups in SQL Server?

1.1

2.3

3.4

4.2

Question: 
How much maximum file can be there in one database?

1.65536

2.16384

3.32764

4.32767

Question: 
In SQL Server 2012 how many types of checkpoints there?

1.3

2.4

3.5

4.6

Question: 
Microsoft SQL Server Initial release on?

1.1988

2.1989

3.1990

4.1991

Question: 
MS SQL Server developed by?

1.Microsoft

2.IBM

3.Oracle

4.Google

Question: 
MS SQL Server is a ?

1. Centralised database

2. Distributed database

3.Relational database

4. Personal database

Question: 
Rollback operations are also logged

1.TRUE

2.FALSE

3.Can be true or false

4.Can not say

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

1.2

2.3

3.4

4.5

Question: 
The recommended extension for log file is ?

1..idf

2..ldf

3..udf

4..rdf

Question: 
The size of the page is?

1.2 kb

2.4 kb

3.8 kb

4.16 kb

Question: 
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

Question: 
Which extents are made up of only single object?

1.mixed

2.uniform

3.double

4.single

Question: 
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

Question: 
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

Question: 
Which programming language is used to developed MS SQL?

1.C

2.C++

3.Both A and B

4.Java

Posted on by Online Exam TestTeam

More MCQS

  1. MS SQL Server MCQ
  2. MS-SQL Mcq Question Set 1
Search
Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!