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

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

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

Answer :
  • False

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change the value.

Answer :
  • True

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

Answer :
  • True

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Answer :
  • True