Database Final

The creation of a database and its tables is a function of which component of the database system? a. Database b. Web server c. DBMS d. Application e. Users

C. DBSM

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a: a. foreign key b. secondary key c. surrogate key d. spare key e. primary key

C. Surrogate Key

A table that meets the requirements of a relation is said to be in which normal form? a. Domain/key normal form b. First normal form c. Second normal form d. Relational normal form (RNF) e. Boyce-Codd normal form

b. First normal form

A candidate key is: a. a candidate to be the primary key. b. required to be unique. c. used to represent rows in relationships. d. Both A and B e. All of the above

e. All of the above

A primary key is: a. used to identify unique rows. b. a candidate key. c. used to represent rows in relationships. d. required to be unique. e. All of the above

e. All of the above

Microsoft Access can be used to prototype databases for which of the following DBMS products? a. MySQL b. SQL Server c. Oracle Database d. Microsoft Access e. All of the above

e. All of the above

Which of the following is true about a key? a. In may identify more than one row. b. It may be non-unique. c. It may be unique. d. Both A and B e. All of the above

e. All of the above

Which of the following is not a basic component of a database system? a. ERD b. Database c. Data Applications d. DBSM E. User

A. ERD

SQL Stands for: a. Structured Query Language. b. Standard Query Language. c. Structured Question Language. d. Structural Question Language. e. Standard Question Language.

A. Structured Query Language

The statement SELECT STUDENT.StudentNumber, STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; is an example of: a. c++ b. QLE c. Java d. SQL E. QBE

D. SQL

A database may be used to help people: a. know the current inventory levels of products their company sells. b. track which student is assigned to a particular advisor. c. look up their checking account balance over the Internet. d. check on the estimated arrival time of an incoming flight at an airport. e. All of the Above

E. All of the Above

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database? a. Inability to store partial data b. Duplication of data items c. Maintaining the data may require changing the same data value in many locations d. Inconsistency when a data item is used multiple times e. All of the Above

E. All of the Above

The component of a database that makes it self-describing is the: a. applications b. related tables. c. data set. d. library. e. Metadata

E. Metadata

A relational database stores data in the form of: a. Forms b. Spreadsheets c. Lists d. Columns E. Tables

E. Tables

Today almost every commercial database is based on: a. the linked-list model. b. the hierarchical model. c. the object-oriented model. d. lists e. the relational model.

E. The Relational Model

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters? a. % (percent sign) b. ! (exclamation mark) c. ; (semi-colon) d. ? (question mark) e. _ (underscore)

a. % (Percent sign)

Microsoft Access 2013 database files are stored using the file extension: a. .accdb. b .sql. c. .adb. d. .mdb e. .asp.

a. .accdb

Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true? a. AdvisorID is a foreign key. b. AdvisorName is a determinant. c. Phone is a candidate key. d. SID is both a primary key and a foreign key. e. Major is a candidate key.

a. AdvisorID is a foreign key.

Which of the following is not true of recursive relationships? a. Even when the relationship is 1:N, a new table must be defined to represent the relationship. b. When the recursive relationship is M:N, an intersection table is created. c. The techniques for representing the tables are the same as for non-recursive relationships except the rows are in the same table. d. Recursive relationships can be 1:1, 1:N, or M:N relationships. e. The rows of a single table can play two different roles.

a. Even when the relationship is 1:N, a new table must be defined to represent the relationship.

In SQL Server, the starting value of a surrogate key is called the: a. Identity Seed. b. Identity Start. c. Identity. d. Identity Increment. e. Identity Property.

a. Identity Seed.

Microsoft Access does not create N:M relationships because: a. Microsoft Access creates databases based on database designs instead of data models. b. Microsoft Access creates databases based on data models instead of database designs. c. Microsoft Access cannot implement recursive relationships. d. Microsoft Access cannot implement supertype/subtype relationships. e. Microsoft Access cannot implement association relationships.

a. Microsoft Access creates databases based on database designs instead of data models.

As far as Microsoft Access is concerned, there are no: a. N:M relationships. b. N:1 relationships. c. 1:N relationships. d. 1:1 relationships. e. recursive relationships.

