essentials of database management 1st edition by j
essentials of database management
Connected book
Book Title:
Author(s):
Edition:
ISBN:
Edition:
More summaries for
Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 9780133405682 Chapter 1-9 Complete Guide .
Essentials of Database Management 1st Edition By Jeffrey A. Hoffer; Heikki Topi; Ramesh Venkataraman 9780133405682 Chapter 1-9 Complete Guide .
Test Bank for Essentials of Database Management, 1st Edition by Jeffrey A. Hoffer, 9780133405682, Covering Chapters 1-9 | Includes Rationales
All for this textbook (8)
Written for
Essentials of Database Management 1st Edition By J
All documents for this subject (3)
1
review
By: tutorsection1 • 1 month ago
Seller
Follow
phinta004
Reviews received
Content preview
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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller phinta004. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R339,02. You're not tied to anything after your purchase.
