Deck 6: Updating Data

Question 1

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

Answer 1

True

Question 2

You cannot commit and roll back data in SQL Server.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

Updates become permanent automatically when you exit from the DBMS.

Question 5

Access does not support the COMMIT or ROLLBACK commands.

Question 6

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

Question 7

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

Question 8

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

Question 9

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 10

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

Question 11

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

Question 12

The data stored in tables changes only infrequently.

Question 13

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

Question 14

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 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

You cannot use a compound condition with an UPDATE command.

Question 20

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

Question 21

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

Question 22

The DROP TABLE command creates an empty table.

Question 23

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 24

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

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

Question 25

____ 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 26

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

Question 27

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

Question 28

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 29

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 30

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 31

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

Question 32

You cannot change the characteristics of existing columns.

Question 33

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 34

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

Question 35

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

Question 36

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

Question 37

Access does not support the ____ data type.​

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

Question 38

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

Question 39

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 40

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

Question 41

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 42

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

Question 43

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

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

Question 44

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

Question 45

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 46

The ROLLBACK command reverses changes made to the ____________________ only.​

Question 47

Which of the following is a valid SQL command?​

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

Question 48

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

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

Question 49

The format for the UPDATE command is the word UPDATE,followed by the name of the table to be updated.The next portion of the command consists of the word ____________________,followed by the name of the column to be updated,an equals sign,and the new value.​

Question 50

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

Question 51

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 52

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

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

Question 53

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 54

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

Question 55

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

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

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

Which of the following commands executes a rollback?​

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

Question 58

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

Question 59

To delete rows from the database,use the ____ command.​

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

Question 60

The ____ command is permanent.​

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

Describe the format for the UPDATE command.​

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

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

Question 74

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

Question 75

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