Modern Database Exam 1 Chapter 1, Modern Database Exam 1 Chapter 2

24) In the normalization process, if you find a candidate key that is not a primary key, then you have determined that the relation needs to be broken into two or more other relations.

FALSE

24) Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.

FALSE

25) There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.

FALSE

26) Since Microsoft Access is a personal database, it is not subject to the modification problems that occur in other relational databases.

FALSE

28) In Microsoft Access, foreign keys are designated by using the Foreign Key button in the toolbar.

FALSE

29) In Microsoft Access, a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

FALSE

29) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

FALSE

3) An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.

FALSE

30) Microsoft Access forms can only contain data from one table.

FALSE

4) An advantage of keeping data in lists is that if you add a new row of data to the list, you will never have null values occurring for any data item in the row.

FALSE

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

FALSE

6) A key must be unique.

FALSE

6) A relational database stores data in the form of lists.

FALSE

7) Usually, a database table containing both rows and columns is designed to store data for exactly two themes.

FALSE

8) Candidate keys may or may not be unique.

FALSE

9) SQL stands for Structural Question Language.

FALSE

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

TRUE

23) In the normalization process, it is necessary to identify all the determinants in a relation.

TRUE

25) In the normalization process, if you find that every determinant in a relation is a candidate key, then you have determined that the relation is well formed.

TRUE

26) Microsoft Access 2013 is a personal database that combines a DBMS with an application generator.

TRUE

27) In Microsoft Access, relationships between tables are created in the Relationships window.

TRUE

27) The Microsoft Access 2013 application generator provides the ability to create and store forms, reports, and queries.

TRUE

28) Microsoft Access 2013 databases are stored using the file extension .accdb.

TRUE

3) Every relation is a table, but not every table is a relation.

TRUE

30) Microsoft Access 2013 uses the AutoNumber data type to create surrogate keys.

TRUE

4) Every cell in a relation can hold only a single value.

TRUE

5) One problem with storing duplicated data is the potential for inconsistent values.

TRUE

7) To be considered a composite key, a key must contain at least two attributes.

TRUE

8) By separating data into tables containing data on only one theme each, making changes to the data is simplified.

TRUE

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

TRUE

15) Metadata is the user data stored in the database.

FALSE

34) Which of the following terms is synonymous with "relation"? A) Attribute B) Table C) Record D) Row E) Tuple

B

16) Most organizations create and use their own database management system (DBMS) products.

FALSE

18) Normalization is the process of removing all functional dependencies from a relation.

FALSE

18) Referential integrity constraints must be enforced by the application program.

FALSE

19) Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.

FALSE

2) Every table is a relation, but not every relation is a table.

FALSE

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

FALSE

43) Which of the following is a function of the database application in a database system? A) Create and transmit queries B) Update database data C) Maintain database structures D) Create tables E) Backup and restore data

A

21) In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task.

FALSE

22) In the normalization process, it is not necessary to identify all the functional dependencies in a relation.

FALSE

43) Which of the following is not true of surrogate keys? A) They are meaningful to the users. B) They are numeric. C) They are usually generated by the DBMS. D) They are unique. E) They are usually hidden on forms and reports.

A

36) The statement SELECT STUDENT.StudentNumber, STUDENT.StudentName FROM STUDENT WHERE STUDENT.StudentNumber = S12345678 is an example of: A) QBE. B) SQL. C) QLE. D) C++. E) Java.

B

17) 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).

TRUE

17) The DBMS is used to create the database itself.

TRUE

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

TRUE

39) When the primary key of one relation is placed into a second relation, it is called a: A) field key. B) referential integrity. C) foreign key. D) candidate key. E) relocated key.

C

48) One important relational design principle is that: A) every determinant must be a candidate key. B) every candidate key must not be a determinant. C) every primary key must be a surrogate key. D) every determinant must be functionally dependent on the primary key. E) every primary key must be functionally dependent on every determinant.

A

49) The default file format for Microsoft Access 2013 database files is the: A) Access 2007 format. B) Access 2003 format. C) Access XP format. D) SQL Server format. E) XBD format.

A

36) A key that contains more than one attribute is called a(n): A) composite key. B) complex key. C) multi-key. D) n-key. E) candidate key.

A

2) A possible problem with keeping data in lists is that if you delete a row of data from a list, you may also delete some data items that you want to keep.

TRUE

38) A relational database is: A) a self-describing collection of related tables. B) a collection of forms and reports that support a given purpose. C) a library of queries and data files for querying. D) a set of applications and the data sets for those applications. E) a set of metadata.

A

