Intelligent MS SQL Server 2014 Assessment Test
Welcome to the MS SQL Server 2014 Quiz! This quiz is meticulously crafted to assess your knowledge and skills in using Microsoft SQL Server 2014, a powerful relational database management system that supports a wide range of data operations. Whether you're a database administrator, a developer, or simply an IT professional looking to gauge your proficiency with SQL Server, this quiz provides a comprehensive review of the key features and functionalities introduced in the 2014 edition.
You'll be tested on various aspects of SQL Server 2014, including but not limited to, its enhanced in-memory capabilities, improvements in security features, new Read morebackup solutions, and the integration of cloud-based technology. Questions will also cover SQL Server Management Studio (SSMS) upgrades, T-SQL enhancements, and troubleshooting common issues.
By participating in this quiz, you'll not only validate your existing knowledge but also learn more about the intricacies of SQL Server 2014 that might have been overlooked. Ready to test your skills and deepen your understanding of MS SQL Server 2014? Let's get started!
MS SQL Server 2014 Questions and Answers
- 1.
How many authentication modes are there in an SQL server?
- A.
7
- B.
6
- C.
2
- D.
3
Correct Answer
C. 2Explanation
There are two authentication modes in an SQL server. This means that users can either authenticate using Windows authentication mode or SQL Server authentication mode. Windows authentication mode allows users to log in using their Windows credentials, while SQL Server authentication mode requires users to provide a username and password specific to the SQL Server.Rate this question:
-
- 2.
Which of these allows an admin to monitor events in an SQL server?
- A.
SQL profiler
- B.
Local table
- C.
Sub query
- D.
SQL server agent
Correct Answer
A. SQL profilerExplanation
SQL Profiler is a tool that allows an admin to monitor events in an SQL server. It provides a graphical interface to capture and analyze events that occur within the SQL server, such as queries, stored procedures, and database transactions. The admin can use SQL Profiler to track performance issues, identify and troubleshoot problems, and optimize the server's performance. It helps in understanding the behavior of the SQL server by capturing and analyzing the events in real-time or from saved trace files.Rate this question:
-
- 3.
What is the maximum level a recursive stored procedure can reach?
- A.
40
- B.
200
- C.
32
- D.
48
Correct Answer
C. 32Explanation
A recursive stored procedure is a procedure that calls itself repeatedly until a certain condition is met. The maximum level that a recursive stored procedure can reach refers to the maximum number of times the procedure can call itself before reaching a termination condition. In this case, the maximum level is 32, meaning that the procedure can call itself up to 32 times before it must stop.Rate this question:
-
- 4.
What happens to local temporary tables when connection is closed? They are...
- A.
Transferred
- B.
Deleted
- C.
Converted to numbers
- D.
Change to rows
Correct Answer
B. DeletedExplanation
When a connection is closed, local temporary tables are deleted. This means that any data stored in these tables is removed and the tables themselves no longer exist. This is because local temporary tables are only accessible within the current session or connection, and once the connection is closed, they are no longer needed and are therefore deleted to free up resources.Rate this question:
-
- 5.
What type of table is created by ## commands?
- A.
Global temporary table
- B.
Local temporary table
- C.
Column table
- D.
Row table
Correct Answer
A. Global temporary tableExplanation
Global temporary tables are created using ## commands. These tables are accessible to all users and are stored in the tempdb database. They are created for a specific session or connection and are automatically dropped when the session or connection is closed. Global temporary tables are useful for storing temporary data that needs to be shared among multiple users or sessions.Rate this question:
-
- 6.
Which of these can be applied to a column to limit the data that can be placed in it?
- A.
Server agent
- B.
Check constraint
- C.
Column sub query
- D.
Coalesce
Correct Answer
B. Check constraintExplanation
A check constraint can be applied to a column to limit the data that can be placed in it. It is a rule defined on a single column or a group of columns that restricts the values that can be inserted or updated in the column(s). The check constraint ensures that only values satisfying the specified condition are allowed in the column, preventing any invalid or inappropriate data from being stored.Rate this question:
-
- 7.
Which of these cannot be checked by the sign function?
- A.
Positive
- B.
Negative
- C.
Zero
- D.
Alphabet
Correct Answer
D. AlpHabetExplanation
The sign function is a mathematical function that returns the sign of a number. It can determine whether a number is positive, negative, or zero. However, it cannot check whether a value is an alphabet or not, as alphabets are not numerical values. Therefore, the sign function cannot be used to determine whether a value is an alphabet or not.Rate this question:
-
- 8.
All of these are types of trigger except...
- A.
Update
- B.
Instead of
- C.
Insert
- D.
Pull
Correct Answer
D. PullExplanation
The given options - Update, Instead of, Insert, and Pull - are all related to triggers in databases. Update and Insert are common types of triggers used to perform actions before or after updating or inserting data into a table. Instead of triggers are used to replace the default behavior of a DML statement. However, Pull is not a type of trigger. It is likely an unrelated term or a distractor in this context.Rate this question:
-
- 9.
Which of these tools can be used to copy a large amount of data in an SQL?
- A.
Copy
- B.
Large copy
- C.
Bulk copy
- D.
Cut
Correct Answer
C. Bulk copyExplanation
Bulk copy is the correct answer because it is a tool that can be used to copy a large amount of data in SQL. It is specifically designed for efficient and fast copying of data between SQL Server databases. The Bulk Copy Program (BCP) utility is commonly used to import or export large volumes of data in a tabular format. It provides high-performance data transfer and supports various data formats, making it an ideal choice for handling large data copying tasks in SQL.Rate this question:
-
- 10.
Which of these is used to compare only strings with strings?
- A.
==
- B.
=
- C.
====
- D.
===
Correct Answer
D. ===Explanation
The === operator is used to compare only strings with strings. This operator compares both the value and the data type of the operands. It returns true if the operands are equal in both value and data type, and false otherwise. The other options, == and =, are used for general comparison and assignment respectively, and do not specifically compare only strings with strings. The option ==== does not exist in programming languages and is not a valid comparison operator.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
May 08, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Samy Boulos -
Mar 09, 2018Quiz Created by
Cripstwick