SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact





MS SQL Database Administrator Interview Questions – Part 4

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

 

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

 

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)

Related



Previous Post Next Post 

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

Click here to cancel reply

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="">





  • Popular
  • Recent
  • Database stuck in “Restoring” state

    19388 views
  • Find the modified date of SQL Server Agents Jobs

    10396 views
  • Script to Check TempDB Speed

    5522 views
  • PING all the Linked Servers and get a status report

    5123 views
  • Log shipping Alerts failing to send emails

    4929 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 7 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 7 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 7 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 7 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 7 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 7 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository