A Guide to SQL, Ninth Edition Solutions 6-1
4. UPDATE
8. Before beginning the updates for a transaction, commit any previous updates by executing the
COMMIT command. Complete the updates for the transaction. If any update cannot be
9. The clause is SET followed by the column name, followed by an equals sign (=) and the word
11. In Oracle, the ALTER TABLE command with the MODIFY clause. In SQL Server, the ALTER
13. [Critical Thinking] A make table query is a query that allows you to create a table from another
Answers to TAL Distributors Exercises
1.
CREATE TABLE NONGAME
(ITEM_NUM CHAR(4) PRIMARY KEY,
DESCRIPTION CHAR(30),
A Guide to SQL, Ninth Edition Solutions 6-2
2.
SELECT *
FROM NONGAME;
3.
UPDATE NONGAME
4.
UPDATE NONGAME
A Guide to SQL, Ninth Edition Solutions 6-3
FROM NONGAME;
5.
INSERT INTO NONGAME
6.
DELETE FROM NONGAME
7.
UPDATE NONGAME
8.
ALTER TABLE NONGAME
9.
ALTER TABLE NONGAME
MODIFY DESCRIPTION CHAR(40);
10.
DROP TABLE NONGAME;
11. [Critical Thinking]
Answers to Colonial Adventure Tours Exercises
1. In Oracle and SQL Server the command is:
CREATE TABLE PADDLING
(TRIP_ID DECIMAL(3,0) PRIMARY KEY,
TRIP_NAME CHAR(75),
2.
INSERT INTO PADDLING
3.
UPDATE PADDLING
4.
INSERT INTO PADDLING
5.
DELETE FROM PADDLING
6.
UPDATE PADDLING
7.
ALTER TABLE PADDLING
8.
UPDATE PADDLING
9.
ALTER TABLE PADDLING
MODIFY SEASON CHAR(25);
10.
ALTER TABLE PADDLING
MODIFY DIFFICULTY_LEVEL NOT NULL;
12. [Critical Thinking]
CREATE TABLE PADDLING
(TRIP_ID DECIMAL(3,0) PRIMARY KEY,
TRIP_NAME VARCHAR(75),
Answers to Solmaris Condominium Group Exercises
1.
CREATE TABLE LARGE_CONDO
(LOCATION_NUM DECIMAL(2,0),
UNIT_NUM CHAR(3),
2.
INSERT INTO LARGE_CONDO
3.
UPDATE LARGE_CONDO
4.
UPDATE LARGE_CONDO
5.
INSERT INTO LARGE_CONDO
6.
DELETE FROM LARGE_CONDO
7.
UPDATE LARGE_CONDO
8.
ALTER TABLE LARGE_CONDO
9.
UPDATE LARGE_CONDO
10.
ALTER TABLE LARGE_CONDO
MODIFY CONDO_FEE NOT NULL;
11.
DROP TABLE LARGE_CONDO;
12. [Critical Thinking] Students also could use SMALLINT.
CREATE TABLE LARGE_CONDO
(LOCATION_NUM INTEGER,
