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

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

Answer :
  • INSERT

Explanation :

<p>The INSERT statement is used to add one or more rows to a table</p>

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

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

Explanation :

NULL

The SQL WHERE clause:

Answer :
  • Limits the row data are returned

Explanation :

NULL

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

Answer :
  • A) Data types
    B) Primary keys
    C) Default values
    All of the above

Explanation :

abc

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');

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

Answer :
  • DISTINCT