Administering Microsoft SQL Server 2012 Databases (70-462) – Exam Preparation Questions – Part 3

Which datetime function was newly introduced to Transact-SQL in SQL Server 2012 ?

Which of the following system database store information about every user and database?

Which SQL function returns a date value based on integer input value ?

SQL Server isolation level will help determine the behaviour of the various locks. Which isolation level can be used to create connection cannot read data that has already been read by other connections that have not completed the transactions from within which the read occurred ?

SQL Server isolation level will help determine the behaviour of the various locks. Which isolation level can be used to create connection can read data that has not been committed ?

Which stored procedure do you use to execute batch file from SQL Server instance?

Which tool do you use to track locks and deadlocks?

Which DBCC Command do you use to validate the consistency and integrity of a database?

Which DBCC Command do you use to determine the fragmentation level of a table or index?

Which DBCC Command do you use to Used to shrink a file, such as a transaction log file?

Which of the following function would you consider using to get the maximum number of simultaneous user connections allowed on an instance of SQL Server?

Which statement concerning the Triggers in SQL Server 2012 below is INCORRECT?

Which of the below statements is true about the T-SQL SET PARSEONLY Statement ?

Which of the following function would you consider using to get the name of the local server that is running SQL Server. ?

Which of the following T-SQL clause is NOT a Table Hint ?