SQL Server Quiz | SQL Server Multiple Choice Questions and Answers

Questions
1 What does the abbreviation DBMS stand for?
A Database Management System.
B Database Manipulation Software.
C Data Borrowing and Movement Software.
D Digital Base Mapping System.

Answer: Database Management System.
2 The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?
A It is good at handling geographical concepts.
B It is widely used.
C It is simple and easy to understand.
D It uses a pseudo-English style of questioning.

Answer: It is good at handling geographical concepts.

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
3 Which of the following are characteristics of an RDBMS?
A Tables are linked by common data known as keys.
B Queries are possible on individual or groups of tables.
C It cannot use SQL.
D Keys may be unique or have multiple occurrences in the database.

Answer: Tables are linked by common data known as keys.
4 Stored procedure used to remember the exact number of bytes is _____________
A sp_datatype_info
B sp_info
C sp_datatype
D none of the mentioned

Answer: sp_datatype_info
5 __________ is used to build the code dynamically and execute it.
A sp_executesql
B sp_altermessage
C sp_addmessage
D sp_dropmessage

Answer: sp_executesql
6 _____________ sets procedure options in SQL Server.
A sp_executesql
B sp_dropmessage
C sp_procoption
D sp_altermessage

Answer: sp_procoption
7 Which of the following stored procedure is used for error messages?
A sp_dropmessage
B sp_altermessage
C sp_addmessage
D all of the mentioned

Answer: sp_addmessage
8 __________create the removable database.
A sp_certify_removable
B sp_certify
C sp_removable
D all of the mentioned

Answer: sp_certify_removable
9 Point out the wrong statement.
A BASE support
B ACID support
C Support for transactions is one of the most important reasons to use database engines such as SQL Server
D All of the mentioned

Answer: BASE support
10 Which of the following has support for transaction?
A sp_bindsession
B sp_monitor
C sp_status
D all of the mentioned

Answer: sp_bindsession
11 __________ takes no parameters and returns all kinds of interesting information.
A sp_status
B sp_monitor
C sp_on
D none of the mentioned

Answer: sp_monitor
12 Point out the correct statement.
A Stored procedures cannot improve performance
B A stored procedure is a group of Transact-SQL statements pre compiled into a single execution plan
C Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed
D All of the mentioned

Answer: Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed
13 Reasons for consideration of the stored procedure can be?
A Do you want to view data in the database (SELECT), insert new records (INSERT INTO), or do I want to change an existing record (UPDATE)?
B How often will this procedure actually be used?
C With which tables will you have to work? Does it make sense to create a VIEW first?
D All of the mentioned

Answer: All of the mentioned
14 The SQL statement that queries or reads data from a table is ________ .
A SELECT
B READ
C QUERY
D None of the above

Answer: SELECT
15 SQL can be used to:
A modify database data only.
B create database structures only.
C query database data only.
D All of the above can be done by SQL.

Answer: All of the above can be done by SQL.
16 To sort the results of a query use:
A ORDER BY.
B GROUP BY.
C SORT BY.
D None of the above is correct.

Answer: ORDER BY.
17 Which one of the following sorts rows in SQL?
A SORT BY
B ALIGN BY
C ORDER BY
D GROUP BY

Answer: ORDER BY
18 SQL query and modification commands make up a(n) ________ .
A DML
B XML
C DDL
D HTML

Answer: DML
19 Which of the following do you need to consider when you make a table in SQL?
A Default values
B Primary keys
C Data types
D All of the above

Answer: All of the above
20 The benefits of a standard relational language include which of the following?
A Reduced training costs
B Increased dependence on a single vendor
C Applications are not needed.
D All of the above

Answer: Reduced training costs
ADRE 3.0 Complete Study Material