Test Bank For Essentials of Database Management 1st Edition
By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman
9780133405682 Chapter 1-9 Complete Guide .
The ________ is the structure that contains descriptions of objects such as tables and views created
by users.
A) SQL
B) schema
C) catalog
D) master view - ANSWER: B) schema
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: C) create view
The first in a series of steps to follow when creating a table is to:
A) identify columns that must be unique.
B) identify each attribute and its characteristics.
C) create an index.
D) identify columns that must be null. - ANSWER: B) identify each attribute and its characteristics.
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: C) Alters the
Customer_T table, and adds a field called "Type"
What does the following SQL command do?
insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');
A) Adds a new record to the Customer_T
B) Creates the Customer_T table
C) Deletes the Customer_T table
D) Updates the Customer_T table - ANSWER: A) Adds a new record to the Customer_T
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) None of the above. - ANSWER: B) You must specify the fields to insert if you are only inserting
some of the fields.
, 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) None of the above - ANSWER: A) Deletes all records from customer_t where the state is equal to HI
What does the following SQL statement do?
Update Product_T
Set Unit_Price = 775
Where Product_ID = 7
A) Changes the price of a unit called Product_T to 7
B) Changes the unit price of Product 7 to 775
C) Changes the length of the Unit_Price field to 775
D) Updates the Product_T table to have a unit price of 775 - ANSWER: B) Changes the unit price of
Product 7 to 775
In an SQL statement, which of the following parts states the conditions for row selection?
A) Select
B) From
C) Where
D) Group By - ANSWER: C) Where
What does the following SQL statement do?
Select * From Customer Where Cust_Type = "Best"
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
B) Selects the "*" field from the Customer table for each row with a customer labeled "Best"
C) Selects fields with a "*" in them from the Customer table
D) Selects all the fields from the Customer table for each row with a customer labeled "*" - ANSWER:
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
What result will the following SQL statement produce?
Select Avg(standard_price) as average from Product_V;
A) The average of all products in Product_V
B) The average Standard_Price of all products in Product_V
C) The average price of all products
D) None of the above - ANSWER: B) The average Standard_Price of all products in Product_V
Which of the following questions is answered by the SQL statement?
Select Count (Product_Description) from Product_T;
A) How many products are in the table Product_T?
B) How many products have product descriptions in the Product Table?
C) How many characters are in the field name "Product_Description"?
D) How many different columns named "Product_Description" are there in table Product_T? -
ANSWER: B) How many products have product descriptions in the Product Table?
By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman
9780133405682 Chapter 1-9 Complete Guide .
The ________ is the structure that contains descriptions of objects such as tables and views created
by users.
A) SQL
B) schema
C) catalog
D) master view - ANSWER: B) schema
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: C) create view
The first in a series of steps to follow when creating a table is to:
A) identify columns that must be unique.
B) identify each attribute and its characteristics.
C) create an index.
D) identify columns that must be null. - ANSWER: B) identify each attribute and its characteristics.
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: C) Alters the
Customer_T table, and adds a field called "Type"
What does the following SQL command do?
insert into Customer_T values (001,'John Smith','231 West St','Boston','MA','02115');
A) Adds a new record to the Customer_T
B) Creates the Customer_T table
C) Deletes the Customer_T table
D) Updates the Customer_T table - ANSWER: A) Adds a new record to the Customer_T
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) None of the above. - ANSWER: B) You must specify the fields to insert if you are only inserting
some of the fields.
, 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) None of the above - ANSWER: A) Deletes all records from customer_t where the state is equal to HI
What does the following SQL statement do?
Update Product_T
Set Unit_Price = 775
Where Product_ID = 7
A) Changes the price of a unit called Product_T to 7
B) Changes the unit price of Product 7 to 775
C) Changes the length of the Unit_Price field to 775
D) Updates the Product_T table to have a unit price of 775 - ANSWER: B) Changes the unit price of
Product 7 to 775
In an SQL statement, which of the following parts states the conditions for row selection?
A) Select
B) From
C) Where
D) Group By - ANSWER: C) Where
What does the following SQL statement do?
Select * From Customer Where Cust_Type = "Best"
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
B) Selects the "*" field from the Customer table for each row with a customer labeled "Best"
C) Selects fields with a "*" in them from the Customer table
D) Selects all the fields from the Customer table for each row with a customer labeled "*" - ANSWER:
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
What result will the following SQL statement produce?
Select Avg(standard_price) as average from Product_V;
A) The average of all products in Product_V
B) The average Standard_Price of all products in Product_V
C) The average price of all products
D) None of the above - ANSWER: B) The average Standard_Price of all products in Product_V
Which of the following questions is answered by the SQL statement?
Select Count (Product_Description) from Product_T;
A) How many products are in the table Product_T?
B) How many products have product descriptions in the Product Table?
C) How many characters are in the field name "Product_Description"?
D) How many different columns named "Product_Description" are there in table Product_T? -
ANSWER: B) How many products have product descriptions in the Product Table?
