463

In the figure shown below, which of the following is true? A) A person can marry at most one person. B) A person has to be married. C) A person can marry more than one person, but that person can only be married to one person. D) A person can marry more than one person.

A) A person can marry at most one person.

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

A) Adds a new record to the Customer_T

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

A) Changes the price of a unit called Product_T to 7

Which of the following counts ONLY rows that contain a value? A) Count B) Count(*) C) Tally(*) D) Checknum

A) Count

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

A) Deletes all records from customer_t where the state is equal to HI

In the following diagram, which answer is true? A) Each employee can supervise one employee, no employees or many employees. B) Each employee can manage many departments. C) Each employee works in more than one department. D) Each employee was fired.

A) Each employee can supervise one employee, no employees or many employees.

In the following diagram, which of the answers below is true? A) Each patient has one or more patient histories. B) Each patient has one and only one visit. C) Each patient history belongs to zero and one patient. D) Each patient history belongs to many patients.

A) Each patient has one or more patient histories.

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 "*"

A) Selects all the fields from the Customer table for each row with a customer labeled "Best"

What results will be produced by the following SQL query? Select sum(standard_price) as Total_Price from Product_V where Product_Type = 'WOOD'; A) The total price of all products that are of type wood B) The total price of all products C) The Standard_Price of the first wood product in the table D) The Standard_Price of any wood product in the table

A) The total price of all products that are of type wood

In the figure below, which attribute is derived? Employee Employee_ID Employee_Name Date_Employed {Skill} [Years_Employed] A) Years_Employed B) Employee_ID C) Skill D) Address

A) Years_Employed

A person's name, birthday, and social security number are all examples of: A) attributes. B) entities. C) relationships. D) descriptors.

A) attributes.

The UNION clause is used to: A) combine the output from multiple queries into a single result table. B) join two tables together to form one table. C) find all rows that do not match in two tables. D) find all rows that are in one table, but not the other

A) combine the output from multiple queries into a single result table.

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule. A) disjoint B) specialization C) generalization D) overlap

A) disjoint

Customers, cars, and parts are examples of: A) entities. B) attributes. C) cardinals. D) relationships.

A) entities.

Program-data dependence is caused by: A) file descriptions being stored in each database application. B) data descriptions being stored on a server. C) data descriptions being written into programming code. D) data cohabiting with programs.

A) file descriptions being stored in each database application

When all multivalued attributes have been removed from a relation, it is said to be in: A) first normal form. B) second normal form. C) Boyce-Codd normal form. D) third normal form.

A) first normal form.

A form of database specification which maps conceptual requirements is called: A) logical specifications. B) response specifications. C) security specifications. D) physical specifications.

A) logical specifications.

A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A) logically

What will be returned when the following SQL statement is executed? Select driver_no,count(*) as num_deliveries from deliveries group by driver_no; A) A listing of all drivers, sorted by driver number B) A listing of each driver as well as the number of deliveries that he or she has made C) A count of all of the deliveries made by all drivers D) An error message

B) A listing of each driver as well as the number of deliveries that he or she has made

What will be returned when the following SQL statement is executed? Select driver_no, count(*) as num_deliveries from deliveries where state = 'MA' group by driver_no; A) A listing of all drivers who made deliveries to state = 'MA', sorted by driver number B) A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state C) A count of all of the deliveries made to state = 'MA' by all drivers D) An error message will be generated

B) A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state

In the figure below, Customer_ID in the CUSTOMER Table is which type of key? A) Composite B) Candidate C) Standard D) Grouped

B) Candidate

The first part of an SQL query to be read is the ________ statement. A) SELECT B) FROM C) WHERE D) ORDER BY

B) FROM

Which of the following can produce scalar and vector aggregates? A) ORDER BY B) GROUP BY C) HAVING D) SORT

B) GROUP BY

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?

B) How many products have product descriptions in the Product Table?

In the figure below, what type of relationship do the relations depict? A) Strong entity/weak entity B) One-to-many C) Ternary D) Many-to-many

B) One-to-many

________ database specification indicates all the parameters for data storage that are then input to database implementation. A) Logical B) Physical C) Schematic D) Conceptual

B) Physical

________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Entities B) Relationships C) Lines D) Ties

B) Relationships

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? A) First B) Second C) Third D) Fourth

B) Second

Which of the following will produce the minimum of all standard prices? A) Select standard_price from Product_V where Standard_Price = min; B) Select min(standard_price) from Product_V; C) Select Standard_Price from min(Product_V); D) Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

B) Select min(standard_price) from Product_V;

Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Megatype B) Supertype C) Subgroup D) Class

B) Supertype

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) The mode of all prices

