Google News
logo
SQL - Quiz(MCQ)
1 .
Which of the following is NOT one of the three phases for Database Design phase?
A)
Global Database Design
B)
Conceptual Database Design
C)
Logical Database Design
D)
Physical Database Design

Correct Answer : Option (A) :   Global Database Design

2 .
Data model comprises all of the following, except _________
A)
a structural part
B)
a manipulative part
C)
a set of integrity rules
D)
a managerial part

Correct Answer : Option (D) :   a managerial part

3 .
Which is not one of the evaluation criteria during testing phase?
A)
Learnability
B)
Performance
C)
Creativity
D)
Robustness

Correct Answer : Option (C) :   Creativity

4 .
AVG, COUNT, MAX, MIN and SUM are known as what?
A)
Aggregate functions
B)
Wildcard filters
C)
Calculated field
D)
Subqueries

Correct Answer : Option (A) :   Aggregate functions

5 .
You must always use _____ when filtering string values.
A)
exclamation point
B)
percent signs
C)
astericks
D)
quotes

Correct Answer : Option (D) :   quotes

6 .
Use what to separate multiple table names in the FROM clause?
A)
commas
B)
periods
C)
spaces
D)
semicolons

Correct Answer : Option (A) :   commas

7 .
To join a table, connect the ______ of one table to the ______ of the other.
A)
filtered by, foreign key
B)
primary key, foreign key
C)
group by clause, primary key
D)
aggregate function, where clause

Correct Answer : Option (B) :   primary key, foreign key

8 .
Use what to remove spaces from the beginning and end of the string value?
A)
SPACE
B)
NOSPACE
C)
CROP
D)
TRIM

Correct Answer : Option (D) :   TRIM

9 .
SELECT MAX(price)FROM    PRODUCT will return how many rows?
A)
0
B)
1
C)
2
D)
As many rows that are in the table

Correct Answer : Option (B) :   1