A Guide to SQL Study Set 2

Computing

Quiz 6 :

Updating Data

Quiz 6 :

Updating Data

Question Type
search
arrow
To permanently remove both a table and its data, you must execute both a DROP TABLE command and a DELETE command.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
How do you use data from certain columns of an existing table to populate a new table with a matching structure?
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
You can use the existing value in a column and a calculation to update a value.
Free
True False
Answer:

Answer:

True

Tags
Choose question tag
close menu
arrow
You can use the APPEND command to add additional rows to tables.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Which command(s) can you use to delete an entire table and its data?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
To add data from an existing table to a new table, use a SELECT command in a(n) _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Changing a value in a table column to null is prohibited if, when you created the table, you specified _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which command can you use to change rows for which a specific condition is true?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The DROP TABLE command creates an empty table.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Which command is used to display the structure of a table in MySQL?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What command is used to delete rows from the database?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Using SQL, you can increase the length of an existing table column but you cannot decrease the length of a column.
True False
Answer:
Tags
Choose question tag
close menu
arrow
If you have not run the COMMIT command, you can reverse all updates made during the current work session by executing the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What happens if you run a DELETE command that does not contain a WHERE clause?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which command can you use to create a new table using data in an existing table?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A logical unit of work, often conceptualized as a sequence of steps that accomplish a single task, is called a _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following commands executes a rollback?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Once you have verified that the update you made is correct, you can make the update permanent by using the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which clause can you use with the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The default transaction mode in Oracle, which commits each action query as soon as the user executes the query, is _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 34