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?
Q1. Correct Answer
Q2. Correct Answer
Q3. Correct Answer
Common table expressions (CTE)
Q4. Correct Answer
Q5. Correct Answer
Q6. Correct Answer
Log Reader Agent
Q7. Correct Answer
Q8. Correct Answer
Q9. Correct Answer
Q10. Correct Answer