Intelligent MS SQL Server 2014 Assessment Test

Reviewed by Samy Boulos
Samy Boulos, MSc (Computer Science) |
Data Engineer
Review Board Member
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.
 , MSc (Computer Science)
By Cripstwick
C
Cripstwick
Community Contributor
Quizzes Created: 636 | Total Attempts: 835,032
| Attempts: 281
SettingsSettings
Please wait...
  • 1/10 Questions

    What happens to local temporary tables when connection is closed? They are...

    • Transferred
    • Deleted
    • Converted to numbers
    • Change to rows
Please wait...
About This Quiz

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 backup 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!

Intelligent MS SQL Server 2014 Assessment Test - Quiz

Quiz Preview

  • 2. 

    Which of these tools can be used to copy a large amount of data in an SQL?

    • Copy

    • Large copy

    • Bulk copy

    • Cut

    Correct Answer
    A. Bulk copy
    Explanation
    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:

  • 3. 

    Which of these cannot be checked by the sign function?

    • Positive

    • Negative

    • Zero

    • Alphabet

    Correct Answer
    A. Alphabet
    Explanation
    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:

  • 4. 

    What type of table is created by ## commands?

    • Global temporary table

    • Local temporary table

    • Column table

    • Row table

    Correct Answer
    A. Global temporary table
    Explanation
    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:

  • 5. 

    Which of these can be applied to a column to limit the data that can be placed in it?

    • Server agent

    • Check constraint

    • Column sub query

    • Coalesce

    Correct Answer
    A. Check constraint
    Explanation
    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:

  • 6. 

    How many authentication modes are there in an SQL server?

    • 7

    • 6

    • 2

    • 3

    Correct Answer
    A. 2
    Explanation
    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:

  • 7. 

    Which of these allows an admin to monitor events in an SQL server?

    • SQL profiler

    • Local table

    • Sub query

    • SQL server agent

    Correct Answer
    A. SQL profiler
    Explanation
    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:

  • 8. 

    All of these are types of trigger except...

    • Update

    • Instead of

    • Insert

    • Pull

    Correct Answer
    A. Pull
    Explanation
    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. 

    What is the maximum level a recursive stored procedure can reach?

    • 40

    • 200

    • 32

    • 48

    Correct Answer
    A. 32
    Explanation
    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:

  • 10. 

    Which of these is used to compare only strings with strings?

    • ==

    • =

    • ====

    • ===

    Correct Answer
    A. ===
    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:

Samy Boulos |MSc (Computer Science) |
Data Engineer
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.

Quiz Review Timeline (Updated): May 8, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • May 08, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Samy Boulos
  • Mar 09, 2018
    Quiz Created by
    Cripstwick
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.