JOIN ADRE 2.0 Telegram Group

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.
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series