51) The first step of the normalization process is to: A) identify all the candidate keys of a relation. B) identify all the foreign keys of a relation. C) identify all the functional dependencies of a relation. D) identify all the determinants of a relation. E) split the relation into two or more new relations.

A

55) 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 is well formed. B) the relation needs to be broken into two or more new relations. C) surrogate keys in the relation may not be correctly linked to other relations. D) the relation needs to have foreign keys added in order to be correctly linked to other relations. E) referential integrity constraints concerning the relation need to be established.

A

20) The DBMS receives data update requests from the application program.

TRUE

32) Which of the following is true about a relation? A) The order of the columns in a relation must go from largest to smallest. B) All entries in any column must be of the same kind. C) A relation may have duplicate column names. D) A relation may have duplicate rows. E) A relation may have multiple names.

B

41) 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) normalization. B) a referential integrity constraint. C) a key matching constraint. D) a functional dependency. E) synchronization.

B

44) Which of the following is not a function of the database application in a database system? A) Execute application logic B) Control concurrency C) Create and process forms D) Create and transmit queries E) Create and process reports

B

45) Microsoft SQL Server is an example of a: A) database. B) database management system. C) data manipulation system. D) table. E) list manager.

B

46) Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage) which of the following statements is not known to be true? A) MedicineCode is a determinant. B) MedicineName is a determinant. C) Manufacturer is functionally dependent on MedicineCode. D) ShelfLife is functionally dependent on MedicineCode. E) MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode).

B

46) Microsoft Access is a personal database system, and a personal database system is characterized by: A) the DBMS removing the metadata from the database. B) the DBMS product taking the role of the DBMS and the database application generator. C) the database being stored inside the DBMS. D) the DBMS product being limited to a maximum of ten tables in any given database. E) the DBMS not supporting indexes.

B

50) A table that meets the requirements of a relation is said to be in which normal form? A) Relational normal form (RNF) B) First normal form C) Second normal form D) Boyce-Codd normal form E) Domain/key normal form

B

52) In the normalization process, it is not necessary to: A) identify all the candidate keys of a relation. B) identify all the foreign keys of a relation. C) identify all the functional dependencies of a relation. D) identify all the determinants of a relation. E) determine if every determinant is a candidate key.

B

21) The first step of the normalization process is to identify all the candidate keys of a relation.

TRUE

31) Which of the following is not true about a relation? A) A relation is a two-dimensional table. B) The cells of a relation must hold a single value. C) A relation may have duplicate column names. D) A relation may not have duplicate rows. E) The order of the rows of a relation is insignificant.

C

35) SQL stands for: A) Standard Query Language. B) Structural Question Language. C) Structured Query Language. D) Standard Question Language. E) Structured Question Language.

C

37) Which of the following is not a basic component of a database system? A) Database B) User C) ERD D) DBMS E) Data applications

C

40) 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) SID is both a primary key and a foreign key. B) AdvisorName is a determinant. C) AdvisorID is a foreign key. D) Phone is a candidate key. E) Major is a candidate key.

C

41) The creation of a database and its tables is a function of which component of the database system? A) Users B) Application C) DBMS D) Database E) Web server

C

48) Microsoft Access 2013 database files are stored using the file extension: A) .adb. B) .asp. C) .accdb. D) .mdb. E) .sql.

C

49) During the normalization process, the remedy for a relation that is not well formed is to: A) create a surrogate key. B) create a functional dependency. C) break it into two or more relations that are well formed. D) combine it with another relation that is well formed. E) convert it into a list.

C

50) The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a: A) foreign key. B) primary key. C) surrogate key. D) spare key. E) secondary key.

C

57) In Microsoft Access, relationships between tables are created: A) by the Relationships button on the Create command tab. B) by the Relationships button on the Home command tab. C) in the Relationships window. D) in the Table window of the table containing the primary key. E) in the Table window of the table containing the foreign key.

C

58) In Microsoft Access, a relationship between two tables is created: A) by entering the name of the foreign key in the appropriate table in Design View. B) by entering the name of the primary key in the appropriate table in Design View. C) by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window. D) by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window. E) by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window.

C

22) In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.

TRUE

33) Today almost every commercial database is based on: A) lists. B) the hierarchical model. C) the linked-list model. D) the relational model. E) the object-oriented model.

D

33) Which of the following terms is synonymous with "tuple"? A) Attribute B) Table C) Field D) Row E) Relation

D

34) A relational database stores data in the form of: A) lists. B) forms. C) columns. D) tables. E) spreadsheets.

D

42) Which of the following is a function of the DBMS in a database system? A) Create and transmit queries B) Control applications C) Create and process forms D) Perform backup and recover E) Process Web page requests

