Deck 6: Updating Data

Question 1

You cannot commit and roll back data in SQL Server.

Answer 1

False

Question 2

You use the APPEND command to add additional rows to tables.

Answer 2

False

Question 3

Updates become permanent automatically when you exit from the DBMS.

Answer 3

True

Question 4

In SQL Server, the word NULL appears in the results when a column contains a null value.

Question 5

When necessary, include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

Question 6

The command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

Question 7

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

Question 8

You cannot use a compound condition with an UPDATE command.

Question 9

If the Autocommit mode is turned off, you can cancel updates at any time during your current work session.

Question 10

Access does not support the COMMIT or ROLLBACK commands.

Question 11

You can use the existing value in a column and a calculation to update a value.

Question 12

If you change the value of a column to NULL, you must enclose the NULL value in single quotation marks.

Question 13

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

Question 14

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

Question 15

If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.

Question 16

By default, Oracle commits each action query as soon as the user executes the query.

Question 17

The data stored in tables changes only infrequently.

Question 18

One of the nicest features of a relational DBMS, such as Oracle, is the ease with which you can change table structures.

Question 19

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

Question 20

In a transaction, it is acceptable if some steps fail.

Question 21

In Access, use the Documenter tool to show the layout of a table.

Question 22

In some cases, you might need to change a table's structure in ways that are beyond the capabilities of your DBMS. When that happens, use the RESTRUCTURE command to redesign the table.

Question 23

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.

A) Execute
B) Run
C) Autocommit
D) Enabled

Question 24

There are table structure changes that are beyond the capabilities of SQL.

Question 25

To add a new column, use the ADD COLUMN clause of the ALTER TABLE command.

Question 26

To add data from an existing table to a new table, use a SELECT command in a(n) ____ command.

A) SET
B) ADD
C) INSERT
D) UPDATE

Question 27

In Oracle 10g, a null value is displayed as a hyphen.

Question 28

When you add a new column to a table, the default for Oracle, SQL Server, and Access is to accept null values.

Question 29

You can increase the length of column but you cannot decrease the length of a column.

Question 30

Access does not support the ____ data type.

A) DECIMAL
B) CURRENCY
C) CHAR
D) INT

Question 31

If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.

A) UPDATE
B) ROLL
C) COMMIT
D) SAVE

Question 32

The DROP TABLE command creates an empty table.

Question 33

You cannot change the characteristics of existing columns.

Question 34

If you decrease the size of a column, it is possible to lose some data currently in the column.

Question 35

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

Question 36

If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.

A) UPDATE
B) REVERSE
C) ROLLBACK
D) ROLL

Question 37

In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.

A) Transaction
B) Autocommit
C) Permanent
D) Temporary

Question 38

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

Question 39

You can use the ____ command to create a new table using data in an existing table.

A) CREATE TABLE
B) NEW TABLE
C) UPDATE
D) ALTER TABLE

Question 40

To change rows for which a specific condition is true, use the ____ command

A) CHANGE
B) MODIFY
C) UPDATE
D) ALTER

Question 41

In Oracle, use the ____ command to display the structure of a table.

A) SHOW TABLE
B) SHOW LAYOUT
C) DESCRIBE
D) DISPLAY LAYOUT

Question 42

Which of the following commands executes a rollback?

A) ROLLBACK TABLE;
B) ROLLBACK;
C) ROLLBACK ALL;
D) ROLLBACK DB;

Question 43

The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.

Question 44

During your current work session you can save your changes immediately by executing the ____________________ command.

Question 45

The ____ command is permanent.

A) SELECT
B) COMMIT
C) SAVE
D) UPDATE

Question 46

The ROLLBACK command reverses changes made to the ____________________ only.

Question 47

A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.

A) procedure
B) transaction
C) program
D) method

Question 48

You use the ____________________ command to remove rows from a table.

Question 49

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) ADD
B) MODIFY
C) UPDATE
D) NULL

Question 50

In SQL, use the ____ data type for variable-length character columns.

A) TEXT
B) VARCHAR
C) VARIABLE
D) CHARLENGTH

Question 51

To sort rows in a specific order, use the ____________________ clause with the desired sort key(s).

Question 52

Which of the following is a valid SQL command?

A) DROP TABLE LEVEL1_CUSTOMER;
B) DROP LEVEL1_CUSTOMER;
C) DELETE LEVEL1_CUSTOMER;
D) All of the above

Question 53

Which of the following is a valid SQL command?

A) COMMIT TABLE;
B) COMMIT CHANGES;
C) COMMIT DB;
D) COMMIT;

Question 54

If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.

A) NOT NULL
B) NULL
C) CHAR
D) NUMBER

Question 55

By placing a(n) ____________________ command in an INSERT command, you can add the query results to a table.

Question 56

What happens if you run a DELETE command that does not contain a WHERE clause?

A) The table will be deleted.
B) All rows will be deleted from the table.
C) All values would be replaced by nulls.
D) None of the above.

Question 57

If you decide that you do not want to save the changes you have made during your current work session, you can reverse the changes by executing the ____________________ command.

Question 58

You can use the ____ command to delete an entire table and its data.

A) ROLLBACK
B) DELETE TABLE
C) DROP TABLE
D) DELETE

Question 59

To delete data from the database, use the ____ command.

A) ROLLBACK
B) COMMIT
C) DELETE
D) UPDATE

Question 60

A(n) ____________________ is a logical unit of work.

Question 61

The ADD clause consists of the word ADD followed by the name of the ____________________ to be added, followed by the characteristics.

Question 62

Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command.

Question 63

Describe the format for the UPDATE command.

Question 64

With SQL, you can change a table's structure by using the ____________________ command.

Question 65

In a transaction, if any update cannot be completed, execute the ____________________ command and discontinue the updates for the current transaction.

Question 66

You can delete a table that is no longer needed by using the ____________________ TABLE command.

Question 67

In Oracle, use the ____________________ command to display the structure of a table.

Question 68

In a transaction, if you can complete all updates successfully, execute the ____________________ command after completing the final update.

Question 69

The format for the ALTER TABLE command is the words ALTER TABLE followed by the name of the ____________________ to be altered, followed by an appropriate clause.

Question 70

Describe the format of the ALTER TABLE command to add a new column.

Question 71

How can you use the COMMIT and ROLLBACK commands to support transactions?

Question 72

To change a column that currently rejects null values so that it accepts null vlaues, use the ____________________ clause in the ALTER TABLE command.

Question 73

To add a new column, use the ____________________ clause of the ALTER TABLE command.

Question 74

If you specified ____________________ for the column when you created the table, then changing a value in a column to null is prohibited.

Question 75

You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.