Site hosted by Angelfire.com: Build your free website today!

 
Question 1 (Received 0 out of 0 points)


Question: Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?
Your answer: No response
Correct answer: All of the above.



Question 2 (Received 0 out of 0 points)


Question: When the primary key of one relation is placed in a second relation to represent a relationship, the attribute in the second relation is called a foreign key.
Your answer: No response
Correct answer: True



Question 3 (Received 0 out of 0 points)


Question: If the condition exists such that knowing the value of attribute X determines the value attribute Y, then attribute Y is functionally dependent on attribute X.
Your answer: No response
Correct answer: True



Question 4 (Received 0 out of 0 points)


Question: The component of a database that makes it self-describing is the ___________.
Your answer: No response
Correct answer: metadata



Question 5 (Received 0 out of 0 points)


Question: In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
Your answer: No response
Correct answer: False



Question 6 (Received 0 out of 0 points)


Question: Any table that meets the definition of a relation is said to be in second normal form.
Your answer: No response
Correct answer: False



Question 7 (Received 0 out of 0 points)


Question: The primary (or candidate) key of a relation functionally determines all the other attributes in the relation.
Your answer: No response
Correct answer: True



Question 8 (Received 0 out of 0 points)


Question: Databases are seldom used by individuals.
Your answer: No response
Correct answer: False



Question 9 (Received 0 out of 0 points)


Question: Since surrogate keys are used to uniquely identify rows, their values are normally displayed prominently on all forms and reports for the users to see.
Your answer: No response
Correct answer: False



Question 10 (Received 0 out of 0 points)


Question: MedicineCode --> (MedicineName, ShelfLife, Manufacturer, Dosage)

Given the functional dependency above, which of the following statements is not known to be true?
Your answer: No response
Correct answer: MedicineName is a determinant.



Question 11 (Received 0 out of 0 points)


Question: The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.
Your answer: No response
Correct answer: False



Question 12 (Received 0 out of 0 points)


Question: The purpose of a database is to help people keep track of things.
Your answer: No response
Correct answer: True



Question 13 (Received 0 out of 0 points)


Question: Which of the following terms is synonymous with ?tuple??
Your answer: No response
Correct answer: row



Question 14 (Received 0 out of 0 points)


Question: The relationship between two attributes which denotes that if the value of the first attribute is known, the value of the second attribute can be determined, is called a dependent entity.
Your answer: No response
Correct answer: False



Question 15 (Received 0 out of 0 points)


Question: A key that contains more than one attribute is called a(n) __________ key.
Your answer: No response
Correct answer: composite key



Question 16 (Received 0 out of 0 points)


Question: Which of the following is not true of UML?
Your answer: No response
Correct answer: UML is a subset of the E-R diagrams standard.



Question 17 (Received 0 out of 0 points)


Question: For a column to be defined as the primary key using the ALTER TABLE statement, the column must have been given the property NOT NULL.
Your answer: No response
Correct answer: True



Question 18 (Received 0 out of 0 points)


Question: To force the DBMS to remove duplicate rows from the results of a SQL SELECT query, the keyword DISTINCT must be used.
Your answer: No response
Correct answer: True



Question 19 (Received 0 out of 0 points)


Question: In SQL, the WHERE clause is used to specify which columns will be included in the result.
Your answer: No response
Correct answer: False



Question 20 (Received 0 out of 0 points)


Question: Which of the following is not true about primary keys?
Your answer: No response
Correct answer: Primary keys must be a single attribute.



Question 21 (Received 0 out of 0 points)


Question: When using SQL to create a table, a column is defined by declaring, in this order: data type, column name, and properties.
Your answer: No response
Correct answer: False



Question 22 (Received 0 out of 0 points)


Question: UML has quickly replaced the E-R Model as the most popular technique for creating data models.
Your answer: No response
Correct answer: False



Question 23 (Received 0 out of 0 points)


Question: Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?
Your answer: No response
Correct answer: DROP TABLE STUDENT;



Question 24 (Received 0 out of 0 points)


Question: If one instance of ENTITY B must be related to one and only one instance of ENTITY A, and one instance of ENTITY A may be related to many instances of ENTITY B, which of the following should be written in the relationship symbol of the figure below?
Your answer: No response
Correct answer: 1:N



Question 25 (Received 0 out of 0 points)


Question: Which of the following data types used in SQL would define a fixed-length text field of 10 characters?
Your answer: No response
Correct answer: char(10)



Question 26 (Received 0 out of 0 points)


Question: Data from a maximum of three tables can be combined through the use of subqueries in SQL.
Your answer: No response
Correct answer: False



Question 27 (Received 0 out of 0 points)


Question: Given only the excerpt of an E-R model shown below, which of the following is known to be true?
Your answer: No response
Correct answer: Many instances of ENTITY A may be related to one instance of ENTITY B.



Question 28 (Received 0 out of 0 points)


Question: The PRODUCT entity instance is the collection of all PRODUCT entity classes.
Your answer: No response
Correct answer: False



Question 29 (Received 0 out of 0 points)


Question: In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.
Your answer: No response
Correct answer: False



Question 30 (Received 0 out of 0 points)


Question: Which SQL keyword is used to eliminate duplicate rows in the results of a SQL SELECT query?
Your answer: No response
Correct answer: DISTINCT



Question 31 (Received 0 out of 0 points)


Question: Relationships with the degree 2 are often called binary relationships.
Your answer: No response
Correct answer: True



Question 32 (Received 0 out of 0 points)


Question: Which of the following is not one of the five SQL built-in functions?
Your answer: No response
Correct answer: MODE



Question 33 (Received 0 out of 0 points)


Question: Which of the following is not a standard data type used in SQL?
Your answer: No response
Correct answer: text



Question 34 (Received 0 out of 0 points)


Question: When an entity class has a relationship with itself, it is called a recursive relationship.
Your answer: No response
Correct answer: True



Question 35 (Received 0 out of 0 points)


Question: Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?
Your answer: No response
Correct answer: HAVING



Question 36 (Received 0 out of 0 points)


Question: To represent a many-to-many relationship in the relational model, an intersection relation is used.
Your answer: No response
Correct answer: True



Question 37 (Received 0 out of 0 points)


Question: Which of the following is not necessarily true of a relation that is in 4NF?
Your answer: No response
Correct answer: It is in DK/NF.



Question 38 (Received 0 out of 0 points)


Question: What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?
Your answer: No response
Correct answer: Phantom reads



Question 39 (Received 0 out of 0 points)


Question: To represent a many-to-many relationship in the relational model, a union relation is used.
Your answer: No response
Correct answer: False



Question 40 (Received 0 out of 0 points)


Question: What is the least restrictive isolation level that will prevent nonrepeatable reads?
Your answer: No response
Correct answer: Repeatable Read



Question 41 (Received 0 out of 0 points)


Question: The first step in representing entities using the relational model is to determine which identifier will be used as the key.
Your answer: No response
Correct answer: False



Question 42 (Received 0 out of 0 points)


Question: Given the 1:N recursive relationship shown in the figure indicating that a Member may sponsor many other members but a Member is sponsored by only one other Member, which of the following would represent the correct implementation? (PK = Primary Key)
Your answer: No response
Correct answer: MEMBER (MemberID(PK), Name, Phone, SponsoredBy)



