Help shape GoConqr. What should we add next?

Quiz

SQL basics: INSERT, DISTINCT, views and WHERE

taran786num 5 questions Updated 19 Feb 2016

Take the quiz

Questions in this quiz (5)

  1. 1Which SQL statement is used to add rows to a table?
    1. AUPDATE
    2. BINSERT
    3. CAPPEND
    4. DADD
  2. 2To remove duplicate rows from the result set of a select use the following keyword(s):
    1. ANO DUPLICATES
    2. BDISTINCT
    3. CUNIQUE
    4. DNONE OF THE ABOVE
  3. 3A view is nothing but a ______________ table or a stored query.
    1. ADymanic
    2. BReal
    3. CVirtual
    4. DStatic
  4. 4Which of the following SQL clauses specifies a search condition?
    1. AFROM
    2. BWHERE
    3. CWHILE
    4. DSEARCH
  5. 5The CREATE TABLE statement is used to…
    1. Acreate a new database table.
    2. Bcreate a new database.
    3. Cchange existing database table

Information

Description
Informatics Practices Quiz on Untitled, created by taran786num on 25/06/2014.
Language
English
Views
41
History
Created on 25 Jun 2014 · updated on 19 Feb 2016
Tags
informatics practices
Rating
No ratings yet
Rate this quiz
Rate this quiz

More on SELECT Queries

Feedback

What is it about?

What should we add next?