Oracle Database 12c R2: Advanced PL/SQL Ed 2 Quiz Questions and Answers

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

Answer :
  • COUNT, SUM, AVG, MAX, MIN

Which of the following do you need to consider when making an SQL table?

Answer :
  • All of the above

Which of the following is the original purpose of SQL?

Answer :
  • All of the above

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

Answer :
  • Table

A subquery in an SQL SELECT statement is enclosed in:

Answer :
  • parenthesis -- (...) .

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA':

Answer :
  • SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

The wildcard in a WHERE clause is useful when?

Answer :
  • An exact match is not possible in a SELECT statement.

You can add a row using SQL in a database with which of the following?

Answer :
  • INSERT

The SQL WHERE clause:

Answer :
  • Limits the row data are returned

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

Answer :
  • SELECT, FROM, WHERE