Question 43 (Received 0 out of 0 points)


Question: The need to add the same data to multiple rows of a relation about one theme because the relation contains data about multiple themes is an example of an insertion anomaly.
Your answer: No response
Correct answer: True



Question 44 (Received 0 out of 0 points)


Question: R. Fagin defined the domain key / normal form, and a relation in this form has no anomalies.
Your answer: No response
Correct answer: True



Question 45 (Received 0 out of 0 points)


Question: The term DBA refers to ____________.
Your answer: No response
Correct answer: database administrator



Question 46 (Received 0 out of 0 points)


Question: A recursive relationship is a relationship among entities of the same class.
Your answer: No response
Correct answer: True



Question 47 (Received 0 out of 0 points)


Question: One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.
Your answer: No response
Correct answer: True



Question 48 (Received 0 out of 0 points)


Question: The recovery method where the database is restored using the saved data, and all transactions since the save are reapplied is called rollforward recovery.
Your answer: No response
Correct answer: True



Question 49 (Received 0 out of 0 points)


Question: Given the generic relation: GENERIC (PKey1, PKey2, Attribute1, Attribute2, Attribute3), and the functional dependencies: (PKey1, PKey2) --> Attribute1 and PKey2 --> (Attribute2, Attribute3), which of the following is true?
Your answer: No response
Correct answer: GENERIC is not fully normalized.



Question 50 (Received 0 out of 0 points)


Question: Which of the following is not a means of processing databases?
Your answer(s):
No response
Correct answer(s):
Programs coded in COBOL.
Internet applications using ASP.
Processed by stored procedures and triggers.
Programs coded in Java or C#.
All of the above are means of processing a database.



Question 51 (Received 0 out of 0 points)


Question: Given ENTITY A and ENTITY B shown in the figure, which of the following would display the correct placement of foreign keys in the relational model? (PK = Primary Key, FK = Foreign Key)
Your answer: No response
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B (Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))



Question 52 (Received 0 out of 0 points)


Question: Which of the following is a type of trigger than can be invoked in place of DBMS insert, update, or delete actions?
Your answer: No response
Correct answer: INSTEAD OF triggers



Question 53 (Received 0 out of 0 points)


Question: What is the least restrictive isolation level that will prevent dirty reads?
Your answer: No response
Correct answer: Read Committed



Question 54 (Received 0 out of 0 points)


Question: Only large database systems have a need for database administration.
Your answer: No response
Correct answer: False



Question 55 (Received 0 out of 0 points)


Question: Once a relation has been defined for an entity, it should be examined according to normalization criteria.
Your answer: No response
Correct answer: True



Question 56 (Received 0 out of 0 points)


Question: Database Administration is an important business function whose purpose is to manage the database to maximize its value to the organization.
Your answer: No response
Correct answer: True



Question 57 (Received 0 out of 0 points)


Question: If a weak entity is ID dependent but not existence dependent, it can be represented using the same techniques as a strong entity.
Your answer: No response
Correct answer: False



Question 58 (Received 0 out of 0 points)


Question: Which of the following is the first step in representing entities using the relational model?
Your answer: No response
Correct answer: Define a relation for each entity



Question 59 (Received 0 out of 0 points)


Question: From a pragmatic standpoint, the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.
Your answer: No response
Correct answer: True



Question 60 (Received 0 out of 0 points)


Question: A trigger is similar to a stored procedure, except that it is written to be invoked by the DBMS when a specified event occurs.
Your answer: No response
Correct answer: True



Question 61 (0 points possible)


Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours), write a SQL query statement that will list all rows and columns for which the maximum hours are in the range 100.0 to 150.0.
Your answer:
No response
Correct answer:


SELECT ProjectID, Name, Department, MaxHours

FROM PROJECT

WHERE MaxHours BETWEEN 100.0 AND 150.0;



[alternate answers]

SELECT *

FROM PROJECT

WHERE MaxHours BETWEEN 100.0 AND 150.0;



SELECT *

FROM PROJECT

WHERE MaxHours => 100.0

AND MaxHours =< 150.0;




Question 62 (0 points possible)


Question: Restaurant Meal Check
Determine the entities implied by the following, unnormalized table(s). Draw an appropriate E-R diagram.

Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number, Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description, (Menu Item Number, Item Name, Item Price)))

This document concerns meal check information. For a given meal check (identified by the check number), there will be a single server assigned to a single customer group (usually occupying a booth.) Each time a different group occupies the booth, there is a new session number (the session numbers start anew every day.) The server's number and name appear on the check as well as the meal (breakfast, lunch, dinner) and date. Also, there may be several different item orders appearing on the check for each of one or more guests (id'ed by seat number.) For each item order that appears, the item number, name, and price will be displayed. The price is from the current menu table.
Your answer:
No response
Correct answer:




Question 63 (0 points possible)


Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.

Be sure to do both parts a. and b. of this question.
Your answer:
No response
Correct answer:




Question 64 (0 points possible)


Question: Game Statistics
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Game Statistics(Game Number, Opponent, Game Date, (Referee Number, Referee Last Name, Penalties Called), (Player Number, Player Last Name, Game Points, Season Average Points, Career Average Points))

This table represents a game statistics summary for the school team. For a given game (identified by the unique game number), there will be a single opponent, but three referees. The school team will have at least 5 players in each and every game. The season and career scoring averages are only updated after each game, not during the game.
Your answer:
No response
Correct answer:


Question 1 (Received 0 out of 0 points)


Question: The DBMS translates requests into instructions for the computer operating system to read and write data in the database files.
Your answer: No response
Correct answer: True



Question 2 (Received 0 out of 0 points)


Question: STUDENT (SID, S-Name, Major, AdvisorID)
ADVISOR (AdvisorID, A-Name, Office, Phone)

Given the relations above such that each student is assigned to one advisor, which of the following is true?
Your answer: No response
Correct answer: AdvisorID is a foreign key.



Question 3 (Received 0 out of 0 points)


Question: Which of the following is not contained in the components of all databases?
Your answer: No response
Correct answer: application metadata



Question 4 (Received 0 out of 0 points)


Question: Candidate keys may or may not be unique.
Your answer: No response
Correct answer: False



Question 5 (Received 0 out of 0 points)


Question: Which of the following functional dependency diagrams accurately represents the following situation:
A campus has many buildings.
Each building has a unique name.
Each building has many rooms.
All rooms in any given building are numbered sequentially starting at ?101?.
Each room has a certain capacity although many rooms in the same building or different buildings may have the same capacity.
Each room is assigned to a single department.
A department may have many rooms in one or more buildings, each with the same or different capacities.
Your answer: No response
Correct answer: (BuildingName, RoomNumber) --> (Capacity, Department)



Question 6 (Received 0 out of 0 points)


Question: In a database, tables are related to each other by ___________.
Your answer: No response
Correct answer: placing row identifiers where necessary



Question 7 (Received 0 out of 0 points)


Question: Since surrogate keys are used to uniquely identify rows, their values are normally displayed prominently on all forms and reports for the users to see.
Your answer: No response
Correct answer: False



Question 8 (Received 0 out of 0 points)


Question: During the normalization process, the remedy for a relation that is not well-formed is to ___________.
Your answer: No response
Correct answer: break it into two or more relations that are well-formed



Question 9 (Received 0 out of 0 points)


