Manipulating Data (Section 3)

Beschreibung

Databases
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor mehr als 4 Jahre
18
0

Zusammenfassung der Ressource

Frage 1

Frage
Which of the following is true of the SQL statement?
Antworten
  • 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.

Frage 2

Frage
The CASCADE keyword, when used with TRUNCATE:
Antworten
  • 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

Frage 3

Frage
TRUNCATE TABLE:
Antworten
  • 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

Frage 4

Frage
The table will create successfully. What will result from the INSERT statement?
Antworten
  • 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.

Frage 5

Frage
The table will create successfully. What will be the result of the two INSERT statements?
Antworten
  • 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.

Frage 6

Frage
What will be the result of the INSERT statement?
Antworten
  • 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.

Frage 7

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

Frage 8

Frage
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
Antworten
  • 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.

Frage 9

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

Frage 10

Frage
What is the end result of the SQL statements listed here?
Antworten
  • 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.

Frage 11

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

Frage 12

Frage
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?
Antworten
  • DELETE FROM PARTS WHERE STATUS = 'VALID' ;
  • DELETE PARTS WHERE PNO = 1 ;
  • DELETE FROM PARTS SET STATUS = NULL WHERE PNO = 1 ;
  • None of these

Frage 13

Frage
Which of the following best describes the results of attempting to execute the DELETE statement?
Antworten
  • 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.

Frage 14

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

Frage 15

Frage
What will be the result of the execution of the SQL statements shown here?This
Antworten
  • 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.
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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
Grundlagen der Online-Zusammenarbeit
Dozent
PuKW Step 6 Teil 2
Mona Les
Kalter Krieg
Anina Hagi
EC Klinische Psychologie
Sandra S.
Vetie - Histo & Embryo - P 2017
Fioras Hu
BAS 2 - Lernquiz
B G
Vetie Tierseuchen 2019 - Anzeigepflichtig/Meldepflichtig
Peter Christian Ponn
Vetie Repro 2017
Mascha K.