Administering Microsoft SQL Server 2012 Databases (70-462) – Exam Preparation Questions – Part 2
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 function was newly introduced to Transact-SQL in SQL Server 2012 ?
Correct
Incorrect
-
Question 2 of 15
2. Question
1 pointsWhat would be the minimum memory requirement to install SQL Server Enterprise Edition 2012 ?
Correct
Incorrect
-
Question 3 of 15
3. Question
1 pointsWhich of the following system database store information about Scheduled jobs, Alerts and Operators?
Correct
Incorrect
-
Question 4 of 15
4. Question
1 pointsDatabase recovery model determines how the transaction log is used. Which of the following is not a Database recovery model ?
Correct
Incorrect
-
Question 5 of 15
5. Question
1 pointsWhich of the following is not an index type supported by SQL Server?
Correct
Incorrect
-
Question 6 of 15
6. Question
1 pointsWhich function accepts a date parameter and returns the last day of the given month ?
Correct
Incorrect
-
Question 7 of 15
7. Question
1 pointsSQL Server isolation level will help determine the behaviour of the various locks. Which isolation level can be used to create connections that can read only committed data, and they cannot read data that is being modified.
Correct
Incorrect
-
Question 8 of 15
8. Question
1 pointsWhich stored procedure do you use to ping linked servers from SQL Server instance?
Correct
Incorrect
-
Question 9 of 15
9. Question
1 pointsWhich DBCC Command do you use to validate the consistency and integrity of a specific table?
Correct
Incorrect
-
Question 10 of 15
10. Question
1 pointsWhich stored procedure can be used to retrieve information about locks?
Correct
Incorrect
-
Question 11 of 15
11. Question
1 pointsWhich of the following function would you consider using to get the name of a column from a specified table ?
Correct
Incorrect
COL_NAME() funtion returns the name of a column from a specified corresponding table identification number and column identification number.
-
Question 12 of 15
12. Question
1 pointsWhich of the following statement is false for CLUSTED INDEX in SQL Server 2012 ?
Correct
Incorrect
Clustered index stores the data records in physical order. Clustered index that sorts and stores data rows in a table, based on key values.
-
Question 13 of 15
13. Question
1 pointsYou’re planning to modify an existing table called tbl_Sales. Your manager has asked you to get a full report of all the foreign keys information on that table. Which of the following system stored procedure you use to retrieve those information?
Correct
Incorrect
sp_fkeys catalog Stored Procedures returns logical foreign key information for the current environment. This procedure shows foreign key relationships including disabled foreign keys.
-
Question 14 of 15
14. Question
1 pointsWhich statement concerning the Computed column in SQL Server 2012 below is INCORRECT?
Correct
Incorrect
Computed columns must be marked PERSISTED to participate in a FOREIGN KEY constraint.
-
Question 15 of 15
15. Question
1 pointsWhich of the following function would you consider as a deterministic fuction in SQL Server 2012?
Correct
Incorrect
Deterministic functions always return the same result any time they are called with a specific set of input values.