Question: When the primary key of one relation is placed into a second relation, it is called a _________.
Your answer: No response
Correct answer: foreign key



Question 10 (Received 0 out of 0 points)


Question: A key that contains two or more attributes is called a foreign key.
Your answer: No response
Correct answer: False



Question 11 (Received 0 out of 0 points)


Question: Most organizations create and use their own database management system (DBMS) products.
Your answer: No response
Correct answer: False



Question 12 (Received 0 out of 0 points)


Question: To create a well-formed relation through normalization, every determinant must be a candidate key.
Your answer: No response
Correct answer: True



Question 13 (Received 0 out of 0 points)


Question: A key must be unique.
Your answer: No response
Correct answer: False



Question 14 (Received 0 out of 0 points)


Question: Null values can cause problems because they are ambiguous.
Your answer: No response
Correct answer: True



Question 15 (Received 0 out of 0 points)


Question: If the condition exists such that knowing the value of attribute X determines the value attribute Y, then attribute Y is functionally dependent on attribute X.
Your answer: No response
Correct answer: True



Question 16 (Received 0 out of 0 points)


Question: The basic format for documenting cardinalities in UML is x..y, where x is the maximum cardinality and y is the minimum cardinality.
Your answer: No response
Correct answer: False



Question 17 (Received 0 out of 0 points)


Question: To force the DBMS to remove duplicate rows from the results of a SQL SELECT query, the keyword DISTINCT must be used.
Your answer: No response
Correct answer: True



Question 18 (Received 0 out of 0 points)


Question: The SUM built-in function in SQL is used to total the values in a numeric column.
Your answer: No response
Correct answer: True



Question 19 (Received 0 out of 0 points)


Question: Conditions after the WHERE require single quotes around value for columns that have which data type?
Your answer: No response
Correct answer: Both a and b



Question 20 (Received 0 out of 0 points)


Question: Which of the following is true about identifiers of entities?
Your answer: No response
Correct answer: The value of an identifier may identify a set of entity instances.



Question 21 (Received 0 out of 0 points)


Question: Which of the following is not a source for user requirements during the requirements stage of developing a database system?
Your answer: No response
Correct answer: All of the above are sources for user requirements.



Question 22 (Received 0 out of 0 points)


Question: Which type of join, although not included in standard SQL, was created to allow unmatched rows to appear in the result of a join operation?
Your answer: No response
Correct answer: OUTER JOIN



Question 23 (Received 0 out of 0 points)


Question: The data model is a representation of the content, relationships, and constraints of the data needed to support the system requirements.
Your answer: No response
Correct answer: True



Question 24 (Received 0 out of 0 points)


Question: Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.
Your answer: No response
Correct answer: False



Question 25 (Received 0 out of 0 points)


Question: One type of strong entity is the ID-dependent entity.
Your answer: No response
Correct answer: False



Question 26 (Received 0 out of 0 points)


Question: The result for SELECT statements in SQL is a relation unless the result is a single number.
Your answer: No response
Correct answer: False



Question 27 (Received 0 out of 0 points)


Question: The order of the columns returned by an SQL SELECT statement are determined by the:
Your answer: No response
Correct answer: order they are listed in following SELECT



Question 28 (Received 0 out of 0 points)


Question: Which of the following would not be contained in a use case?
Your answer: No response
Correct answer: A prototype of the system performing a given task.



Question 29 (Received 0 out of 0 points)


Question: Which of the following activities is not performed during the implementation phase of developing a database system?
Your answer: No response
Correct answer: Transforming the data model into a database design



Question 30 (Received 0 out of 0 points)


Question: Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?
Your answer: No response
Correct answer: WHERE



Question 31 (Received 0 out of 0 points)


Question: If one instance of ENTITY B must be related to one and only one instance of ENTITY A, and one instance of ENTITY A may be related to many instances of ENTITY B, which of the following should be written in the relationship symbol of the figure below?
Your answer: No response
Correct answer: 1:N



Question 32 (Received 0 out of 0 points)


Question: When using SQL to create a table, a column is defined by declaring, in this order: data type, column name, and properties.
Your answer: No response
Correct answer: False



Question 33 (Received 0 out of 0 points)


Question: The representation of the content, relationships, and constraints of the data needed to support the system requirements is the _________.
Your answer: No response
Correct answer: data model



Question 34 (Received 0 out of 0 points)


Question: The PRODUCT entity instance is the collection of all PRODUCT entity classes.
Your answer: No response
Correct answer: False



Question 35 (Received 0 out of 0 points)


Question: Use cases can be used to validate the data model, design, and implementation.
Your answer: No response
Correct answer: True



Question 36 (Received 0 out of 0 points)


Question: Which normal form is defined as any table meeting the definition of a relation?
Your answer: No response
Correct answer: 1NF



Question 37 (Received 0 out of 0 points)


Question: A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.
Your answer: No response
Correct answer: False



Question 38 (Received 0 out of 0 points)


Question: To represent a many-to-many relationship in the relational model, a union relation is used.
Your answer: No response
Correct answer: False



Question 39 (Received 0 out of 0 points)


Question: The characteristic of a transaction that indicates that either all of the transaction actions need to be completed or none of them will be is called _________.
Your answer: No response
Correct answer: atomic



Question 40 (Received 0 out of 0 points)


Question: With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released.
Your answer: No response
Correct answer: False



Question 41 (Received 0 out of 0 points)


Question: The key of the parent entity becomes part of the key of an ID dependent entity.
Your answer: No response
Correct answer: True



Question 42 (Received 0 out of 0 points)


Question: Transactions have a growing phase, in which locks are obtained and a shrinking phase, in which locks are released.
Your answer: No response
Correct answer: True



Question 43 (Received 0 out of 0 points)


Question: A trigger is similar to a stored procedure, except that it is written to be invoked by the DBMS when a specified event occurs.
Your answer: No response
Correct answer: True



Question 44 (Received 0 out of 0 points)


Question: A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.
Your answer: No response
Correct answer: False



Question 45 (Received 0 out of 0 points)


Question: The need to add the same data to multiple rows of a relation about one theme because the relation contains data about multiple themes is an example of a deletion anomaly.
Your answer: No response
Correct answer: False



Question 46 (Received 0 out of 0 points)


Question: Which of the following is true about representing a weak entity with the relational model?
Your answer: No response
Correct answer: If the weak entity is ID dependent, the key of the parent entity must be part of the key of the weak entity.



Question 47 (Received 0 out of 0 points)


Question: Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.
Your answer: No response
Correct answer: False



Question 48 (Received 0 out of 0 points)


Question: Which of the following is a type of trigger than can be invoked in place of DBMS insert, update, or delete actions?
Your answer: No response
Correct answer: INSTEAD OF triggers



Question 49 (Received 0 out of 0 points)


Question: A ______________ is a point of synchronization between the database and the transaction log.
Your answer: No response
Correct answer: checkpoint



Question 50 (Received 0 out of 0 points)


Question: When attempting to delete data about one theme results in the loss of data about another theme because the data for both themes are stored in the same relation, it is called a(n) ____________.
Your answer: No response
Correct answer: none of the above



Question 51 (Received 0 out of 0 points)


Question: To represent a M:N relationship in the relational model, an intersection relation is created to represent the relationship itself.
Your answer: No response
Correct answer: True



