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

Descripción

Informatics Practices Test sobre Sin título, creado por taran786num el 25/06/2014.

Autor

taran786num

Idioma

English

Visitas

41

Historial

Creado el 25 jun 2014 · actualizado el 19 feb 2016

Etiquetas

informatics practices

Valoración

Aún sin valoraciones

Valora este test

Valora este test

Más sobre SELECT Queries