MS SQL Database Administrator Interview Questions – Part 4

On 21 Apr, 2015
MS SQL DBA
By : Charith Silva
With 1 Comment
Views : 4248

 

Questions

 

Q1. SQL Server 2012 introduces four new data type conversion functions, name two of them?

 

 

Q2. SQL Server 2012 introduces two new logical functions that allow more inline data selection with very little code, name one of them?

 

 

Q3. When you working with SQL Server, you may often find you need to temporarily store a data set for later use. Can you name those primary temporary objects?

 

 

Q4. Typically there are three types of servers in a replication topology; can you name all three of them?

 

 

Q5. There are five types of replication in Microsoft SQL Server 2012. Can you name three of them?

 

 

Q6. SQL Server 2012 uses four types of Replication agents to moving data and database objects between servers.  Name two Replication agents ?

 

 

Q7. Name three SQL Server Agent components?

 

 

Q8. Name three Log shipping components?

 

 

Q9. Microsoft SQL Server 2012 has four types of stored procedures; name three of them ?

 

 

Q10. Name three SQL Server 2012 Ranking functions?

 

 

 

 

 

 

 

Answers

 

Q1. Correct Answer

PARSE

TRY_PARSE

TRY_CAST

TRY_CONVERT

 

Q2. Correct Answer

CHOOSE

IIF

 

Q3. Correct Answer

Table variables

Temporary tables

Common table expressions (CTE)

 

Q4. Correct Answer

Publisher

Subscriber

Distributor

 

Q5. Correct Answer

Snapshot

Transactional

Merge

Oracle Publisher

Peer-to-peer

 

Q6. Correct Answer

Snapshot Agent

Distribution Agent

Log Reader Agent

Merge Agent

 

Q7. Correct Answer

Job

Schedule

Operator

Alert

Proxy

 

Q8. Correct Answer

Primary server

Primary database

Secondary server

Secondary database

Monitor server

 

Q9. Correct Answer

User-defined

System

Temporary

Extended user-defined

 

Q10. Correct Answer

ROW_NUMBER

RANK

DENSE_RANK

NTILE

 

 



About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87
All Posts by : Charith Silva

Comments ( 1 )

  • mgribler@hotmail.com'

    Mark Gribler Jun 29 , 2015 at 5:33 pm / Reply

    I just took your quiz and failed (not really) as you have fallen into the “how much can I remember” rather than how much do I understand.

    Some of your answers are technically wrong …dbcc showcontig is deprecated by 2012….

    No one still uses profiler rather than extended events. You also would not use either tools looking for locks.

    Nothing about performance tuning or plans or understanding of internals… Just allowing people to revise for an exam which IS NOT THE POINT. An exam should be that if you don’t understand the subject no amount of study should EVER yield a pass. This may have an issue for certain websites and certain boot camps but….

    do we need these guys as DBA’s……

Leave a Comment

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">