Question 52 (Received 0 out of 0 points)


Question: DK/NF requires that all constraints on data values be logical implications of the definitions of domains and keys.
Your answer: No response
Correct answer: True



Question 53 (Received 0 out of 0 points)


Question: Relationships that are 1:1 and are mandatory in both directions often indicate that the two entities should be combined into a single entity.
Your answer: No response
Correct answer: True



Question 54 (Received 0 out of 0 points)


Question: Which of the following is the correct technique for representing a 1:N relationship in the relational model?
Your answer: No response
Correct answer: The key of the entity on the one side is placed into the relation for the entity on the many side.



Question 55 (Received 0 out of 0 points)


Question: Rollback requires the use of logs, but rollforward does not.
Your answer: No response
Correct answer: False



Question 56 (Received 0 out of 0 points)


Question: Which of the following is true about a shared lock?
Your answer: No response
Correct answer: It allows reads to the locked item.



Question 57 (Received 0 out of 0 points)


Question: When a change in the data concerning one theme occurs that causes many rows of the table to be modified because the table contains data about multiple themes, we call this characteristic a modification anomaly.
Your answer: No response
Correct answer: True



Question 58 (Received 0 out of 0 points)


Question: When data about one theme cannot be entered in a relation until data about a second theme is also available because both themes are stored in the same relation, this is called a(n) ____________.
Your answer: No response
Correct answer: insertion anomaly



Question 59 (Received 0 out of 0 points)


Question: To represent a 1:N relationship in the relational model, the key of either entity may be placed as a foreign key in the other entity.
Your answer: No response
Correct answer: False



Question 60 (Received 0 out of 0 points)


Question: To represent a 1:N relationship in the relational model, the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.
Your answer: No response
Correct answer: True



Question 61 (0 points possible)


Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours), write a SQL statement that eliminates the row for the Project with ID# 1600 only.
Your answer:
No response
Correct answer:


DELETE

FROM PROJECT

WHERE ProjectID = 1600;




Question 62 (0 points possible)


Question: Dental Patient
Determine the entities implied by the following, unnormalized table(s). Draw an appropriate E-R diagram.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.
Your answer:
No response
Correct answer:




Question 63 (0 points possible)


Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.

Be sure to do both parts a. and b. of this question.
Your answer:
No response
Correct answer:




Question 64 (0 points possible)


Question: College Student
Using your knowledge of a college environment, determine the functional dependencies that exist in the following table. After these have been determined, convert this table to an equivalent collection of tables that are in 3NF.

Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term, Grade))

Remember there are 2 parts:
a) functional dependencies, and
b) 3NF tables
Your answer:
No response
Correct answer:


Question 1 (Received 0 out of 0 points)

Question: The DBMS receives data update requests from the application program.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 2 (Received 0 out of 0 points)

Question: Which of the following is not true of surrogate keys?


Your answer: No response
Correct answer: They are meaningful to the users.



--------------------------------------------------------------------------------

Question 3 (Received 0 out of 0 points)

Question: Databases are key components of _____.


Your answer(s):
No response
Correct answer(s):
e-commerce
Web-based applications
censuses
management decision support systems




--------------------------------------------------------------------------------

Question 4 (Received 0 out of 0 points)

Question: Which of the following is a strategy used by desktop DBMS products like Microsoft Access to make it easier for people to develop personal database systems?


Your answer: No response
Correct answer: The DBMS product takes the role of the DBMS and the database application.



--------------------------------------------------------------------------------

Question 5 (Received 0 out of 0 points)

Question: A surrogate key may be appropriate under which of the following circumstances?


Your answer(s):
No response
Correct answer(s):
The candidate keys available would produce a lot of data duplication when representing relationships.
The candidate keys available would be prone to typographical errors.
Both a and c.




--------------------------------------------------------------------------------

Question 6 (Received 0 out of 0 points)

Question: Microsoft Access is an example of a ___________.


Your answer: No response
Correct answer: database management system



--------------------------------------------------------------------------------

Question 7 (Received 0 out of 0 points)

Question: The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 8 (Received 0 out of 0 points)

Question: The unique keys that are not chosen to be the primary key are called composite keys.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 9 (Received 0 out of 0 points)

Question: Any table that meets the definition of a relation is said to be in second normal form.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 10 (Received 0 out of 0 points)

Question: Which of the following would not be an example of metadata?


Your answer: No response
Correct answer: All of the above are metadata.



--------------------------------------------------------------------------------

Question 11 (Received 0 out of 0 points)

Question: A key that contains more than one attribute is called a(n) __________ key.


Your answer: No response
Correct answer: composite key



--------------------------------------------------------------------------------

Question 12 (Received 0 out of 0 points)

