ITD-132 Unit 3 set 3 – Flashcards

Access does not support the ____ data type.​ a. ​CURRENCY b. ​DECIMAL c. INT d. ​CHAR

To change rows for which a specific condition is true, use the ____ command​ a. ​CHANGE b. MODIFY c. UPDATE d. ​ALTER

If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.​ a. ​COMMIT b. SAVE c. ROLL d. UPDATE

In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.​ a. ​Temporary b. Permanent c. ​Autocommit d. Transaction

Which of the following commands executes a rollback?​ a. ​ROLLBACK; b. ROLLBACK TABLE; c. ROLLBACK DB; d. ROLLBACK ALL;

The ____ command is permanent.​ a. SAVE b. ​SELECT c. COMMIT d. ​UPDATE

To delete rows from the database, use the ____ command.​ a. ROLLBACK b. COMMIT c. ​DELETE d. UPDATE

If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.​ a. NUMBER b. CHAR c. ​NULL d. NOT NULL

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values.​ a.​MODIFY b. ​UPDATE c. NULL d. ADD

You can use the ____ command to delete an entire table and its data.​ a. ​DELETE b. ​DROP TABLE c. ROLLBACK d. DELETE TABLE

​You can create a new table using data in an existing table. True False

​To verify that the correct change was made to data in a table, use the DISPLAY command. True False

​Access does not support the COMMIT or ROLLBACK commands. True False

​You can use REMOVE ROW to remove a row from a table. True False

​In Oracle 11 g, a null value is displayed as a hyphen. True False

​In SQL Server, execute the sp_columns command to list all the columns in a table. True False

​To permanently remove both a table and its data, you must issue both a DROP TABLE command and a DELETE command. True False