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

Regístrate gratis

Test

Manipulating Data (Section 3)

Craig Willey 15 preguntas

Hacer el test

Preguntas del test (15)

  1. 1Which of the following is true of the SQL statement?Imagen de la pregunta 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?Imagen de la pregunta 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?Imagen de la pregunta 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?Imagen de la pregunta 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?Imagen de la pregunta 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?Imagen de la pregunta 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.

Información

Descripción
Databases
Idioma
English
Visitas
46
Etiquetas
c192graduate
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?