Question: Given the functional dependency for the attributes of ENTITY1, X (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 13 (Received 0 out of 0 points)

Question: The primary (or candidate) key of a relation functionally determines all the other attributes in the relation.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 14 (Received 0 out of 0 points)

Question: One important relational design principle is that ___________.


Your answer: No response
Correct answer: every determinant must be a candidate key



--------------------------------------------------------------------------------

Question 15 (Received 0 out of 0 points)

Question: A rule that requires every value in a foreign key to match values in the corresponding primary key is called a referential integrity constraint.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 16 (Received 0 out of 0 points)

Question: Which of the following would not be contained in a use case?


Your answer: No response
Correct answer: A prototype of the system performing a given task.



--------------------------------------------------------------------------------

Question 17 (Received 0 out of 0 points)

Question: One shortcoming of UML is its inability to represent weak entities.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 18 (Received 0 out of 0 points)

Question: In SQL, the LIKE keyword can be used to select on partial values.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 19 (Received 0 out of 0 points)

Question: Which SQL keyword is used to eliminate duplicate rows in the results of a SQL SELECT query?


Your answer: No response
Correct answer: DISTINCT



--------------------------------------------------------------------------------

Question 20 (Received 0 out of 0 points)

Question: Which of the following is the correct technique for representing a weak entity in UML-style E-R diagrams?


Your answer: No response
Correct answer: Placing a filled-in diamond next to the strong entity



--------------------------------------------------------------------------------

Question 21 (Received 0 out of 0 points)

Question: The number of entity classes involved in a relationship is the cardinality of the relationship.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 22 (Received 0 out of 0 points)

Question: Which of the following is not a basic element of the E-R Model?


Your answer: No response
Correct answer: Use cases



--------------------------------------------------------------------------------

Question 23 (Received 0 out of 0 points)

Question: When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10 characters.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 24 (Received 0 out of 0 points)

Question: Attribute specifications are the documentation of the attributes' data format and properties.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 25 (Received 0 out of 0 points)

Question: In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 26 (Received 0 out of 0 points)

Question: When an entity class has a relationship with itself, it is called a recursive relationship.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 27 (Received 0 out of 0 points)

Question: The result for SELECT statements in SQL is a relation unless the result is a single number.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 28 (Received 0 out of 0 points)

Question: Which of the following can not be done using the ALTER TABLE command?


Your answer: No response
Correct answer: All of the above can be done using the ALTER TABLE command.



--------------------------------------------------------------------------------

Question 29 (Received 0 out of 0 points)

Question: Which of the following is not one of the five SQL built-in functions?


Your answer: No response
Correct answer: MODE



--------------------------------------------------------------------------------

Question 30 (Received 0 out of 0 points)

Question: A prototype is a working demonstration of selected portions of the future system.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 31 (Received 0 out of 0 points)

Question: During the design phase of developing a database system, the users are asked about the need for changes to existing forms and reports.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 32 (Received 0 out of 0 points)

Question: Use cases are descriptions of the ways users will employ the features and functions of the new information system.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 33 (Received 0 out of 0 points)

Question: In UML-style E-R diagrams, the entity class symbol contains what information in the second segment?


Your answer: No response
Correct answer: Attributes



--------------------------------------------------------------------------------

Question 34 (Received 0 out of 0 points)

Question: In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 35 (Received 0 out of 0 points)

Question: When using SQL to create a table, a column is defined by declaring, in this order: data type, column name, and properties.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 36 (Received 0 out of 0 points)

Question: A trigger cannot be fired because of the actions of another trigger.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 37 (Received 0 out of 0 points)

Question: Transaction results are kept in a log, which contains records of the data changes in chronological order.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 38 (Received 0 out of 0 points)

Question: In certain circumstances, a single entity may be broken into relations for performance reasons.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 39 (Received 0 out of 0 points)

Question: Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 40 (Received 0 out of 0 points)

Question: To normalize a relation, the determinant of every functional dependency should be a candidate key.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 41 (Received 0 out of 0 points)

Question: Boyce-Codd Normal Form was created to address the problem of multi-valued dependencies.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 42 (Received 0 out of 0 points)

Question: Which of the following is a type of trigger than can be invoked in place of DBMS insert, update, or delete actions?


Your answer: No response
Correct answer: INSTEAD OF triggers



--------------------------------------------------------------------------------

Question 43 (Received 0 out of 0 points)

Question: A stored procedure is invoked automatically by the DBMS whenever certain events occur.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 44 (Received 0 out of 0 points)

Question: Two-phased locking can be used to ensure that transactions are serializable.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 45 (Received 0 out of 0 points)

Question: A trigger is like a stored event except that it is invoked by the DBMS when specified events occur.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 46 (Received 0 out of 0 points)

Question: If two entities are in a 1:1 relationship that is mandatory in both directions and they have the same primary key, then the designer should consider __________.


Your answer: No response
Correct answer: combining them into a single relation



--------------------------------------------------------------------------------

Question 47 (Received 0 out of 0 points)

Question: The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called rollback recovery.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 48 (Received 0 out of 0 points)

Question: Database administrators must make sure that backup and recovery techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 49 (Received 0 out of 0 points)

Question: When attempting to delete data about one theme results in the loss of data about another theme because the data for both themes are stored in the same relation, it is called a(n) ____________.


Your answer: No response
Correct answer: none of the above



--------------------------------------------------------------------------------

Question 50 (Received 0 out of 0 points)

Question: The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ___________.


Your answer: No response
Correct answer: rollforward



--------------------------------------------------------------------------------

Question 51 (Received 0 out of 0 points)

Question: The key for an intersection relation is always the combination of the keys of the parent entities.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 52 (Received 0 out of 0 points)

Question: Which of the following is not true of database recovery through reprocessing?


Your answer: No response
Correct answer: Reprocessing will always return the database to its exact previous state.



--------------------------------------------------------------------------------

Question 53 (Received 0 out of 0 points)

Question: Losing two and possibly three themes while attempting to delete data about one is called an insertion anomaly.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 54 (Received 0 out of 0 points)

Question: Whether a lock applies to data at the record level, page level, table level, or database level is referred to as _________.


Your answer: No response
Correct answer: lock granularity



--------------------------------------------------------------------------------

Question 55 (Received 0 out of 0 points)

Question: With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 56 (Received 0 out of 0 points)

Question: To represent a many-to-many relationship in the relational model, a union relation is used.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 57 (Received 0 out of 0 points)

Question: A recursive relationship is a relationship among entities of the same class.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 58 (Received 0 out of 0 points)

Question: Ensuring that each SQL statement independently processes consistent rows is known as _______.


Your answer: No response
Correct answer: statement level consistency



--------------------------------------------------------------------------------

Question 59 (Received 0 out of 0 points)

Question: Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 60 (Received 0 out of 0 points)

Question: A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 61 (0 points possible)

Question: Given the relation EMPLOYEE (EmployeeNumber, Name, Phone, Department), write a SQL query statement that will list all rows and columns sorted alphabetically on the employee name.


Your answer:

No response
Correct answer:


SELECT EmployeeNumber, Name , Phone, Department
FROM EMPLOYEE
ORDER BY Name;

[alternate answer]
SELECT *
FROM EMPLOYEE
ORDER BY Name;





--------------------------------------------------------------------------------

Question 62 (0 points possible)

Question: Restaurant Meal Check
Determine the entities implied by the following, unnormalized table(s). Draw an appropriate E-R diagram.

Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number, Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description, (Menu Item Number, Item Name, Item Price)))

This document concerns meal check information. For a given meal check (identified by the check number), there will be a single server assigned to a single customer group (usually occupying a booth.) Each time a different group occupies the booth, there is a new session number (the session numbers start anew every day.) The server's number and name appear on the check as well as the meal (breakfast, lunch, dinner) and date. Also, there may be several different item orders appearing on the check for each of one or more guests (id'ed by seat number.) For each item order that appears, the item number, name, and price will be displayed. The price is from the current menu table.


Your answer:

No response
Correct answer:





--------------------------------------------------------------------------------

Question 63 (0 points possible)

Question: Video Rentals
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Rental Agreement(Agreement Number, Customer Number, Last Name, First Name, Street, City, State, Zip Code, Agreement Date, (Video Number, Video Title, Type, New, Charge, Due Date))

This table concerns rental agreement information. For a given agreement (identified by the agreement number), there will be a single customer. The customer's number, name, and address appear on the invoice as well as the agreement date. Also, there will be one or more different videos appearing on the agreement. For each video that appears, the video number, video title, type (VHS or DVD), new (yes or no), charge, and due date will be displayed. The charge is from the current master charge table list, and is based on type and whether it is new or not. The due date is based on type and whether it is new or not (due date is calculated by a number of days, from the master charge table list, added to the agreement date.)

An example of the master table list follows:

type new charge days
---- --- ------ ----
DVD Y 3.00 1
DVD N 1.00 1
VHS Y 2.00 1
VHS N 1.00 3


Your answer:

No response
Correct answer:





--------------------------------------------------------------------------------

Question 64 (0 points possible)

Question: College Student
Using your knowledge of a college environment, determine the functional dependencies that exist in the following table. After these have been determined, convert this table to an equivalent collection of tables that are in 3NF.

Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term, Grade))

Remember there are 2 parts:
a) functional dependencies, and
b) 3NF tables


Your answer:

No response
Correct answer:



Question 1 (Received 0 out of 0 points)

Question: Which of the following is not typically true about large database systems?


Your answer: No response
Correct answer: They hide most of the development complexity with wizards.



--------------------------------------------------------------------------------

Question 2 (Received 0 out of 0 points)

Question: To create a well-formed relation through normalization, every determinant must be a candidate key.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 3 (Received 0 out of 0 points)

Question: Databases are key components of _____.


Your answer(s):
No response
Correct answer(s):
e-commerce
Web-based applications
censuses
management decision support systems




