O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Chapter 4

Claudia Piscociu 11 perguntas

Fazer o quiz

Perguntas do quiz (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

Informações

Descrição
Database Quiz sobre Chapter 4, criado por Claudia Piscociu em 07-02-2017.
Idioma
English
Visualizações
20
Etiquetas
database
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?