a. N:M relationships.

Which of the following terms is synonymous with "tuple"? a. Row b. Attribute c. Table d. Relation e. Field

a. Row

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query? a. WHERE b. ORDER BY c. GROUP BY d. SELECT e. FROM

a. WHERE

A relational Database is: a. a self-describing collection of related tables. b. a set of metadata. c. a collection of forms and reports that support a given purpose. d. a set of applications and the data sets for those applications. e. a library of queries and data files for querying.

a. a self-describing collection of related tables.

A key that contains more than one attribute is called a(n): a. composite key b. complex key. c. candidate key. d. multi-key. e. n-key.

a. composite key.

In a relational database design, all relationships are expressed by ________. a. creating a foreign key b. creating a supertype c. creating a line between entities d. creating a primary key e. creating a subtype

a. creating a foreign key

The first step of the normalization process is to: a. identify all the candidate keys of a relation. b. split the relation into two or more new relations. c. identify all the functional dependencies of a relation. d. identify all the determinants of a relation. e. identify all the foreign keys of a relation.

a. identify all the candidate keys of a relation.

In the normalization process, it is not necessary to: a. identify all the foreign keys of a relation. b. determine if every determinant is a candidate key. c. identify all the candidate keys of a relation. d. identify all the determinants of a relation. e. identify all the functional dependencies of a relation.

a. identify all the foreign keys of a relation.

The order of the columns returned by an SQL SELECT statement is determined by the: a. order they are listed in following SELECT. b. ORDER BY clause. c. order they are listed in following WHERE. d. order they are listed in following FROM. e. SORT BY clause.

a. order they are listed in following SELECT.

The identifier of the entity becomes the ________ of the corresponding table. a. primary key b. supertype c. foreign key d. subtype e. either A or B

a. primary key

In relational database design, ID-dependent entities are used to ________. a. represent N:M relationships b. eliminate the need for weak entities being converted to tables. c. represent 1:1 relationships d. handle recursive relationships e. represent 1:N relationships

a. represent N:M relationships

Microsoft Access is a personal database system, and a personal database system is characterized by: a. the DBMS product taking the role of the DBMS and the database application generator. b. the DBMS removing the metadata from the database. c. the database being stored inside the DBMS. d. the DBMS not supporting indexes. e. the DBMS product being limited to a maximum of ten tables in any given database.

a. the DBMS product taking the role of the DBMS and the database application generator.

Microsoft Access SQL commands are run in: a. the SQL View of a Query window. b. the SQL window. c. the QBE window. d. the Query View of an SQL window. e. the Design View of a Query window.

a. the SQL View of a Query window.

Which of the following is not a function of the database application in a database system? a. Control concurrency b. Create and process forms c. Create and transmit queries d. Execute application logic e. Create and process reports

a.Control concurrency

Which of the following is true about representing a weak entity with the relational model? a. If the weak entity is existence-dependent, the key of the parent must be part of the key of the weak entity. b. If the weak entity is ID-dependent, the key of the parent entity must be part of the key of the weak entity. c. If the parent entity is existence-dependent, then the minimum cardinality of the weak entity is zero. d. If the strong entity has a minimum cardinality of 1, the key of the weak entity must be part of the strong entity. e. If the weak entity is ID-dependent, the key of the weak entity must be part of the key of the parent entity.

b. If the weak entity is ID-dependent, the key of the parent entity must be part of the key of the weak entity.

What relationship pattern is illustrated in the following schema? PRODUCT (ProductID, Description) SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT_SUPPLIER (ProductID, SupplierID, Cost) ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT SupplierID in PRODUCT_SUPPLIER must exist in a. Association relationship b. Intersection relationship c. Recursive relationship d. Strong entity relationship e. Supertype/subtype relationship

b. Intersection relationship

Which of the following is not one of the five SQL built-in functions? a. SUM b. MODE c. AVG d. MAX e. COUNT

b. MODE

Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage) which of the following statements is not known to be true? a. Manufacturer is functionally dependent on MedicineCode. b. MedicineName is a determinant. c. MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode). d. MedicineCode is a determinant. e. ShelfLife is functionally dependent on MedicineCode.