--------------------------------------------------------------------------------

Question 4 (Received 0 out of 0 points)

Question: Candidate keys may or may not be unique.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 5 (Received 0 out of 0 points)

Question: A database is a set of one or more computer programs that serves as an intermediary between the users and the DBMS.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 6 (Received 0 out of 0 points)

Question: Surrogate key values have no meaning to the users.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 7 (Received 0 out of 0 points)

Question: In the general division of labor between database applications and the DBMS, the processing for forms is considered a DBMS task.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 8 (Received 0 out of 0 points)

Question: The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 9 (Received 0 out of 0 points)

Question: Which of the following would not be an example of metadata?


Your answer: No response
Correct answer: All of the above are metadata.



--------------------------------------------------------------------------------

Question 10 (Received 0 out of 0 points)

Question: Which of the following is not a basic component of a database system?


Your answer: No response
Correct answer: ERD



--------------------------------------------------------------------------------

Question 11 (Received 0 out of 0 points)

Question: Databases are used in rare circumstances.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 12 (Received 0 out of 0 points)

Question: In the relational model, each row of a table contains data that represents an attribute of the entity.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 13 (Received 0 out of 0 points)

Question: Given the functional dependency for the attributes of ENTITY1, X (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 14 (Received 0 out of 0 points)

Question: Databases are used by thousands of workgroups.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 15 (Received 0 out of 0 points)

Question: Which of the following is true about a key?


Your answer(s):
No response
Correct answer(s):
It may be unique.
It may be non-unique.
It may identify more than one row.
Both a and b.
All of the above.




--------------------------------------------------------------------------------

Question 16 (Received 0 out of 0 points)

Question: A subquery is appropriate only if the final result contains only data from a single table.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 17 (Received 0 out of 0 points)

Question: Standard SQL does not allow built-in functions to be used in a WHERE clause.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 18 (Received 0 out of 0 points)

Question: In the E-R Model, all instances of an entity of a given type are grouped into __________.


Your answer: No response
Correct answer: entity classes



--------------------------------------------------------------------------------

Question 19 (Received 0 out of 0 points)

Question: When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10 characters.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 20 (Received 0 out of 0 points)

Question: In SQL, the LIKE keyword can be used to select on partial values.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 21 (Received 0 out of 0 points)

Question: In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 22 (Received 0 out of 0 points)

Question: To create a primary key that is a composite key using SQL, the key must be defined when the table is created using the CREATE TABLE statement.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 23 (Received 0 out of 0 points)

Question: When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 24 (Received 0 out of 0 points)

Question: Attribute specifications are the documentation of the attributes' data format and properties.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 25 (Received 0 out of 0 points)

Question: System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 26 (Received 0 out of 0 points)

Question: The PRODUCT entity instance is the collection of all PRODUCT entity classes.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 27 (Received 0 out of 0 points)

Question: SQL is a data sublanguage, not a complete programming language.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 28 (Received 0 out of 0 points)

Question: The data model is a representation of the content, relationships, and constraints of the data needed to support the system requirements.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 29 (Received 0 out of 0 points)

Question: Data from a maximum of three tables can be combined through the use of subqueries in SQL.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 30 (Received 0 out of 0 points)

Question: There is usually only one instance of an entity in an entity class.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 31 (Received 0 out of 0 points)

Question: Business rules constrain data values and the processing of the database.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 32 (Received 0 out of 0 points)

Question: Which of the following data types used in SQL would define a fixed-length text field of 10 characters?


Your answer: No response
Correct answer: char(10)



--------------------------------------------------------------------------------

Question 33 (Received 0 out of 0 points)

Question: Which of the following is not a source for user requirements during the requirements stage of developing a database system?


Your answer: No response
Correct answer: All of the above are sources for user requirements.



--------------------------------------------------------------------------------

Question 34 (Received 0 out of 0 points)

Question: Relationships with the degree 2 are often called binary relationships.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 35 (Received 0 out of 0 points)

Question: In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 36 (Received 0 out of 0 points)

Question: A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 37 (Received 0 out of 0 points)

Question: An ACID transaction is one that is ___________.


Your answer(s):
No response
Correct answer(s):
atomic
consistent
isolated
durable
all of the above




--------------------------------------------------------------------------------

Question 38 (Received 0 out of 0 points)

Question: The fundamental rule of normalization can be stated as:


Your answer: No response
Correct answer: Every determinant must be a candidate key.



--------------------------------------------------------------------------------

Question 39 (Received 0 out of 0 points)

Question: From a pragmatic standpoint, the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 40 (Received 0 out of 0 points)

Question: Which of the following is not true of database recovery through reprocessing?


Your answer: No response
Correct answer: Reprocessing will always return the database to its exact previous state.



--------------------------------------------------------------------------------

Question 41 (Received 0 out of 0 points)

Question: One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 42 (Received 0 out of 0 points)

Question: In the relational model, many-to-many relationships cannot be directly represented by relations.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 43 (Received 0 out of 0 points)

Question: Transactions have a growing phase, in which locks are obtained and a shrinking phase, in which locks are released.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 44 (Received 0 out of 0 points)

Question: All recursive relationships are 1:1.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 45 (Received 0 out of 0 points)

Question: Transactions should be written to the log before they are applied to the database itself.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 46 (Received 0 out of 0 points)

Question: Once a relation has been defined for an entity, it should be examined according to normalization criteria.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 47 (Received 0 out of 0 points)

Question: DK/NF requires:


Your answer: No response
Correct answer: Every constraint on data values must be a logical consequence of the definition of domains and keys.



--------------------------------------------------------------------------------

Question 48 (Received 0 out of 0 points)

Question: Given ENTITY A and ENTITY B shown in the figure, which of the following would display the correct placement of foreign keys in the relational model? (PK = Primary Key, FK = Foreign Key)


Your answer: No response
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B (Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))



--------------------------------------------------------------------------------

Question 49 (Received 0 out of 0 points)

Question: The term DBA refers to ____________.


Your answer: No response
Correct answer: database administrator



--------------------------------------------------------------------------------

Question 50 (Received 0 out of 0 points)

Question: When a change in the data concerning one theme occurs that causes many rows of the table to be modified because the table contains data about multiple themes, we call this characteristic a modification anomaly.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 51 (Received 0 out of 0 points)

Question: Transaction results are kept in a log, which contains records of the data changes in chronological order.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 52 (Received 0 out of 0 points)

Question: The simplest and most feasible means of recovering a database is through reprocessing.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 53 (Received 0 out of 0 points)

Question: DK/NF requires that all constraints on data values be logical implications of the definitions of domains and keys.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 54 (Received 0 out of 0 points)

Question: Boyce-Codd Normal Form was created to address the problem of multi-valued dependencies.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 55 (Received 0 out of 0 points)

Question: ASP and JSP can include instructions to read data, but may not update or delete data.


Your answer: No response
Correct answer: False



--------------------------------------------------------------------------------

Question 56 (Received 0 out of 0 points)

Question: R. Fagin defined the domain key / normal form, and a relation in this form has no anomalies.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 57 (Received 0 out of 0 points)

Question: The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 58 (Received 0 out of 0 points)

Question: What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?


Your answer: No response
Correct answer: Phantom reads



--------------------------------------------------------------------------------

Question 59 (Received 0 out of 0 points)

