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

Registre-se grátis

Quiz

Manipulating Data (Section 3)

Craig Willey 15 perguntas

Fazer o quiz

Perguntas do quiz (15)

  1. 1Which of the following is true of the SQL statement?Imagem da pergunta 1
    1. AThe statement will result in an implicit commit.
    2. BThe statement will remove all data from any INDEX objects associated with that table.
    3. CThe statement will not fire any DML triggers on the table.
    4. DThe statement will fail.
  2. 2The CASCADE keyword, when used with TRUNCATE:
    1. AIs required if the table has any dependent child tables
    2. BWill ensure that future attempts to insert rows to the table will be rejected if they satisfy the TRUNCATE table’s WHERE clause
    3. CCan be used with the optional DEPENDENCY keyword
    4. DNone of these
  3. 3TRUNCATE TABLE:
    1. ACannot be used within a valid SQL statement
    2. BIs a valid set of keywords to be used within a DDL statement
    3. CDoes not require the DROP_ANY_TABLE privilege
    4. DIs a valid statement that will truncate a table called TABLE
  4. 4The table will create successfully. What will result from the INSERT statement?Imagem da pergunta 4
    1. AThe INSERT will fail because there is no list of columns after STUDENT_LIST.
    2. BThe INSERT will fail because the literal value for PHONE is numeric and PHONE is a character data type.
    3. CThe INSERT will execute—the table will contain one row of data.
    4. DNone of these.
  5. 5The table will create successfully. What will be the result of the two INSERT statements?Imagem da pergunta 5
    1. ANeither will execute.
    2. BThe first will execute, but the second will fail.
    3. CThe first will fail, but the second will execute.
    4. DBoth will execute successfully.
  6. 6What will be the result of the INSERT statement?Imagem da pergunta 6
    1. AIt will fail because there is no column list in the INSERT statement.
    2. BIt will fail because there is no PRIMARY KEY in the table.
    3. CIt will execute and create a new row in the table.
    4. DIt will fail because the last name and first name values are reversed.
  7. 7Which of the following reserved words is not required in order to form a syntactically correct UPDATE statement?
    1. AUPDATE
    2. BSET
    3. CWHERE
    4. DNone of these
  8. 8Assume a table LAMPS that has no constraints. Which of the following is true about the UPDATE statement and the LAMPS table? (Choose all that apply.)This
    1. AUPDATE can be used to add rows to LAMPS by setting values to all the columns.
    2. BUPDATE can be used to remove a row from LAMPS by setting all of the row’s columns to a value of NULL.
    3. CFor existing rows in LAMPS, UPDATE can add values to any column with a NULL value.
    4. DFor existing rows in LAMPS, UPDATE can remove values from any column by changing its value to NULL.
  9. 9What can be said of the statements listed here?Imagem da pergunta 9
    1. AOne row will be updated.
    2. BTwo rows will be updated.
    3. CAt least one of the statements will not execute.
    4. DNone of these.
  10. 10What is the end result of the SQL statements listed here?Imagem da pergunta 10
    1. AThe BOUNCERS table will contain one row.
    2. BThe BOUNCERS table will contain two rows.
    3. CThe UPDATE will fail because there is no WHERE clause.
    4. DNone of these.

Informações

Descrição
Databases
Idioma
English
Visualizações
46
Etiquetas
c192graduate
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?