Register|  Forgot Password

Introduction to SQL Questions and Answers

  1. Home
  2. Engineering
  3. Computer Science & Engineering
  4. Database
  5. Introduction to SQL

Exercise

Exercise 1
Exercise 2

Article

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

A)   Data types

B)   Primary keys

C)   Default values

D)   All of the above.

View Answer
Workspace
Report
Discuss in Forum


Correct Option - D

Explanation


Report this question
Q 2
The SQL -92 wildcards are ____ and ____ .

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

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

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

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

View Answer
Workspace
Report
Discuss in Forum


Correct Option - B

Explanation


Report this question
Q 3
The result of a SQL SELECT statement is a(n) ________ .

A)   report

B)   form

C)   file

D)   table

View Answer
Workspace
Report
Discuss in Forum


Correct Option - D

Explanation


Report this question
Q 4
Which one of the following sorts rows in SQL?

A)   SORT BY

B)   ALIGN BY

C)   ORDER BY

D)   GROUP BY

View Answer
Workspace
Report
Discuss in Forum


Correct Option - C

Explanation


Report this question
Q 5
Which of the following are the five built-in functions provided by SQL?

A)   COUNT, SUM, AVG, MAX, MIN

B)   SUM, AVG, MIN, MAX, MULT

C)   SUM, AVG, MULT, DIV, MIN

D)   SUM, AVG, MIN, MAX, NAME

View Answer
Workspace
Report
Discuss in Forum


Correct Option - A

Explanation


Report this question
Q 6
SQL query and modification commands make up a(n) ________ .

A)   DDL

B)   DML

C)   HTML

D)   XML

View Answer
Workspace
Report
Discuss in Forum


Correct Option - B

Explanation


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

A)   ONLY

B)   UNIQUE

C)   DISTINCT

D)   SINGLE

View Answer
Workspace
Report
Discuss in Forum


Correct Option - C

Explanation


Report this question
Share This Page -