SQL - Manipulating Data

No, just one DDL or DCL statement constitutes a complete database transaction, but a transaction can contain more than one DML statement.

Does one DML statement constitute a complete database transaction?

only the offending DML statement

If within a transaction, a single DML statement fails, what is rolled back?

Either omit the column in the column list, or explicitly include the NULL keyword in the INSERT statement's VALUES clause

In an INSERT statement, how can you specify for null values to be inserted into a column?

DDL statements

The CREATE, ALTER, DROP, RENAME, and TRUNCATE statements are examples of which type of SQL statement?

read consistency

What is the name of the concept that guarantees that users have a consistent view of the data?

a subquery

What would you use in an INSERT statement instead of a VALUES clause to copy rows from one table to another?

All savepoints are erased when a commit occurs

When a commit occurs, what happens to existing savepoints?

all the rows in the table

When no WHERE clause is specified in a DELETE statement, which rows are deleted?

INSERT

Which DML statement only adds rows to a table?

the MERGE statement - merges data between two tables. Using DUAL allows us to use this command.

Which DML statement updates rows conditionally, based on whether a row already exists?

the WHERE clause

Which clause in an UPDATE statement specifies the rows that will be updated?

the DEFAULT keyword

Which keyword can be used with the INSERT and UPDATE statement to set a column value to the value previously defined in a DEFAULT constraint?

TO SAVEPOINT. The syntax is: ROLLBACK TO SAVEPOINT name;

Which option of the ROLLBACK statement should you include to rollback only the changes after a particular savepoint?

SAVEPOINT. The syntax is: SAVEPOINT name;

Which statement creates a marker in the current transaction to allow you to roll back only a portion of the changes within the transaction?

ROLLBACK

Which statement ends the current transaction by disregarding all pending changes?

the COMMIT statement

Which statement explicitly makes all pending data modifications permanent?

DELETE

Which statement permanently removes rows in a table and can be rolled back?

DCL and DDL statements

Which two types of statements cause an autocommit to occur?

DML statements

Which type of SQL statement includes the INSERT, UPDATE, DELETE, and MERGE statements?

DCL statements, such as GRANT and REVOKE, control access to data.

Which type of SQL statements control access to data?