Practice Sql Miscellaneous Multiple Choice Questions Quiz-3 - MCQGeeks.com

Q.1

The SQL keyword(s) ________ is used with wildcards.

NOT IN only
LIKE only
IN only
IN and NOT IN

Q.2

A subquery in an SQL SELECT statement is enclosed in:

parenthesis -- (...).
brackets -- [...].
CAPITAL LETTERS.
braces -- {...}.

Q.3

The result of a SQL SELECT statement is a ________ .

file
report
table
form

Q.4

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.

Q.5

The HAVING clause does which of the following?

Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.

Q.6

Which of the following do you need to consider when you make a table in SQL?

Data types
Primary keys
Default values
All of the above.

Q.7

Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints

10
9
5
0

Q.8

Which of the following SQL commands can be used to add data to a database table?

ADD
UPDATE
APPEND
INSERT

Q.9

Which of the following join is also called as an 'inner-join'?

Non-Equijoin
Self-Join
Equijoin
None of these

Q.10

Which of the following is NOT a type of SQL constraint?

PRIMARY KEY
ALTERNATE KEY
FOREIGN KEY
UNIQUE

Q.11

What is an SQL virtual table that is constructed from other tables?

view
A relation
Just another table
Query results

Q.12

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

NOT IN only.
LIKE only.
IN only.
Both IN and NOT IN.

Q.13

SQL can be used to:

create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

Q.14

The SQL keyword BETWEEN is used:

to limit the columns displayed.
for ranges.
as a wildcard.
None of these is correct.

Q.15

Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and <80;
SELECT name, course_name FROM student WHERE age>50 and age <80;
SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
None of these

Q.16

How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';
SELECT * FROM student WHERE name LIKE '%r%';
SELECT * FROM student WHERE name LIKE '%r';
SELECT * FROM student WHERE name LIKE '_r%';

Q.17

Which SQL statement is used to update data in a database?

SAVE
UPDATE
SAVE AS
MODIFY

Q.18

Which SQL statement is used to delete data FROM a database?

COLLAPSE
REMOVE
ALTER
DELETE

Q.19

In SQL, which of the following is not a data definition language commands?

RENAME
REVOKE
GRANT
UPDATE

Q.20

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

SELECT DISTINCT
SELECT UNIQUE
SELECT DIFFERENT
All of the above

0 h : 0 m : 1 s