SQL basics: INSERT, DISTINCT, views and WHERE

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

Beschreibung

Informatics Practices Quiz am Ohne Titel, erstellt von taran786num am 25/06/2014.

Autor

taran786num

Sprache

English

Aufrufe

41

Verlauf

Erstellt am 25 Jun 2014 · aktualisiert am 19 Feb 2016

Schlagwörter

informatics practices

Bewertung

Noch keine Bewertungen

Bewerte dieses Quiz

Bewerte dieses Quiz

Mehr zu SELECT Queries