Database System 2 - CS - CSE Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following is the correct order of keywords for SQL SELECT statements?

SELECT, FROM, WHERE

FROM, WHERE, SELECT

WHERE, FROM,SELECT

SELECT,WHERE,FROM

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

A subquery in an SQL SELECT statement is enclosed in:

braces -- {...}.

CAPITAL LETTERS.

parenthesis -- (...) .

brackets -- [...].

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The result of a SQL SELECT statement is a(n) ________ .

report

form

file

table

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following are the five built-in functions provided by SQL?

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MIN, MAX, MULT

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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.

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The HAVING clause does which of the following?

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.

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

Acts EXACTLY like a WHERE clause.

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The SQL -92 wildcards are ____ and ____ .

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

question mark (?); asterisk (*)

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

ONLY

UNIQUE

DISTINCT

SINGLE

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The benefits of a standard relational language include which of the following?

Reduced training costs

Increased dependence on a single vendor

Applications are not needed

All of the above