inv_date = '15-february-2008' :uses implicit conversion

inv_amt = '0255982' : requires explicit conversion

inv_date > '01-02-2008' : uses implicit conversion

CONCAT(inv_amt, inv_date) : requires explicit conversion

inv_no BETWEEN '101' AND '110' : uses implicit conversion

After executing the ALTER TABLE command, you can add a new column called
ORDER_DATE to the ORDERS table.

The ORDER_DATE column should be empty for the ALTER TABLE command to
execute succsessfully.

ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.

The DESCRIBE command would still display the ORDER_DATE column.

Option A

Option B

Option C

Option D

The rollback generates an error.

No SQL statements are rolled back.

Only the DELETE statements are rolled back.

Only the second DELETE statement is rolled back.

Both the DELETE statements and the UPDATE statement are rolled back.

SALES1 has NOT NULL constraints on any selected columns which had those constraints in the
SALES table.

SALES1 is created with 55,000 rows.

SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those
constraints in the SALES table.

SALES1 is created with no rows.

SALES1 is created with 1 row.

adding a column constraint when inserting a row into a table

adding a column with a default value when inserting a row into a table

removing all data only from one single column on which a unique constraint is defined

removing all data only from one single column on which a primary key constraint is
defined

Line 5

Line 3

Line 7

Line 8

A role is owned by the user who created it.

A role can contain a combination of several privileges and roles.

System privileges always set privileges for an entire database.

A user has all object privileges for every object in their schema by default.

All roles are owned by the SYS schema.