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

Correct Answer : Option (A)

COUNT, SUM, AVG, MAX, MIN
  Show Answer
2 .
The following SQL is which type of join: 
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM
CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID​

Correct Answer : Option (A)

Equi-join
  Show Answer
3 .
How many tables may be included with a join?

Correct Answer : Option (D)

All of the above
  Show Answer
4 .
Which of the following is valid SQL for an Index?

Correct Answer : Option (A)

CREATE INDEX ID;
  Show Answer
5 .
Embedded SQL is which of the following?

Correct Answer : Option (C)

Hard-coded SQL statements in a program language such as Java.
  Show Answer
6 .
A UNION query is which of the following?

Correct Answer : Option (B)

Combines the output from multiple queries and must include the same number of columns.
  Show Answer
7 .
Which of the following is true concerning triggers?

Correct Answer : Option (A)

They have an event, condition, and action.
  Show Answer
8 .
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

Correct Answer : Option (A)

all columns of the table are to be returned.
  Show Answer
9 .
Which of the following do you need to consider when you make a table in SQL?

Correct Answer : Option (D)

All of the above.
  Show Answer
10 .
Which one of the following sorts rows in SQL?

Correct Answer : Option (C)

ORDER BY
  Show Answer