B) The average Standard_Price of all products in Product_V

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

B) You must specify the fields to insert if you are only inserting some of the fields.

The following figure shows an example of: Employee---------<Dependent A) a one-to-many relationship. B) a strong entity and its associated weak entity. C) a co-dependent relationship. D) a double-walled relationship.

B) a strong entity and its associated weak entity.

In order for two queries to be UNION-compatible, they must: A) both have the same number of lines in their SQL statements. B) both output compatible data types for each column and return the same number of rows. C) both return at least one row. D) both return exactly one row.

B) both output compatible data types for each column and return the same number of rows.

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) degree B) cardinality constraint C) counter constraint D) limit

B) cardinality constraint

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n): A) composite attribute. B) composite identifier. C) identifying attribute. D) relationship identifier.

B) composite identifier.

A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key.

B) composite key.

A ________ is a temporary table used in the FROM clause of an SQL query. A) correlated subquery B) derived table C) view table D) trigger

B) derived table

The normal form which deals with multivalued dependencies is called: A) fifth normal form. B) fourth normal form. C) Boyce-Codd normal form. D) sixth normal form.

B) fourth normal form.

Older systems that often contain data of poor quality are called ________ systems. A) controlled B) legacy C) database D) mainframe

B) legacy

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong

B) many-to-many

Data is represented in the form of: A) data trees. B) tables. C) data notes. D) chairs.

B) tables.

All of the following are guidelines for better query design EXCEPT: A) understand how indexes are used in query processing. B) use a lot of self-joins. C) write simple queries. D) retrieve only the data that you need

B) use a lot of self-joins.

An entity type whose existence depends on another entity type is called a ________ entity. A) strong B) weak C) codependent D) variant

B) weak

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"

C) Alters the Customer_T table, and adds a field called "Type"

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called: A) fifth normal form. B) fourth normal form. C) Boyce-Codd normal form. D) sixth normal form.

C) Boyce-Codd normal form.

Which of the following finds all groups meeting stated conditions? A) Select B) Where C) Having D) Find

C) Having

39) An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: A) CASE. B) CAD. C) RAD. D) MST.

C) RAD.

In the following diagram, what type of relationship is depicted? A) Unary B) Binary C) Ternary D) Quad

C) Ternary

In an SQL statement, which of the following parts states the conditions for row selection? A) Select B) From C) Where D) Group By

C) Where

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase. A) planning B) design C) analysis D) implementation

C) analysis

The property by which subtype entities possess the values of all attributes of a supertype is called: A) hierarchy reception. B) class management. C) attribute inheritance. D) generalization.

C) attribute inheritance.

The command for creating a database is: A) create table. B) create view. C) create schema. D) create authorization.

C) create 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

C) create view

A primary key whose value is unique across all relations is called a(n): A) global primary key. B) inter-table primary key. C) enterprise key. D) foreign global key.

C) enterprise key.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute. B) link key. C) foreign key. D) foreign attribute.

C) foreign key.

All of the following are the main goals of normalization EXCEPT: A) minimize data redundancy. B) simplify the enforcement of referential integrity. C) maximize storage space. D) make it easier to maintain data.

C) maximize storage space.

An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key.

C) primary key.

40) One of the most popular RAD methods is: A) automated design. B) structured walkthrough. C) prototyping. D) crafting.

C) prototyping.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n): A) entity. B) relationship. C) relation. D) association.

C) relation.

The following figure is an example of: A) partial specialization. B) completeness. C) total specialization. D) disjointness.

C) total specialization.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) enterprise view B) reporting document C) user view D) user snapshot

C) user view

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: A) using the if-then-else construct. B) using the immediate if statement. C) using the CASE keyword in a statement. D) using a subquery.

C) using the CASE keyword in a statement.

The last part of an SQL query to be read is the ________ statement. A) SELECT B) FROM C) WHERE D) ORDER BY

D) ORDER BY

In the figure below, what type of key is depicted? A) Primary B) Recursive primary C) Composite D) Recursive foreign

D) Recursive foreign

The ________ operator is used to combine the output from multiple queries into a single result table. A) INTERSECT B) DIVIDE C) COLLATE D) UNION

D) UNION

A ________ defines or constrains some aspect of the business. A) business constraint B) business structure C) business control D) business rule

D) business rule

A graphical system used to capture the nature and relationships among data is called a(n): A) XML data model. B) hypertext graphic. C) relational database D) data model.

D) data model.

An attribute that can be calculated from related attribute values is called a ________ attribute. A) simple B) composite C) multivalued D) derived

D) derived

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. A) optional B) unidirectional C) mandatory link D) mandatory one

D) mandatory one