b. MedicineName is a determinant.

Which of the following is the correct technique for representing a 1:N relationship in the relational model? a. The key of the child is placed into the relation of the parent. b. The key of the entity on the one side is placed into the relation for the entity on the many side. c. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation. d. The key of the entity on the many side is placed into the relation for the entity on the one side. e. The key of either relation can be placed into the other relation.

b. The key of the entity on the one side is placed into the relation for the entity on the many side.

Which of the following is not true of surrogate keys? a. They are numeric. b. They are meaningful to the users. c. They are unique. d. They are usually hidden on forms and reports. e. They are usually generated by the DBMS.

b. They are meaningful to the users.

Which of the following is not true about surrogate keys? a. They have no meaning to the users. b. They are nonunique within a table. c. They are identifiers that are supplied by the system, not the users. d. They can be problematic when combining databases. e. The DBMS will not allow their values to be changed.

b. They are nonunique within a table.

Which of the following is not a basic element of the E-R Model? a. Relationships b. Use cases c. Cardinalities d. Identifiers e. Entities

b. Use cases

Which of the following is not a stage in the development of a database system? a. Component design b. Validation c. Requirements analysis d. Implementation e. All of the above are stages in the development of a database system.

b. Validation

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates: a. a minimum cardinality of one. b. a maximum cardinality of many. c. a minimum cardinality of zero. d. a maximum cardinality of one. e. Both B and C

b. a maximum cardinality of many.

In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates: a. a minimum cardinality of one. b. a minimum cardinality of zero. c. a maximum cardinality of many. d. a maximum cardinality of one e. Both B and C

b. a minimum cardinality of zero.

During the normalization process, the remedy for a relation that is not well formed is to: a. combine it with another relation that is well formed. b. break it into two or more relations that are well formed. c. convert it into a list. d. create a surrogate key. e. create a functional dependency.

b. break it into two or more relations that are well formed.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters? a. fixed(10) b. char(10) c. text(10) d. varchar(10) e. length(10)

b. char(10)

To open a new Microsoft Access Query window: a. click the New Query in Design view button on the Create command tab. b. click the Query Design button on the Command tab. c. click the New button on the Home command tab. d. click the Create Query button on the Create command tab. e. click the New Query button on the Home command tab.

b. click the Query Design button on the Command tab.

In Microsoft Access, tables are added to a Query window by: a. selecting the tables from the Queries section of the Navigation Pane. b. selecting the tables from the Show Table dialog box. c. selecting the tables from the Tables section of the Navigation Pane. d. selecting the tables from the Use Table dialog box. e. selecting the tables from the Relationships window.

b. selecting the tables from the Show Table dialog box.

To create a 1:1 relationship between two tables in Microsoft Access: a. the Indexed property of the foreign key column must be set to Yes (Duplicates OK). b. the Indexed property of the foreign key column must be set to Yes (No Duplicates). c. the Smart Tag property of the foreign key column must be set to Foreign Key. d. the Data Type of the foreign key column must be set to AutoNumber. e. the Indexed property of the foreign key column must be set to No

b. the Indexed property of the foreign key column must be set to Yes (No Duplicates).

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key, then ________. a. the parent entity must also use a surrogate key b. the relationship changes to a non-ID-dependent relationship c. the relationship remains an ID-dependent relationship d. A and B e. A and C

b. the relationship changes to a non-ID-dependent relationship

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. a.(Department, Capacity) → (BuildingName, RoomNumber) b. RoomNumber → (BuildingName, Department, Capacity) c. (BuildingName, RoomNumber) → (Capacity, Department) d. (BuildingName, Capacity) → (Department, RoomNumber) e. BuildingName → (RoomNumber, Capacity, Department)

c. (BuildingName, RoomNumber) → (Capacity, Department)

Microsoft Access is a good tool for creating mock-ups of forms and reports because: a. the form and report generators do not exist within Access itself. b. Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets. c. Access wizards make it easy to create the forms and reports. d. Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. e. Access forms and reports are very simplistic.

