GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Manipulating Data (Section 3)

Craig Willey 15 questions

Take the quiz

Questions in this quiz (15)

  1. 1Which of the following is true of the SQL statement?Image for question 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?Image for question 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?Image for question 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?Image for question 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?Image for question 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?Image for question 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.

Information

Description
Databases
Language
English
Views
46
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?