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

A. LIKE only

B. IN only

C. NOT IN only

D. IN and NOT IN

A. SELECT, FROM, WHERE

B. FROM, WHERE, SELECT

C. WHERE, FROM,SELECT

D. SELECT,WHERE,FROM

A. braces -- {...}.

B. CAPITAL LETTERS.

C. parenthesis -- (...) .

D. brackets -- [...].

A. report

B. form

C. file

D. table

A. COUNT, SUM, AVG, MAX, MIN

B. SUM, AVG, MIN, MAX, MULT

C. SUM, AVG, MULT, DIV, MIN

D. SUM, AVG, MIN, MAX, NAME

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.

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

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

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

D. Acts EXACTLY like a WHERE clause.

A. asterisk (*); percent sign (%)

B. percent sign (%); underscore (_)

C. underscore(_); question mark (?)

D. question mark (?); asterisk (*)

A. ONLY

B. UNIQUE

C. DISTINCT

D. SINGLE

A. Reduced training costs

B. Increased dependence on a single vendor

C. Applications are not needed

D. All of the above