c. Access wizards make it easy to create the forms and reports.

Which of the following is true about a relation? a. A relation may have multiple names. b. A relation may have duplicate column names. c. All entries in any column must be of the same kind. d. A relation may have duplicate rows. e. The order of the columns in a relation must go from largest to smallest.

c. All entries in any column must be of the same kind.

Which of the following is not true about representing subtypes in a relational database design? a. The key of the supertype is made the key of the subtypes. b. One table is created for the supertype and one for each subtype. c. All of the attributes of the supertype are added to the subtype relations. d. An instance of the supertype may be related to one instance each of several subtypes. e. A subtype and its supertype are representations of the same underlying table.

c. All of the attributes of the supertype are added to the subtype relations.

Which of the following is the correct technique for representing a M:N relationship using the relational model? a. An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation. b. The key from either relation is placed as a foreign key in the other relation. c. An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. d. An intersection relation is created with a surrogate key, which is placed in each of the parent entities. e. None of the above

c. An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.

Which of the following is a function of the DBMS in a database system? a. Update database data b. Backup and restore data c. Create and transmit queries d. Create tables e. Maintain database structures

c. Create and transmit queries

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact? a. REMOVE TABLE STUDENT; b. DELETE TABLE STUDENT; c. DELETE FROM STUDENT; d. DROP TABLE STUDENT; e. SELECT * FROM STUDENT THEN DROP;

c. DELETE FROM STUDENT;

Which of the following would be a reason to denormalize a relation? a. Relax security b. End user preference c. Improve performance d. Lack of design time e. None of the above

c. Improve preformance

What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID, OfficePhone, Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE a. Association relationship b. Intersection relationship c. Recursive relationship d. Strong entity relationship e. Supertype/subtype relationship

c. Recursive relationship

Which of the following is not a standard data type used in SQL? a. Integer b. Numeric c. Text d. Varchar e. Char

c. Text

Which of the following is true when representing a 1:1 binary relationship using the relational model? a. The key of each entity must be placed in the other as a foreign key. b. The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. c. The key of either entity is placed in the other as a foreign key. d. Both entities must have the same primary key. e. The key of the entity with the most attributes must be placed in the other entity as a foreign key.

c. The key of either entity is placed in the other as a foreign key.

Which of the following is true about identifiers of entities? a. Identifiers are not normally used in a naming role. b. Identifiers must be unique. c. The value of an identifier may identify a set of entity instances. d. Identifiers may not be more than two attributes. e. An identifier in the E-R model is equivalent to a key in the relational model.

c. The value of an identifier may identify a set of entity instances.

A use case can be used to perform which of the following tasks? a. Implement business rules b. Fill the database with data c. Validate the data model d. Transform the data model into the database design e. Develop applications

c. Validate the data model

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? a. WHERE Hours RANGE 10 TO 50 b. WHERE Hours = MIN(10) and MAX(50) c. WHERE Hours BETWEEN 10 AND 50 d. WHERE Hours = 10 and Hours = 50 e. WHERE Hours IN [10, 50]

c. WHERE Hours BETWEEN 10 AND 50

Given the tables STUDENT(StudentID, StudentName, AdvisorID) ADVISOR(AdvisorID, AdvisorName, Office, Phone) which of the following SQL statements would be used to implant a join between the two tables? a. WHERE STUDENT MATCH ADVISOR b. WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID c. WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID d. WHERE STUDENT = ADVISOR e. WHERE STUDENT JOIN ADVISOR

c. WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent: a. a recursive entity relationship. b. a strong entity relationship c. a supertype / subtype relationship. d. a non-ID-dependent weak entity relationship. e. an ID-dependent weak entity relationship.

c. a supertype / subtype relationship.

The Microsoft Access 2013 form editor is a(n): a. WYSIWYG form editor. b. Web-based form editor. c. banded form editor. d. ASCII form editor. e. wizard-based form editor.

c. banded form editor.

Each attribute of an entity becomes a(n) ________ of a table. a. primary key b. foreign key c. column d. alternate key e. B or D

c. column

