¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

Chapter 4

Claudia Piscociu 11 preguntas

Hacer el test

Preguntas del test (11)

  1. 1The SQL command:
    SELECT city + state location FROM customers;
    1. Auses a function
    2. Buses a label
    3. Cuses an operator
    4. Dhas a clause
    5. Eperforms an update
  2. 2The SQL command:
    SELECT MAX(city), COUNT(*) counter FROM customers WHERE nls_language='eng';
    1. Auses a function
    2. Bit is inccorect because MAX doesn't apply to characters
    3. Cdisplays two columns
    4. Ddisplays three columns
    5. Edisplays the tuples found in the table counter
  3. 3CREATE TABLE command allows:
    1. Aloading data into a table
    2. Bupdating the data structure of a table
    3. Cdefining integrity restrictions
    4. Ddefining the domains for attributes
    5. Edefining the type for attributes
  4. 4SELECT command:
    1. Amay use an aggregation function
    2. Bmay use arithmetic operators
    3. Cmay use a group function
    4. Dperforms a query
    5. Ecan display only some columns of a table
  5. 5The SQL command:
    SELECT c.city o.order_date FROM customers c, orders o WHERE c.customer_id = o.customer_id;
    implements the relational operators
    1. Aunion
    2. Bjoin
    3. Cselection
    4. Dconcatenation
    5. Eintersection
  6. 6SELECT command:
    1. Acan implement just three relational operators
    2. Bcan perform the update operation
    3. Ccan update the data structure
    4. Dcan display only a part of the table tuples
    5. Ecan define integrity constrains
    6. Fnone of the above
  7. 7The following command:
    INSERT INTO customers SET customer_id = 22 WHERE nls_language = 'eng';
    1. Aadds a tuple between two existing ones
    2. Bis wrong because it has the SET clause
    3. Cis wrong because it has the INTO clause
    4. Dadds a tuple in the table customer_id
    5. Eis wrong because it has the WHERE clause
  8. 8The SQL command:
    DELETE ALL FROM customers;
    1. Adeletes all tuples from customers table
    2. Bis wrong because it has the ALL clause
    3. Cis a manipulation command
    4. Dis incorrect because the DELETE command doesn't exist
    5. Eis incorrect because no table name must be indicated
  9. 9The SQL command:
    UPDATE customers SET nls_language = 'eng' WHERE customer_id = 22;
    1. Amodifies all tuples in the table
    2. Bupdates all the attributes of the table
    3. Cmodifies only some tuples in the table
    4. Dupdates the table called nls_language
    5. Eupdates a single attribute of the table
  10. 10CREATE VIEW command:
    1. Adefines a virtual table
    2. Bworks with a view
    3. Cdisplays data from a table
    4. Ddisplays data in a virtual table
    5. Eopens a virtual table

Información

Descripción
Database Test sobre Chapter 4, creado por Claudia Piscociu el 07/02/2017.
Idioma
English
Visitas
20
Etiquetas
database
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?