Manipulating Data (Section 3)

Question

Which of the following is true of the SQL statement?

Answer 1

The statement will result in an implicit commit.

Answer 2

The statement will remove all data from any INDEX objects associated with that table.

Answer 3

The statement will not fire any DML triggers on the table.

Answer 4

The statement will fail.

Answer 5

Is required if the table has any dependent child tables

Answer 6

Will ensure that future attempts to insert rows to the table will be rejected if they satisfy the TRUNCATE table’s WHERE clause

Answer 7

Can be used with the optional DEPENDENCY keyword

Answer 8

None of these

Answer 9

Cannot be used within a valid SQL statement

Answer 10

Is a valid set of keywords to be used within a DDL statement

Answer 11

Does not require the DROP_ANY_TABLE privilege

Answer 12

Is a valid statement that will truncate a table called TABLE

Answer 13

The INSERT will fail because there is no list of columns after STUDENT_LIST.

Answer 14

The INSERT will fail because the literal value for PHONE is numeric and PHONE is a character data type.

Answer 15

The INSERT will execute—the table will contain one row of data.

Answer 16

None of these.

Answer 17

Neither will execute.

Answer 18

The first will execute, but the second will fail.

Answer 19

The first will fail, but the second will execute.

Answer 20

Both will execute successfully.

Answer 21

It will fail because there is no column list in the INSERT statement.

Answer 22

It will fail because there is no PRIMARY KEY in the table.

Answer 23

It will execute and create a new row in the table.

Answer 24

It will fail because the last name and first name values are reversed.

Answer 25

None of these

Answer 26

UPDATE can be used to add rows to LAMPS by setting values to all the columns.

Answer 27

UPDATE can be used to remove a row from LAMPS by setting all of the row’s columns to a value of NULL.

Answer 28

For existing rows in LAMPS, UPDATE can add values to any column with a NULL value.

Answer 29

For existing rows in LAMPS, UPDATE can remove values from any column by changing its value to NULL.

Answer 30

One row will be updated.

Answer 31

Two rows will be updated.

Answer 32

At least one of the statements will not execute.

Answer 33

None of these.

Answer 34

The BOUNCERS table will contain one row.

Answer 35

The BOUNCERS table will contain two rows.

Answer 36

The UPDATE will fail because there is no WHERE clause.

Answer 37

None of these.

Answer 38

DELETE FROM PARTS WHERE STATUS = 'VALID' ;

Answer 39

DELETE PARTS WHERE PNO = 1 ;

Answer 40

DELETE FROM PARTS SET STATUS = NULL WHERE PNO = 1 ;

Answer 41

None of these

Answer 42

The DELETE statement will fail because it is missing a column list between the word DELETE and the name of the table AB_INVOICES.

Answer 43

The DELETE statement will execute, but no rows in the table will be removed.

Answer 44

The DELETE statement will produce a syntax error because it is referencing a row that does not exist in the database.

Answer 45

None of these.

Answer 46

The ADDRESSES table will have one row with a value of 1 for ZONE.

Answer 47

The ADDRESSES table will have one row with a value of 2 for ZONE.

Answer 48

The ADDRESSES table will have no rows.

Answer 49

None of these.

Next up

Manipulating Data (Section 3)

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Similar

	Created by Craig Willey over 4 years ago