Manipulating Data (Section 3)

Descripción

Databases
Craig Willey
Test por Craig Willey, actualizado hace más de 1 año
Craig Willey
Creado por Craig Willey hace alrededor de 4 años
18
0

Resumen del Recurso

Pregunta 1

Pregunta
Which of the following is true of the SQL statement?
Respuesta
  • The statement will result in an implicit commit.
  • The statement will remove all data from any INDEX objects associated with that table.
  • The statement will not fire any DML triggers on the table.
  • The statement will fail.

Pregunta 2

Pregunta
The CASCADE keyword, when used with TRUNCATE:
Respuesta
  • Is required if the table has any dependent child tables
  • Will ensure that future attempts to insert rows to the table will be rejected if they satisfy the TRUNCATE table’s WHERE clause
  • Can be used with the optional DEPENDENCY keyword
  • None of these

Pregunta 3

Pregunta
TRUNCATE TABLE:
Respuesta
  • Cannot be used within a valid SQL statement
  • Is a valid set of keywords to be used within a DDL statement
  • Does not require the DROP_ANY_TABLE privilege
  • Is a valid statement that will truncate a table called TABLE

Pregunta 4

Pregunta
The table will create successfully. What will result from the INSERT statement?
Respuesta
  • The INSERT will fail because there is no list of columns after STUDENT_LIST.
  • The INSERT will fail because the literal value for PHONE is numeric and PHONE is a character data type.
  • The INSERT will execute—the table will contain one row of data.
  • None of these.

Pregunta 5

Pregunta
The table will create successfully. What will be the result of the two INSERT statements?
Respuesta
  • Neither will execute.
  • The first will execute, but the second will fail.
  • The first will fail, but the second will execute.
  • Both will execute successfully.

Pregunta 6

Pregunta
What will be the result of the INSERT statement?
Respuesta
  • It will fail because there is no column list in the INSERT statement.
  • It will fail because there is no PRIMARY KEY in the table.
  • It will execute and create a new row in the table.
  • It will fail because the last name and first name values are reversed.

Pregunta 7

Pregunta
Which of the following reserved words is not required in order to form a syntactically correct UPDATE statement?
Respuesta
  • UPDATE
  • SET
  • WHERE
  • None of these

Pregunta 8

Pregunta
Assume 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
Respuesta
  • UPDATE can be used to add rows to LAMPS by setting values to all the columns.
  • UPDATE can be used to remove a row from LAMPS by setting all of the row’s columns to a value of NULL.
  • For existing rows in LAMPS, UPDATE can add values to any column with a NULL value.
  • For existing rows in LAMPS, UPDATE can remove values from any column by changing its value to NULL.

Pregunta 9

Pregunta
What can be said of the statements listed here?
Respuesta
  • One row will be updated.
  • Two rows will be updated.
  • At least one of the statements will not execute.
  • None of these.

Pregunta 10

Pregunta
What is the end result of the SQL statements listed here?
Respuesta
  • The BOUNCERS table will contain one row.
  • The BOUNCERS table will contain two rows.
  • The UPDATE will fail because there is no WHERE clause.
  • None of these.

Pregunta 11

Pregunta
Which of the following reserved words is/are optional in a complete DELETE statement? (Choose all that apply)
Respuesta
  • FROM
  • WHERE
  • DELETE
  • REMOVE

Pregunta 12

Pregunta
Which of the following SQL statements will remove the word VALID from row 1, resulting in one row with a status of NULL and two rows with a status of PENDING?
Respuesta
  • DELETE FROM PARTS WHERE STATUS = 'VALID' ;
  • DELETE PARTS WHERE PNO = 1 ;
  • DELETE FROM PARTS SET STATUS = NULL WHERE PNO = 1 ;
  • None of these

Pregunta 13

Pregunta
Which of the following best describes the results of attempting to execute the DELETE statement?
Respuesta
  • The DELETE statement will fail because it is missing a column list between the word DELETE and the name of the table AB_INVOICES.
  • The DELETE statement will execute, but no rows in the table will be removed.
  • The DELETE statement will produce a syntax error because it is referencing a row that does not exist in the database.
  • None of these.

Pregunta 14

Pregunta
In this series of SQL statements, which line represents the first commit event?
Respuesta
  • Line 1
  • Line 2
  • Line 4
  • Line 5
  • Line 6

Pregunta 15

Pregunta
What will be the result of the execution of the SQL statements shown here?This
Respuesta
  • The ADDRESSES table will have one row with a value of 1 for ZONE.
  • The ADDRESSES table will have one row with a value of 2 for ZONE.
  • The ADDRESSES table will have no rows.
  • None of these.
Mostrar resumen completo Ocultar resumen completo

Similar

Structured Query Language (SQL) (Section 1)
Craig Willey
Using DDL Statements to Create and Manage Tables ( Section 2)
Craig Willey
Restricting and Sorting Data (Section 4)
Craig Willey
El Cuerpo Humano: Aparatos y Sistemas
Diego Santos
Enseñar con Fichas de Memoria
Diego Santos
Estrategias de Enseñanza Alternativas
Diego Santos
Apuntes con Preguntas de Pensamiento Matemático
Raúl Fox
Verbos irregulares
crisferroeldeluna
Ingles III, Present Perfect
serseg83
Deeper Learning
Maya V.
Abreviaciones comunes en programación web
Diego Santos