Practice Sql Questions Multiple Choice Questions with Answers Quiz-1

Q.1.

We can modify an existing Company from

Company Info > Alter
Gateway of Tally > Modify Company
Company Info > Alter Company
All of the above

Explanation

Q.2.

The arranging of data in a logical sequence is called

Summarizing
Classifying
Sorting
Rearranging

Explanation

Q.3.

Which of the following is not a relational database?

4th Dimension
Reflex
dBASE IV
FoxPro

Explanation

Q.4.

Embedded SQL is which of the following?

The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a trigger.
Hard-coded SQL statements in a program language such as Java.
Hard-coded SQL statements in a procedure.

Explanation

Q.5.

Which operator performs pattern matching ?

LIKE operator
EXISTS operator
BETWEEN operator
None of these

Explanation

Q.6.

Which of the following is a comparison operator in SQL?

=
<>
`
/

Explanation

Q.7.

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ?

Data Manipulation Language(DML)
Data Definition Language(DDL)
Both A & B
None

Explanation

Q.8.

A subquery in an SQL SELECT statement is enclosed in

[ ]
{ }
< >
( )

Explanation

Q.9.

A UNION query is which of the following?

Combines the output from multiple queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from no more than two queries and must include the same number of columns.

Explanation

Q.10.

A database is used to

store data
modify data
extract data
All of the above

Explanation

Q.11.

AND, OR and NOT are examples of

Clauses
Boolean operators
Conjuctive operators
Exclusive operators

Explanation

Q.12.

Which of the following statements is true concerning subqueries?

Does not start with the word SELECT.
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
All of the above

Explanation

Q.13.

The SQL SELECT statement is capable of

Projection
Selection
Protection & Security
Both A & B

Explanation

Q.14.

Which one of the following sorts rows in SQL?

ORDER BY
GROUP BY
SORT BY
ALIGN BY

Explanation

Q.15.

A DBMS query language is designed to

Specify the structure of a database
Support in the development of complex applications software
Support end users who use English-like commands
All of the above

Explanation

Q.16.

SQL views can be used to hide?

Complicated SQL syntax
Rows
Columns
All of the above

Explanation

Q.17.

Which SQL keyword is used to sort the result-set?

ORDER
ORDER BY
SORT BY
SORT

Explanation

Q.18.

What operator tests column for the absence of data?

NOT operator
IS NULL operator
EXISTS operator
All of the above

Explanation

Support mcqgeeks.com by disabling your adblocker.