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 function was newly introduced to Transact-SQL in SQL Server 2012 ?
What would be the minimum memory requirement to install SQL Server Enterprise Edition 2012 ?
Which of the following system database store information about Scheduled jobs, Alerts and Operators?
Database recovery model determines how the transaction log is used. Which of the following is not a Database recovery model ?
Which of the following is not an index type supported by SQL Server?
Which function accepts a date parameter and returns the last day of the given month ?
SQL 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.
Which stored procedure do you use to ping linked servers from SQL Server instance?
Which DBCC Command do you use to validate the consistency and integrity of a specific table?
Which stored procedure can be used to retrieve information about locks?
Which of the following function would you consider using to get the name of a column from a specified table ?
COL_NAME() funtion returns the name of a column from a specified corresponding table identification number and column identification number.
Which of the following statement is false for CLUSTED INDEX in SQL Server 2012 ?
Clustered index stores the data records in physical order. Clustered index that sorts and stores data rows in a table, based on key values.
You’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?
sp_fkeys catalog Stored Procedures returns logical foreign key information for the current environment. This procedure shows foreign key relationships including disabled foreign keys.
Which statement concerning the Computed column in SQL Server 2012 below is INCORRECT?
Computed columns must be marked PERSISTED to participate in a FOREIGN KEY constraint.
Which of the following function would you consider as a deterministic fuction in SQL Server 2012?
Deterministic functions always return the same result any time they are called with a specific set of input values.