EGR 325 PRACTICE FINAL EXAM 1-48 WITH COMPLETED
SOLUTIONS 2026
is a set of commands used to update and query a database.
a) DML
b) DDL
c) DCL
d) DPL - ANSWER DML
DDL is typically used during which phase of the development process? a) Implementation
b) Physical design
c) Analysis
d) Evaluation - ANSWER Implementation or
Physical design
The SQL command defines a logical table from one or more tables or views.
a) create table
b) alter table
c) create view
d) create relationship - ANSWER create view
Any create command may be reversed by using a(n) command.
a) undo
b) drop
c) delete
d) unpack - ANSWER drop
The SQL command adds one or more new columns to a table.
a) create table
, b) alter table
c) create view
d) create relationship - ANSWER alter table
What does the following SQL statement do?
Alter Table Customer_T
Add (Type Varchar (2));
a) Alters the Customer_T table to accept Type 2 Varchars
b) Alters the Customer_T table to be a Type 2 Varchar
c) Alters the Customer_T table, and adds a field called "Type"
d) Alters the Customer_T table by adding a 2-byte field called "Varchar" - ANSWER Alters
the Customer_T table, and adds a field called "Type"
Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the
following insert command not work?
insert into store values ('234 Park Street')
a) It would work just fine.
b) You must specify the fields to insert if you are only inserting some of the fields.
c) There is no table keyword.
d) Insert into should be INSERT to. - ANSWER You must specify the fields to insert if you are
only inserting some
What does the following SQL statement do? Delete from Customer_T where state = 'HI';
a) Deletes all records from customer_t where the state is equal to HI
b) Removes the Customer_T table from the database
c) Deletes all records from the Customer_T table
d) Doesn't delete anything because of a syntax error - ANSWER Deletes all records from
customer_t where the state is equal to HI
SOLUTIONS 2026
is a set of commands used to update and query a database.
a) DML
b) DDL
c) DCL
d) DPL - ANSWER DML
DDL is typically used during which phase of the development process? a) Implementation
b) Physical design
c) Analysis
d) Evaluation - ANSWER Implementation or
Physical design
The SQL command defines a logical table from one or more tables or views.
a) create table
b) alter table
c) create view
d) create relationship - ANSWER create view
Any create command may be reversed by using a(n) command.
a) undo
b) drop
c) delete
d) unpack - ANSWER drop
The SQL command adds one or more new columns to a table.
a) create table
, b) alter table
c) create view
d) create relationship - ANSWER alter table
What does the following SQL statement do?
Alter Table Customer_T
Add (Type Varchar (2));
a) Alters the Customer_T table to accept Type 2 Varchars
b) Alters the Customer_T table to be a Type 2 Varchar
c) Alters the Customer_T table, and adds a field called "Type"
d) Alters the Customer_T table by adding a 2-byte field called "Varchar" - ANSWER Alters
the Customer_T table, and adds a field called "Type"
Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the
following insert command not work?
insert into store values ('234 Park Street')
a) It would work just fine.
b) You must specify the fields to insert if you are only inserting some of the fields.
c) There is no table keyword.
d) Insert into should be INSERT to. - ANSWER You must specify the fields to insert if you are
only inserting some
What does the following SQL statement do? Delete from Customer_T where state = 'HI';
a) Deletes all records from customer_t where the state is equal to HI
b) Removes the Customer_T table from the database
c) Deletes all records from the Customer_T table
d) Doesn't delete anything because of a syntax error - ANSWER Deletes all records from
customer_t where the state is equal to HI