Question: Database administrators must make sure that backup and recovery techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 60 (Received 0 out of 0 points)

Question: The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called rollback recovery.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 61 (0 points possible)

Question: Given the relation PROJECT(ProjectID, Name, Department, MaxHours), write a SQL query statement that will list all rows and columns for the case in which MaxHours is greater than 100.


Your answer:

No response
Correct answer:


SELECT ProjectID, Name, Department, MaxHours
FROM PROJECT
WHERE MaxHours > 100;

[alternate answer]
SELECT *
FROM PROJECT
WHERE MaxHours > 100;





--------------------------------------------------------------------------------

Question 62 (0 points possible)

Question: Dental Patient
Determine the entities implied by the following, unnormalized table(s). Draw an appropriate E-R diagram.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.


Your answer:

No response
Correct answer:





--------------------------------------------------------------------------------

Question 63 (0 points possible)

Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.

Be sure to do both parts a. and b. of this question.


Your answer:

No response
Correct answer:





--------------------------------------------------------------------------------

Question 64 (0 points possible)

Question: Legal Services
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Statement(Statement Number, Client Number, Last Name, First Name, Street, City, State, Zip Code, Statement Date, Attorney Number, Attorney Last Name(Service Code, Service Description, Service Date, Attorney Number, Hours))

This table concerns statement for legal services rendered information. For a given statement (identified by the statement number), there will be a single client. The client's number, name, and address appear on the statement as well as the statement date. Each client has one specific attorney, for all services, even though another attorneys may participate on a given service. Also, there may be several services listed on the statement. For each service that appears, the service code, service description, service date, and hours will be displayed.


Your answer:

No response
Correct answer:


Question 1 (Received 0 out of 0 points)

Question: The primary (or candidate) key of a relation functionally determines all the other attributes in the relation.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 2 (Received 0 out of 0 points)

Question: To represent a relationship in the relational model, the primary key of one relation is placed into a second relation.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 3 (Received 0 out of 0 points)

Question: UUsually, a database table containing both rows and columns is designed to store data for exactly two topics.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 4 (Received 0 out of 0 points)

Question: The primary key is used both to identify unique rows in a relation and to represent rows in relationships.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 5 (Received 0 out of 0 points)

Question: Which of the following is not typically true about large database systems?


Your answer: They support hundreds or thousands of users.
Correct answer: They hide most of the development complexity with wizards.



--------------------------------------------------------------------------------

Question 6 (Received 0 out of 0 points)

Question: Which of the following is not true about a relation?


Your answer: The cells of a relation must hold a single value.
Correct answer: A relation may have duplicate column names.



--------------------------------------------------------------------------------

Question 7 (Received 0 out of 0 points)

Question: Which of the following is true about a relation?


Your answer: A relation may have duplicate rows.
Correct answer: All entries in any column must be of the same kind.



--------------------------------------------------------------------------------

Question 8 (Received 0 out of 0 points)

Question: Databases are used in rare circumstances.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 9 (Received 0 out of 0 points)

Question: In the relational model, each row of a table contains data that represents an attribute of the entity.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 10 (Received 0 out of 0 points)

Question: In the general division of labor between database applications and the DBMS, the processing for forms is considered a DBMS task.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 11 (Received 0 out of 0 points)

Question: In the general division of labor between database applications and the DBMS, the application program formats the results of a query into a report.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 12 (Received 0 out of 0 points)

Question: A table that meets the requirements of a relation is said to be in which normal form?


Your answer: first normal form
Correct answer: first normal form



--------------------------------------------------------------------------------

Question 13 (Received 0 out of 0 points)

Question: A database is a set of one or more computer programs that serves as an intermediary between the users and the DBMS.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 14 (Received 0 out of 0 points)

Question: The unique keys that are not chosen to be the primary key are called composite keys.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 15 (Received 0 out of 0 points)

Question: Which of the following would not be an example of metadata?


Your answer: All of the above are metadata.
Correct answer: All of the above are metadata.



--------------------------------------------------------------------------------

Question 16 (Received 0 out of 0 points)

Question: The basic format for documenting cardinalities in UML is x..y, where x is the maximum cardinality and y is the minimum cardinality.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 17 (Received 0 out of 0 points)

Question: Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?


Your answer: WHERE
Correct answer: HAVING



--------------------------------------------------------------------------------

Question 18 (Received 0 out of 0 points)

Question: Unified Modeling Language (UML) is intended for the development of object-oriented systems.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 19 (Received 0 out of 0 points)

Question: The number of entity classes involved in a relationship is known as the _________ of the relationship.


Your answer: minimum cardinality
Correct answer: degree



--------------------------------------------------------------------------------

Question 20 (Received 0 out of 0 points)

Question: The representation of the content, relationships, and constraints of the data needed to support the system requirements is the _________.


Your answer: implementation
Correct answer: data model



--------------------------------------------------------------------------------

Question 21 (Received 0 out of 0 points)

Question: Use cases are descriptions of the ways users will employ the features and functions of the new information system.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 22 (Received 0 out of 0 points)

Question: Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?


Your answer: SORT BY Department
Correct answer: ORDER BY Department DESC



--------------------------------------------------------------------------------

Question 23 (Received 0 out of 0 points)

Question: System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 24 (Received 0 out of 0 points)

Question: In the E-R Model, all instances of an entity of a given type are grouped into __________.


Your answer: class objects
Correct answer: entity classes



--------------------------------------------------------------------------------

Question 25 (Received 0 out of 0 points)

Question: In SQL, the LIKE keyword can be used to select on partial values.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 26 (Received 0 out of 0 points)

Question: In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 27 (Received 0 out of 0 points)

Question: Which type of join, although not included in standard SQL, was created to allow unmatched rows to appear in the result of a join operation?


Your answer: OPEN JOIN
Correct answer: OUTER JOIN



--------------------------------------------------------------------------------

Question 28 (Received 0 out of 0 points)

Question: The result for SELECT statements in SQL is a relation unless the result is a single number.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 29 (Received 0 out of 0 points)

Question: Which SQL keyword is used to eliminate duplicate rows in the results of a SQL SELECT query?


Your answer: ORDER BY
Correct answer: DISTINCT



--------------------------------------------------------------------------------

Question 30 (Received 0 out of 0 points)

Question: The basic idea of a join is to combine the contents of two or more relations into a new relation.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 31 (Received 0 out of 0 points)

Question: Which of the following would not be contained in a use case?


Your answer: A prototype of the system performing a given task.
Correct answer: A prototype of the system performing a given task.



--------------------------------------------------------------------------------

Question 32 (Received 0 out of 0 points)

Question: One type of strong entity is the ID-dependent entity.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 33 (Received 0 out of 0 points)

Question: In UML-style E-R diagrams, an entity class is represented by a rectangle with three segments.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 34 (Received 0 out of 0 points)

Question: Relationships with the degree 2 are often called binary relationships.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 35 (Received 0 out of 0 points)

Question: When developing a database system, the database is constructed during the implementation phase.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 36 (Received 0 out of 0 points)

Question: When data about one theme cannot be entered in a relation until data about a second theme is also available because both themes are stored in the same relation, this is called a(n) ____________.


Your answer: creation anomaly
Correct answer: insertion anomaly



--------------------------------------------------------------------------------

