EGR 325 PRACTICE FINAL EXAM 1-48 WITH COMPLETED SOLUTIONS 2026

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