A subquery in an SQL SELECT statement:

cannot have its results sorted using ORDER BY.

can only be used with two tables.

can always be duplicated by a join.

has a distinct form that cannot be duplicated by a join.

cannot have its results sorted using ORDER BY.

The Microsoft Access wildcards are ____ and ____ .

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

create database structures only.

All of the above can be done by SQL.

To define what columns should be displayed in an SQL SELECT statement:

use USING to name the source table(s) and list the columns to be shown after SELECT.

use FROM to name the source table(s) and list the columns to be shown after SELECT.

use USING to name the source table(s) and list the columns to be shown after SELECT.

use SELECT to name the source table(s) and list the columns to be shown after USING.

use USING to name the source table(s) and list the columns to be shown after WHERE.

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

all records meeting the full criteria are to be returned.

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.

The SQL keyword BETWEEN is used:

to limit the columns displayed.

48 + Mcqs in Introduction To Sql in Database Page 1 McqOptions

1.	The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
A.	1
B.
Answer» B.

Discussion

2.	SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
A.	1
B.
Answer» C.

Discussion

3.	The result of every SQL query is a table.
A.	1
B.
Answer» B.

Discussion

4.	ORDER BY can be combined with the SELECT statements.
A.	1
B.
Answer» B.

Discussion

5.	SUM, AVG, MIN, and MAX can only be used with numeric columns.
A.	1
B.
Answer» C.

Discussion

6.	If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
A.	1
B.
Answer» B.

Discussion

7.	Indexes may be created or dropped at any time.
A.	1
B.
Answer» B.

Discussion

8.	SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
A.	1
B.
Answer» B.

Discussion

9.	The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
A.	1
B.
Answer» B.

Discussion

10.	There is an equivalent join expression that can be substituted for all subquery expressions.
A.	1
B.
Answer» C.

Discussion

11.	The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
A.	1
B.
Answer» C.

Discussion

12.	SQL is a data sublanguage.
A.	1
B.
Answer» B.

Discussion

13.	The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
A.	1
B.
Answer» B.

Discussion

14.	The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
A.	1
B.
Answer» B.

Discussion

15.	Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
A.	1
B.
Answer» B.

Discussion

16.	Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
A.	1
B.
Answer» C.

Discussion

17.	A dynamic view is one whose contents materialize when referenced.
A.	1
B.
Answer» B.

Discussion

18.	The keyword LIKE can be used in a WHERE clause to refer to a range of values.
A.	1
B.
Answer» C.

Discussion

19.	SQL is a programming language.
A.	1
B.
Answer» C.

Discussion

20.	COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
A.	1
B.
Answer» B.

Discussion

21.	The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
A.	1
B.
Answer» C.

Discussion

22.	To establish a range of values, < and > can be used.
A.	1
B.
Answer» B.

Discussion

23.	Most companies keep at least two versions of any database they are using.
A.	1
B.
Answer» B.

Discussion

24.	The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
A.	1
B.
Answer» B.

Discussion

25.	A subquery in an SQL SELECT statement:
A.	can only be used with two tables.
B.	can always be duplicated by a join.
C.	has a distinct form that cannot be duplicated by a join.
D.	cannot have its results sorted using ORDER BY.
Answer» D. cannot have its results sorted using ORDER BY.

Discussion

26.	SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A.	1
B.
Answer» B.

Discussion

27.	When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
A.	LIKE only.
B.	IN only.
C.	NOT IN only.
D.	Both IN and NOT IN.
Answer» E.

Discussion

28.	The Microsoft Access wildcards are ____ and ____ .
A.	asterisk (*); percent sign (%)
B.	percent sign (%); underscore (_)
C.	underscore(_); question mark (?)
D.	question mark (?); asterisk (*)
Answer» E.

Discussion

29.	The SQL statement that queries or reads data from a table is ________ .
A.	SELECT
B.	READ
C.	QUERY
D.	None of the above is correct.
Answer» B. READ

Discussion

30.	Indexes can usually be created for both primary and secondary keys.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

31.	Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

32.	To sort the results of a query use:
A.	SORT BY.
B.	GROUP BY.
C.	ORDER BY.
D.	None of the above is correct.
Answer» D. None of the above is correct.

Discussion

33.	SQL can be used to:
A.	create database structures only.
B.	query database data only.
C.	modify database data only.
D.	All of the above can be done by SQL.
Answer» E.

Discussion

34.	________ was adopted as a national standard by ANSI in 1992.
A.	Oracle
B.	SQL
C.	Microsoft Access
D.	DBase
Answer» C. Microsoft Access

Discussion

35.	The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

36.	The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
A.	1
B.
Answer» B.

Discussion

37.	Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

38.	SQL is:
A.	a programming language.
B.	an operating system.
C.	a data sublanguage.
D.	a DBMS.
Answer» D. a DBMS.

Discussion

39.	To define what columns should be displayed in an SQL SELECT statement:
A.	use FROM to name the source table(s) and list the columns to be shown after SELECT.
B.	use USING to name the source table(s) and list the columns to be shown after SELECT.
C.	use SELECT to name the source table(s) and list the columns to be shown after USING.
D.	use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer» B. use USING to name the source table(s) and list the columns to be shown after SELECT.

Discussion

40.	A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
A.	1
B.
Answer» C.

Discussion

41.	The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
A.	1
B.
C.	1
D.
Answer» B.

Discussion

42.	SQL query and modification commands make up a(n) ________ .
A.	DDL
B.	DML
C.	HTML
D.	XML
Answer» C. HTML

Discussion

43.	The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
A.	1
B.
Answer» C.

Discussion

44.	DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

45.	In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
A.	all columns of the table are to be returned.
B.	all records meeting the full criteria are to be returned.
C.	all records with even partial criteria met are to be returned.
D.	None of the above is correct.
Answer» B. all records meeting the full criteria are to be returned.

Discussion

46.	The condition in a WHERE clause can refer to only one value.
A.	1
B.
C.	1
D.
Answer» C. 1

Discussion

47.	The SQL keyword BETWEEN is used:
A.	for ranges.
B.	to limit the columns displayed.
C.	as a wildcard.
D.	None of the above is correct.
Answer» B. to limit the columns displayed.

Discussion

48.	Which one of the following sorts rows in SQL?
A.	SORT BY
B.	ALIGN BY
C.	ORDER BY
D.	GROUP BY
Answer» D. GROUP BY

Discussion

Explore topic-wise MCQs in Database.

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

The result of every SQL query is a table.

ORDER BY can be combined with the SELECT statements.

SUM, AVG, MIN, and MAX can only be used with numeric columns.

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

Indexes may be created or dropped at any time.

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

There is an equivalent join expression that can be substituted for all subquery expressions.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

SQL is a data sublanguage.

The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

A dynamic view is one whose contents materialize when referenced.

The keyword LIKE can be used in a WHERE clause to refer to a range of values.

SQL is a programming language.

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

To establish a range of values, < and > can be used.

Most companies keep at least two versions of any database they are using.

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

A subquery in an SQL SELECT statement:

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

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

The Microsoft Access wildcards are ____ and ____ .

The SQL statement that queries or reads data from a table is ________ .

Indexes can usually be created for both primary and secondary keys.

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

To sort the results of a query use:

SQL can be used to:

________ was adopted as a national standard by ANSI in 1992.

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

SQL is:

To define what columns should be displayed in an SQL SELECT statement:

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

SQL query and modification commands make up a(n) ________ .

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

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

The condition in a WHERE clause can refer to only one value.

The SQL keyword BETWEEN is used:

Which one of the following sorts rows in SQL?

The Microsoft Access wildcards are and .