D

44) In SQL Server, the starting value of a surrogate key is called the: A) Identity. B) Identity Increment. C) Identity Start. D) Identity Seed. E) Identity Property.

D

47) The Microsoft Access application generator is not responsible for: A) creating forms. B) creating reports. C) creating queries. D) creating tables. E) storing queries.

D

54) In the normalization process, if you find a candidate key that is not a determinant then you should: A) place the columns of the functional dependency in a new relation. B) make the determinant of the functional dependency the primary key of the new relation. C) leave a copy of the determinant as a foreign key in the original relation. D) All of the above E) None of the above

D

56) Although Microsoft Access is a personal database, it is still subject to the following modification problem(s): A) problems adding data. B) problems changing data. C) problems deleting data. D) All of the above E) None of the above

D

60) In Microsoft Access, the relationship between two tables is not actually created until: A) the OK button in the Create Relationships dialog box is clicked. B) the Create button in the Create Relationships dialog box is clicked. C) the OK button in the Edit Relationships dialog box is clicked. D) the Create button in the Edit Relationships dialog box is clicked. E) the Join button in the Edit Relationships dialog box is clicked.

D

31) A database may be used to help people: A) track which student is assigned to a particular advisor. B) know the current inventory levels of products their company sells. C) check on the estimated arrival time of an incoming flight at an airport. D) look up their checking account balance over the Internet. E) All of the above

E

32) Which of the following problems associated with storing data in a list is avoided by storing data in a relational database? A) Maintaining the data may require changing the same data value in many locations B) Inconsistency when a data item is used multiple times C) Inability to store partial data D) Duplication of data items E) All of the above

E

35) Which of the following is true about a key? A) It may be unique. B) It may be non-unique. C) In may identify more than one row. D) Both A and B E) All of the above

E

37) A primary key is: A) required to be unique. B) used to represent rows in relationships. C) a candidate key. D) used to identify unique rows. E) All of the above

E

38) A candidate key is: A) required to be unique. B) used to represent rows in relationships. C) a candidate to be the primary key. D) Both A and B E) All of the above

E

39) The component of a database that makes it self-describing is the: A) related tables. B) applications. C) library. D) data set. E) metadata.

E

40) Which of the following would not be an example of database metadata? A) Names of tables in a database B) Properties of tables in a database C) Names of columns in a database and their associated tables D) Properties of columns E) Queries against records in the database tables

E

42) 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 primary key is numeric. C) The available candidate keys would be prone to typographical errors. D) The available candidate keys have little meaning to the users. E) Both A and C

E

45) Which of the following is not true about null values? A) A null value can mean that the value is unknown. B) A null value is ambiguous. C) A null value can mean that the value is known to be blank. D) A null value can mean that no value for the field is appropriate. E) Null values cannot be avoided.

E

47) 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) BuildingName → (RoomNumber, Capacity, Department) B) RoomNumber → (BuildingName, Department, Capacity) C) (Department, Capacity) → (BuildingName, RoomNumber) D) (BuildingName, Capacity) → (Department, RoomNumber) E) (BuildingName, RoomNumber) → (Capacity, Department)

E

53) In the normalization process, if you find a candidate key that is not a primary key then you should: A) place the columns of the functional dependency in a new relation. B) make the determinant of the functional dependency the primary key of the new relation. C) leave a copy of the determinant as a foreign key in the original relation. D) All of the above E) None of the above

E

59) In Microsoft Access, referential integrity constraints are created: A) by setting a property value on the primary key in the table which contains it. B) by setting a property value on the foreign key in the table which contains it. C) by setting a property value on the primary key in the Relationships window. D) by setting a property value on the foreign key in the Relationships window. E) by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box.

E

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

FALSE

1) While the relational model for databases appears to hold much promise, few commercial databases have implemented it.

FALSE

11) Although users use database systems, they are not considered part of a database system.

FALSE

11) When used to represent a relationship, the primary key must have the same name as the corresponding foreign key.

FALSE

12) A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

FALSE

13) 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.

FALSE

14) A database is self-describing because the user maintains a record of the database structure outside the database itself.

FALSE

1) The purpose of a database is to help people keep track of things.

TRUE

10) Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).

TRUE

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

TRUE

12) Surrogate key values have no meaning to the users.

TRUE

13) A relational database can be defined as a self-describing collection of related tables.

TRUE

15) Null values can cause problems because they are ambiguous.

TRUE

16) If the condition exists such that knowing the value of attribute X determines the value of attribute Y, then attribute Y is functionally dependent on attribute X.

TRUE