70-462 Exam Preparation Questions – Part 1
Quiz-summary
0 of 15 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
Information
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:
Results
0 of 15 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- Answered
- Review
-
Question 1 of 15
1. Question
1 pointsWhich stored procedure do you use to send emails from SQL Server instance?
Correct
Incorrect
-
Question 2 of 15
2. Question
1 pointsHow many instances of SQL Server 2012 can you install on a failover cluster?
Correct
Incorrect
-
Question 3 of 15
3. Question
1 pointsWhich tool do you use to stop or start the SQL Server Reporting Services?
Correct
Incorrect
-
Question 4 of 15
4. Question
1 pointsWhat is the maximum number of clustered indexes that you can configure for a SQL Server 2012 Database table?
Correct
Incorrect
-
Question 5 of 15
5. Question
1 pointsWhich tool do you use to monitor SQL Server performance?
Correct
Incorrect
-
Question 6 of 15
6. Question
1 pointsWhich stored procedure do you use to retrieve list of Table and Views on Database?
Correct
Incorrect
-
Question 7 of 15
7. Question
1 pointsWhat is the maximum character length of the SQL Server 2012 identifier?
Correct
Incorrect
-
Question 8 of 15
8. Question
1 pointsWhich of the following system databases recreate when SQL server restarts?
Correct
Incorrect
-
Question 9 of 15
9. Question
1 pointsWhich stored procedure do you use to enable Database Mail on SQL Server instance?
Correct
Incorrect
-
Question 10 of 15
10. Question
1 pointsWhat is the maximum number of none clustered indexes that you can configure for a SQL Server 2012 Database table?
Correct
Incorrect
-
Question 11 of 15
11. Question
1 pointsWhich statement concerning the Constraints in SQL Server 2012 below is INCORRECT?
Correct
Incorrect
DEFAULT constraints cannot be used with an identity column.
-
Question 12 of 15
12. Question
1 pointsYou’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 ?
Correct
Incorrect
sp_column_privileges catalog Stored Procedures returns column privilege information for a single table in the current environment.
-
Question 13 of 15
13. Question
1 pointsSQL 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?
Correct
Incorrect
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions.
-
Question 14 of 15
14. Question
1 pointsWhich of the following function would you consider using to get the current lock time-out setting for the current session?
Correct
Incorrect
@@LOCK_TIMEOUT function returns the current lock time-out setting in milliseconds for the current session.
-
Question 15 of 15
15. Question
1 pointsWhich of the below statements is incorrect about the Shared Locks in SQL Server 2012 ?
Correct
Incorrect
Other processes cannot modify the locked resource while the lock remains.