Introduction to SQL - Database MCQ Questions and answers- Technical Aptitude Page-4 section-1

31.
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 & Solution Discuss in Board Save for Later

32.
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 & Solution Discuss in Board Save for Later

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

A. Oracle

B. SQL

C. Microsoft Access

D. DBase

Answer & Solution Discuss in Board Save for Later

34.
SQL is:

A. a programming language.

B. an operating system.

C. a data sublanguage.

D. a DBMS.

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.
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. True

B. False

Answer & Solution Discuss in Board Save for Later

38.
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. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

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

A. True

B. False

Answer & Solution Discuss in Board Save for Later

Introduction to SQL - Database MCQ Questions and answers- Technical Aptitude

31. The SQL keyword BETWEEN is used:

Answer & Solution

32. A subquery in an SQL SELECT statement:

Answer & Solution

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

Answer & Solution

34. SQL is:

Answer & Solution

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

Answer & Solution

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

Answer & Solution

37. 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.

Answer & Solution

38. 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.

Answer & Solution

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

Answer & Solution

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

Answer & Solution

31.
The SQL keyword BETWEEN is used:

32.
A subquery in an SQL SELECT statement:

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

34.
SQL is:

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

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

37.
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.

38.
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.

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

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