Download PDF
Free download in PDF SQL Server Multiple Choice Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
(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.
(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
(5)
__________ is used to build the code dynamically and execute it.
[A]
sp_executesql
[B]
sp_altermessage
[C]
sp_addmessage
[D]
sp_dropmessage
(6)
_____________ sets procedure options in SQL Server.
[A]
sp_executesql
[B]
sp_dropmessage
[C]
sp_procoption
[D]
sp_altermessage
(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
(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
(10)
Which of the following has support for transaction?
[A]
sp_bindsession
[B]
sp_monitor
[C]
sp_status
[D]
all of the mentioned
(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
(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
(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.
(17)
Which one of the following sorts rows in SQL?
[A]
SORT BY
[B]
ALIGN BY
[C]
ORDER BY
[D]
GROUP BY
(18)
SQL query and modification commands make up a(n) ________ .
[A]
DML
[B]
XML
[C]
DDL
[D]
HTML
(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
(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
Take Mock Tests