Oracle Database: Introduction to SQL Quiz Questions and Answers

In SQL, which command is used to SELECT only one copy of each set of duplicable rows.

Answer :
  • SELECT DISTINCT

Which operator performs the sum operation?

Answer :
  • Sum

Which of the following is used to create a table?

Answer :
  • create table abc

Which of the SQL statements is correct?

Answer :
  • Select max(sal) from emp

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Answer :
  • False

SQL provides the AS keyword, which assigns meaningful column names to the results of queries using the SQL built-in functions.

Answer :
  • True

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Answer :
  • True

A dynamic view is one whose contents materialize when referenced.

Answer :
  • True

SQL is a programming language.

Answer :
  • False

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Answer :
  • False