Intro to Database Development

What do theoretical computer scientists call an instance of a relation?

A. A record
B. A tuple
C. An attribute
D. A determinant

Which of the following characteristic of a table in First Normal Form?

A. The first column of a table must be either the key or part of the key
B. All the entries in a row must be of the same kind
C. Each column must have a unique name
D. It must be three-dimensional

What does it mean when we say that one attribute of a relation is functionally dependent on a second attribute of that relation?

A. The first attribute is a key
B. The value of the first attribute determines the value if the second attribute
C. The second attribute is a key
D. The value of the second attribute determines the value of the first attribute

Why are deletion anomalies bad?

A. They insert bad data into a database table
B. They cause unwanted functional dependencies
C. They reduce the number of columns in a database table
D. Because you lose information you want to keep along with the information you want to remove

To put a relation into Domain/Key Normal Form,  what must you do?

A. Assure that all domains are logical consequences of keys
B. Assure that all constraints are a logical consequence of domains and keys
C. Assure that all keys are a logical consequence of domains and constraints
D. Remove all functional dependencies

What element of the E-R model corresponds to the key in the relational model?

A. The attribute
B. The relationship
C. The identifier
D. The entity

How are tables linked in a relational database?

A. With the SQL CONNECT command
B. The primary key of one table is exchanged with the primary key of the second table
C. With the SQL LINK command
D. The primary key of one table serves as a foreign key in the second table

If a table is on the many side of a one-to-many relationship, what must it contain?

A. The primary key of the table on the one side, serving as a foreign key
B. The foreign key of the table on the one side as a primary key
C. A foreign key for each matching record in the table on the one side
D. A composite key

In the E-R model, maximum cardinality is denoted by what?

A. An oval
B. A birds-foot symbol
C. Numbers within a rectangle with a red border
D. Symbols within a diamond

Why are many-to-many relationships a problem?

A. You cannot link tables by adding a foreign key of one table to the other table as a foreign key
B. You cannot reliably link the tables by adding the primary key of one table to the other table as a foreign key
C. They lead to tables that hold too much data
D. There are too many links between tables

What part of a database should you create first?

A. The reports 
B. The forms
C. The tables
D. The queries

In early versions of Access the default size for a Text field is 50 characters and in more recent versions, the default size for a Text field is 255 characters. Most times the amount of text entered into a Text field is less than 30 characters. Which of the following is true?

A. The default size of a Text field in recent versions of Access makes less efficient use of memory than earlier versions do
B. Efficiency of memory use is unaffected by the version of Access being used
C. The default size of Text fields has no effect on memory use efficiency
D. The default size of a Text field in recent versions of Access more efficient use of memory than earlier versions do

Which field in an Access database table should always contain a value?

A. The foreign key
B. The Primary key
C. The Name field
D. The first field

In Access how do you establish a one-to-many link between two tables?

A. In the Relationships window, click-drag the mouse pointer from the primary key of the table on the one side of the corresponding foreign key on the many side of the relationship
B. Place the two tables next to each other in the Relationship diagram
C. In the table on the many side, include a field with the same name as the field that is the primary key of the table on the one side
D. Make sure the Cascade Update and Cascade Delete boxes are checked

Which method of entering data into a database is the easiest for the novice user to deal with?

A. Using a custom form embedded in a database application program
B. Using the Bulk Data feature of Access
C. Using an SQL UPDATE statement
D. Using the Access generic data entry form

A user can converse directly with a database using what form of SQL?

A. Compiled SQL
B. Interactive SQL
C. Embedded SQL
D. Module Language

What part of SQL do you use to remove selected rows from a database table?

A. Data Deletion Language
B. Data Definition Language
C. Data Control Language
D. Data Manipulation Language

What kind of constraint is the NOT NULL constraint?

A. Row constraint
B. Table constraint
C. Foreign key constraint
D. Column constraint

Which of the following statements is not true for a table's primary key?

A. It may consist of multiple columns
B. It must be unique
C. It must include the first column in the table
D. It cannot have a NULL value

If you want to allow a person whom the system knows as Joe to be able to retrieve data from the PAPERS table, what statement should you use to give Joe that access?

A. GRANT SELECT ON PAPERS TO Joe;
B. GRANT UPDATE ON PAPERS TO Joe;
C. GRANT INSERT ON PAPERS TO Joe;
D. GRANT RETRIEVE ON PAPERS TO Joe;