0 of 15 questions completed
The Exam 70-462 has been designed for database professionals who perform installation, maintenance and configuration SQL Server 2012 Databases.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 15 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
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?
@@MAX_CONNECTIONS function returns 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?
Logon triggers do not fire if authentication fails.
Which of the below statements is true about the T-SQL SET PARSEONLY Statement ?
SET PARSEONLY examines the syntax of each Transact-SQL statement and returns any error messages without compiling or executing the statement.
Which of the following function would you consider using to get the name of the local server that is running SQL Server. ?
@@SERVERNAME function returns the name of the local server that is running SQL Server.
Which of the following T-SQL clause is NOT a Table Hint ?
Table hints override the default behavior of the query optimizer for the duration of the data manipulation language (DML) statement. Ex : FORCESCAN , FORCESEEK , HOLDLOCK , NOLOCK , NOWAIT , PAGLOCK , READCOMMITTED , EADCOMMITTEDLOCK , READPAST , READUNCOMMITTED , REPEATABLEREAD , ROWLOCK , ERIALIZABLE , TABLOCK , TABLOCKX , UPDLOCK , XLOCK