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 stored procedure do you use to send emails from SQL Server instance?
How many instances of SQL Server 2012 can you install on a failover cluster?
Which tool do you use to stop or start the SQL Server Reporting Services?
What is the maximum number of clustered indexes that you can configure for a SQL Server 2012 Database table?
Which tool do you use to monitor SQL Server performance?
Which stored procedure do you use to retrieve list of Table and Views on Database?
What is the maximum character length of the SQL Server 2012 identifier?
Which of the following system databases recreate when SQL server restarts?
Which stored procedure do you use to enable Database Mail on SQL Server instance?
What is the maximum number of none clustered indexes that you can configure for a SQL Server 2012 Database table?
Which statement concerning the Constraints in SQL Server 2012 below is INCORRECT?
DEFAULT constraints cannot be used with an identity column.
You’re planning to modify an existing table called tbl_Patients_History. Your manager has asked you to get a full report of all the column privilege information on that table. Which of the following system stored procedure you use to retrieve those information ?
sp_column_privileges catalog Stored Procedures returns column privilege information for a single table in the current environment.
SQL Server provides a number of tools that can be used to perform performance monitoring and tuning. Which of the following tool is not a SQL Server 2012 performance monitoring and tuning tool?
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions.
Which of the following function would you consider using to get the current lock time-out setting for the current session?
@@LOCK_TIMEOUT function returns the current lock time-out setting in milliseconds for the current session.
Which of the below statements is incorrect about the Shared Locks in SQL Server 2012 ?
Other processes cannot modify the locked resource while the lock remains.