When the primary key of one relation is placed into a second relation, it is called a: a. candidate key b. field key. c. foreign key. d. referential integrity. e. relocated key.

c. foreign key

After a 1:1 relationship has been created between two tables in Microsoft Access, the Relationship Type of One-To-One appears: a. in the table object in the Relationships window. b. in the Relationship Type property of the foreign key column in table Design View. c. in the Edit Relationships dialog box. d. in the Relationship Type property of the primary key column in table Design View. e. in the Show Table dialog box.

c. in the Edit Relationships dialog box.

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the: a. recursive cardinality. b. degree. c. minimum cardinality. d. ordinality. e. maximum cardinality.

c. minimum cardinality.

When transforming an E-R data model into a relational database design, the key of the parent entity should be placed as part of the primary key into the child entity ________. a. when the child entity is non-ID-dependent b. when the child entity has a recursive relationship with the parent entity c. when the child entity is ID-dependent d. when the child entity has a 1:1 relationship with the parent entity e. when the child entity has a 1:N relationship with the parent entity

c. when the child entity is ID-dependent

By default, when Microsoft Access creates a relationship between two tables, it creates a(n): a. recursive relationship. b. association relationship. c. 1:1 relationship. d. 1:N relationship. e. N:M relationship.

d. 1:N relationship.

Which of the following would not be contained in a use case? a. A description of a task the user wants to perform b. Outputs generated by the system in performing a given task c. Inputs provided to the system to perform a task d. A prototype of the system performing a given task e. All of the above would be contained in a use case.

d. A prototype of the system performing a given task

The default file format for Microsoft Access 2013 database files is the: a. XBD format. b. Access XP format. c.SQL Server format. d. Access 2007 format. e. Access 2003 format.

d. Access 2007 format.

Which of the following cannot be done using the CONSTRAINT phrase? a. Define a foreign key. b. Create a single attribute primary key. c. Establish a referential integrity constraint. d. All of the above can be done using the CONSTRAINT phrase. e. None of the above can be done using the CONSTRAINT phrase.

d. All of the above can be done using the CONSTRAINT phrase.

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command? a. MODIFY TABLE b. SET TABLE c. BUILD TABLE d. CREATE TABLE e. CHANGE TABLE

d. CREATE TABLE

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? a. SORT b. REDUCE c. UNIQUE d. DISTINCT e. ORDER BY

d. DISTINCT

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT? a. REMOVE TABLE STUDENT; b. DELETE FROM STUDENT; c. DELETE TABLE STUDENT; d. DROP TABLE STUDENT; e. SELECT * FROM STUDENT THEN DROP;

d. DROP TABLE STUDENT;

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table? a. INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); b. INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; c. INPUT INTO STUDENT (123, 'Jones', 'Smith'); Correct Answer d. INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); e. INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith';

d. INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');

Which SQL keyword can be used in conjunction with wildcards to select partial values? a. SUBSTRING b. SELECT c. FIND d. LIKE e. SEARCH

d. LIKE

Which of the following is not true about null values? a. A null value can mean that no value for the field is appropriate. b. A null value can mean that the value is unknown. c. A null value is ambiguous. d. Null values cannot be avoided. e. A null value can mean that the value is known to be blank.

d. Null values cannot be avoided.

Which of the following standard SQL data types is not supported in Microsoft Access SQL? a. DateTime b. Integer c. Char(25) d. Numeric(5,3) e. VarChar(35)

d. Numeric(5,3)

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? a. OPEN JOIN b. INNER JOIN c. ODD JOIN d. OUTER JOIN e. COMBINE JOIN

d. OUTER JOIN

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance) what is the standard SQL query phrase to retrieve the Name and Phone Number of customers? a. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum b. SELECT * c. SELECT (Name, PhoneNum) d. SELECT Name, PhoneNum e. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)

d. SELECT Name, PhoneNum

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table? a. UPDATE Advisor = 'Smith'; b. MODIFY Advisor SET STUDENT = 'Smith'; c. SET STUDENT Advisor = 'Smith'; d. UPDATE STUDENT SET Advisor = 'Smith'; e. MODIFY STUDENT SET Advisor = 'Smith';