Question 37 (Received 0 out of 0 points)

Question: The simplest and most feasible means of recovering a database is through reprocessing.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 38 (Received 0 out of 0 points)

Question: A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 39 (Received 0 out of 0 points)

Question: DK/NF requires that all constraints on data values be logical implications of the definitions of domains and keys.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 40 (Received 0 out of 0 points)

Question: To represent a many-to-many relationship in the relational model, an intersection relation is used.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 41 (Received 0 out of 0 points)

Question: Which of the following is true about stored procedures?


Your answer: Stored procedures cannot be passed parameters like a regular application function.
Correct answer: Stored procedures are written in languages provided by the DBMS.



--------------------------------------------------------------------------------

Question 42 (Received 0 out of 0 points)

Question: Relationships that are 1:1 and are mandatory in both directions often indicate that the two entities should be combined into a single entity.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 43 (Received 0 out of 0 points)

Question: Once a relation has been defined for an entity, it should be examined according to normalization criteria.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 44 (Received 0 out of 0 points)

Question: R. Fagin defined the domain key / normal form, and a relation in this form has no anomalies.


Your answer: No response
Correct answer: True



--------------------------------------------------------------------------------

Question 45 (Received 0 out of 0 points)

Question: One of the major tasks of the database administration is called concurrency control, which allows multi-users to access the database simultaneously.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 46 (Received 0 out of 0 points)

Question: Given ENTITY A and ENTITY B shown in the figure, which of the following would display the correct placement of foreign keys in the relational model? (PK = Primary Key, FK = Foreign Key)


Your answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3, Attribute6(FK)); ENTITY B (Attribute4(PK), Attribute5, Attribute6)
Correct answer: ENTITY A (Attribute1(PK), Attribute2, Attribute3); ENTITY B (Attribute4(PK), Attribute5, Attribute6, Attribute1(FK))



--------------------------------------------------------------------------------

Question 47 (Received 0 out of 0 points)

Question: To represent a M:N relationship in the relational model, an intersection relation is created to represent the relationship itself.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 48 (Received 0 out of 0 points)

Question: Which of the following is the first step in representing entities using the relational model?


Your answer: Determine identifiers
Correct answer: Define a relation for each entity



--------------------------------------------------------------------------------

Question 49 (Received 0 out of 0 points)

Question: Database administrators must make sure that backup and recovery techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 50 (Received 0 out of 0 points)

Question: A stored procedure is invoked automatically by the DBMS whenever certain events occur.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 51 (Received 0 out of 0 points)

Question: When applied to 1:N relationships, the term ?parent? refers to the many side of the relationship since a child may have many parents.


Your answer: True
Correct answer: False



--------------------------------------------------------------------------------

Question 52 (Received 0 out of 0 points)

Question: Which of the following is not true of database recovery through reprocessing?


Your answer: Reprocessing takes the same amount of time as did processing in the first place.
Correct answer: Reprocessing will always return the database to its exact previous state.



--------------------------------------------------------------------------------

Question 53 (Received 0 out of 0 points)

Question: Which normal form deals with the problem of tables that can be split apart but not correctly joined back together?


Your answer: Boyce-Codd Normal Form
Correct answer: 5NF



--------------------------------------------------------------------------------

Question 54 (Received 0 out of 0 points)

Question: Which of the following is not a means of processing databases?


Your answer(s):
Programs coded in COBOL.
Internet applications using ASP.
Processed by stored procedures and triggers.
Programs coded in Java or C#.
All of the above are means of processing a database.

Correct answer(s):
Programs coded in COBOL.
Internet applications using ASP.
Processed by stored procedures and triggers.
Programs coded in Java or C#.
All of the above are means of processing a database.




--------------------------------------------------------------------------------

Question 55 (Received 0 out of 0 points)

Question: Only large database systems have a need for database administration.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 56 (Received 0 out of 0 points)

Question: Boyce-Codd Normal Form was created to address the problem of multi-valued dependencies.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 57 (Received 0 out of 0 points)

Question: All actions in an atomic transaction are completed successfully or none of the actions are completed at all.


Your answer: False
Correct answer: True



--------------------------------------------------------------------------------

Question 58 (Received 0 out of 0 points)

Question: Rollback requires the use of logs, but rollforward does not.


Your answer: False
Correct answer: False



--------------------------------------------------------------------------------

Question 59 (Received 0 out of 0 points)

Question: When a change in the data concerning one theme occurs that causes many rows of the table to be modified because the table contains data about multiple themes, we call this characteristic a modification anomaly.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 60 (Received 0 out of 0 points)

Question: A recursive relationship is a relationship among entities of the same class.


Your answer: True
Correct answer: True



--------------------------------------------------------------------------------

Question 61 (0 points possible)

Question: Given the relation EMPLOYEE (EmployeeNumber, Name, Phone, Department), write a SQL query statement that will list all rows and columns for the case in which the Employees have phone numbers beginning with ?597-?.


Your answer:

look up
Correct answer:


SELECT EmployeeNumber, Name , Phone, Department
FROM EMPLOYEE
WHERE Phone LIKE ?597-____?;

[alternate answers]
SELECT *
FROM EMPLOYEE
WHERE Phone LIKE ?597-____?;

SELECT *
FROM EMPLOYEE
WHERE Phone LIKE ?597-%?;





--------------------------------------------------------------------------------

Question 62 (0 points possible)

Question: College Student
Using your knowledge of a college environment, determine the entities implied by the following, unnormalized table(s). Draw an appropriate E-R diagram.

Student(Student Number, Student Name, Number Credits, Advisor Number, Advisor Name, Dept Number, Dept Name, (Course Number, Course Description, Course Term, Grade))


Your answer:

look up
Correct answer:





--------------------------------------------------------------------------------

Question 63 (0 points possible)

Question: Restaurant Meal Check
a.) List the functional dependencies in the following document subject to the specified conditions.

b.) Convert this document to an equivalent collection of tables that are in 3NF.

Meal Check(Check Number, Booth Number, Session, Date, Meal, Server Number, Server Name, Food total, Tax, Tip, Check Total, (Seat Number, Guest Description, (Menu Item Number, Item Name, Item Price)))

This document concerns meal check information. For a given meal check (identified by the check number), there will be a single server assigned to a single customer group (usually occupying a booth.) Each time a different group occupies the booth, there is a new session number (the session numbers start anew every day.) The server's number and name appear on the check as well as the meal (breakfast, lunch, dinner) and date. Also, there may be several different item orders appearing on the check for each of one or more guests (id'ed by seat number.) For each item order that appears, the item number, name, and price will be displayed. The price is from the current menu table.


Your answer:

l;ook up
Correct answer:





--------------------------------------------------------------------------------

Question 64 (0 points possible)

Question: Dental Patient Record
a.) List the functional dependencies in the following table subject to the specified conditions.

b.) Convert this table to an equivalent collection of tables that are in 3NF.

Patient (Household Number, Household Name, Household City, Household State, Household Zip, Balance, Patient Number, Patient Name, (Service Code, Service Description, Service Fee))

This is a table concerning information about patients of a dentist. Each patient belongs to a household. The household head is responsible for paying for dental services for all members of the household. The household head is designated in the table by "HH" being part of the patient number.

Be sure to do both parts a. and b. of this question.


Your answer:

look up
Correct answer: