SQL Server Quiz | SQL Server Multiple Choice Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

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

Random GK Questions

Q. The biggest item of India’s imports is :
Q. Through which of the given regions does the equator run?
Q. Which of the following is the Third largest country in population after China and India?
Q. The climate of India is tropical because of :
Q. In the year 1613 where was the English East India Company given permission to set up a factory (trading post) ?
Q. Who conceived the idea of Pakistan ?
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series