d. UPDATE STUDENT SET Advisor = 'Smith';

Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character? a. ! (exclamation mark) b. ? (question mark) c. % (percent sign) d. _ (underscore) e. ; (semi-colon)

d. _(Underscore)

Which of the following is not true about a relation? a. A relation is a two-dimensional table. b. The order of the rows of a relation is insignificant. c. A relation may not have duplicate rows. d. The cells of a relation must hold a single value. e. A relation may have duplicate column names.

e. A relation may have duplicate column names.

In the normalization process, if you find a candidate key that is not a determinant then you should: a. make the determinant of the functional dependency the primary key of the new relation. b. leave a copy of the determinant as a foreign key in the original relation. c. place the columns of the functional dependency in a new relation. d. all of the above e. none of the above

d. all of the above

The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: a. data view. b. implementation. c. application program. d. data model. e. relation design

d. data model

In the Entity-Relationship data model, all instances of an entity of a given type are grouped into: a. identifiers. b. entity attributes. c. entity objects. d. entity classes. e. class objects.

d. entity classes.

One of the important properties of a column is whether or not it is ________. a. subject to normalization b. found in more than one entity c. subject to denormalization d. required e. character or numeric

d. required

A surrogate key should be considered when ________. a. the key contains a number b. a composite key is required c. an index needs to be created d. the key contains a lengthy text field e. a relationship is M:N

d. the key contains a lengthy text field

In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that: a. the relation needs to be broken into two or more new relations. b. referential integrity constraints concerning the relation need to be established. c. the relation needs to have foreign keys added in order to be correctly linked to other relations. d.the relation is well formed. e. surrogate keys in the relation may not be correctly linked to other relations.

d.the relation is well formed.

The ideal primary key is ________. a. short b. numeric c. fixed d. A and B e. A, B, and C

e. A, B, and C

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system? a. Forms b. User interviews c. Business rules d. Use cases e. All of the above are sources for user requirements.

e. All of the above are sources for user requirements.

In many-to-many relationships in a relational database design, ________. a. the intersection table is ID-dependent on one of the parents b. the intersection table is ID-dependent on both of the parents c. the minimum cardinality from the intersection table to the parents is always M d. A and B e. B and C

e. B and C

An ID-dependent entity is: a. a special type of weak entity. b. an entity in which the identifier of the entity includes the identifier of another entity. c. an entity with a maximum cardinality of one. d. a strong entity. e. Both A and B

e. Both A and B

Conditions after the WHERE keyword require single quotes around the values for columns that have which data type? a. Char b. VarChar c. Integer d. Numeric e. Both A and B

e. Both A and B

In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates: a. a maximum cardinality of many. b. a minimum cardinality of one. c. a maximum cardinality of one. d. a minimum cardinality of zero. e. Both B and C

e. Both B and C

A surrogate key may be appropriate under which of the following circumstances? a. The available candidate keys would produce a lot of data duplication when representing relationships. b. The available candidate keys have little meaning to the users. c. The available candidate keys would be prone to typographical errors. d. The primary key is numeric. e. Both a and c

e. Both a and c

In many-to-many relationships in a relational database design, ________. a. the key of the child is placed as a foreign key into the parent b. the key of the parent is placed as a foreign key into the child c. the keys of both tables are placed in a third table d. the keys of both tables are joined into a composite key e. C and D

e. C and D

The Microsoft Access application generator is not responsible for: a. creating queries. b. creating forms. c. creating reports. d. storing queries. e. creating tables

e. Creating Tables

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY? a. DISTINCT b. WHERE c. SORT d. LIKE e. HAVING

e. HAVING

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? a. SORT BY Department DESC b. SORT BY Department REVERSE c. REVERSE Department d. SORT BY Department e. ORDER BY Department DESC

e. ORDER BY Department DESC

Which of the following is a function of the DBMS in a database system? a.Create and transmit queries b. Control applications c. Process Web page requests d. Create and process forms e. Perform backup and recover

e. Perform backup and recover

Which of the following is not true about primary keys? a. Primary keys are used to represent relationships. b. Primary keys can be defined using an SQL CONSTRAINT phrase. c. Primary keys cannot be null. d. Primary keys must be unique. e. Primary keys must be a single attribute.

e. Primary keys must be a single attribute

Which of the following would not be an example of database metadata? a. Properties of tables in a database b. Properties of columns c. Names of tables in a database d. Names of columns in a database and their associated tables e. Queries against records in the database tables

e. Queries against records in the database tables

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID, Cost) CAR (VehicleID, NumberOfSeats) TRUCK (VehicleID, CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE a. Association relationship b. Intersection relationship c. Recursive relationship d. Strong entity relationship e. Supertype/subtype relationship

e. Supertype/subtype relationship

Which of the following terms is synonymous with "relation"? a. Record b. Row c. Turple d. Attribute e. Table

e. Table

Which of the following activities is not performed during the implementation phase of developing a database system? a. Creating forms b. Writing application programs c. Filling the database with data d. Creating reports e. Transforming the data model into a database design

e. Transforming the data model into a database design

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance) what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50? a. WHERE (CUSTOMER-AcctBalance > 50) b. WHERE CUSTOMER-AcctBalance > 50 c. WHERE (AcctBalance > 50) d. HAVING AcctBalance > 50 e. WHERE AcctBalance > 50

e. WHERE AcctBalance > 50

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called: a. a key matching constraint. b. a functional dependency. c. normalization. d. synchronization. e. a referential integrity constraint.

e. a referential integrity constraint.

The first step in transforming an extended E-R model into a relational database design is to ________. a. evaluate the entities against the normalization criteria b. remove any recursive relationships c. create a table for each relationship d. document referential integrity constraints e. create a table for each entity

e. create a table for each entity

Microsoft SQL Server is an example of a: a. database. b. list manager. c. data manipulation system. d. table. e.database management system.

e. database management system.

The number of entity classes involved in a relationship is known as the relationship's: a. class. b. minimum cardinality. c. maximum cardinality. d. ordinality. e. degree.

e. degree

One important relational design principle is that: a. every determinant must be functionally dependent on the primary key. b. every candidate key must not be a determinant. c. every primary key must be a surrogate key. d. every primary key must be functionally dependent on every determinant. e. every determinant must be a candidate key.

e. every determinant must be a candidate key.

In the normalization process, if you find a candidate key that is not a primary key then you should: a. leave a copy of the determinant as a foreign key in the original relation. b. place the columns of the functional dependency in a new relation. c. make the determinant of the functional dependency the primary key of the new relation. d. all of the above e. none of the above

e. none of the above

Which of the following data types used in SQL would define a numeric field of the pattern 99.99? a. integer(5,2) b. numeric(5,2) c. integer(2,2) d. numeric(4,2) e. numeric(2,2)

e. numeric (2,2)

In Microsoft Access, standard SQL table creation syntax items not supported by Access SQL can generally be implemented by: a. setting the relationship properties in the Edit Relationship dialog box. b. setting the Data Types in Access table Design View. c. setting the referential integrity properties in the Edit Relationship dialog box. d. running an ALTER TABLE query in Access SQL. e. setting the field properties in Access table Design View.

e. setting the field properties in Access table Design View.

Microsoft Access can be used to build a prototype database, which allows users: a. to determine the functional dependencies in the data model. b. to draw a crow's foot E-R diagram themselves. c. to normalize the tables in the E-R diagram. d. to determine the appropriate primary and foreign keys in the data model. e. to validate the data model by demonstrating the consequences of data modeling decisions.

e. to validate the data model by demonstrating the consequences of data modeling decisions.

A dashed line between entities indicates: a. a minimum cardinality of zero. b. a minimum cardinality of one. c. a unique identifier. d. an identifying relationship. e.a nonidentifying relationship.

e.a nonidentifying relationship.

The Microsoft Access 2013 report editor is a(n): a. wizard-based report editor. b. ASCII report editor. c. WYSIWYG report editor. d. Web-based report editor. e.banded report editor.

e.banded report editor.