Deck 9: Designing the Database

Question 1

A phased database development and deployment (using iterative development)is usually the safest approach to deploying the best database solution.​

Answer 1

False

Question 2

​Invented keys that are not automatically generated in a relational database are dangerous and require careful scrutiny.

Answer 2

True

Question 3

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.​

Answer 3

False

Question 4

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.​

Question 5

Relationships between tables is usually indicated through the use of a foreign key.​

Question 6

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.​

Question 7

In an iterative approach to software development,it is usually best to develop the database in the first few iterations.​

Question 8

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.​

Question 9

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.​

Question 10

A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table.​

Question 11

Problem domain modeling and database normalization are incompatible techniques for relational database design.​

Question 12

Every table in a relational database must have a foreign key.​

Question 13

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if no non-key field is functionally dependent on any other non-key field.​

Question 14

A local business office with a small database which is only used by two or three users would most probably implement a desktop DBMS.​

Question 15

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.​

Question 16

The domain data in a database is sometimes referred to as metadata.​

Question 17

To ensure that the database is designed correctly,an important member of the project team is the data administrator.​

Question 18

A relation describes the structure,content,and access controls of a physical data store or database.​

Question 19

Every database in a DBMS consists of two separate data stores.​

Question 20

A relational database management system stores data in tables.​

Question 21

Which of the following is NOT a component or function of a typical database management system (DBMS)?​

A)Low-level process management
B)​Direct query processor
C)Application program interface processor
D)​Administrative interface

Question 22

Each class on an class diagram is represented by a(n)____ in a relational database.​

A)attribute
B)​row
C)table
D)​column

Question 23

___________  is where the value in one field determines the value in another field in the same record.​

A)First normal form
B)​Second normal form
C)Referential integrity​
D)​Functional dependency

Question 24

____ is a consistent relational database state in which every foreign key value also exists as a primary key value.​

A)First normal form (1NF)
B)​Database synchronization
C)Function dependency
D)​Referential integrity

Question 25

In a one-to-many association the primary key of the "many" class is placed as a foreign key in the "one" class.​

Question 26

Including a total amount field as the sum of other fields in a table is a violation of second normal form.​

Question 27

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.​

A)first
B)​second
C)third
D)​fourth

Question 28

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.​

A)columns
B)foreign keys​
C)rows
D)​values

Question 29

Referential integrity is normally enforced by the ____.​

A)application programmer
B)​database management system
C)operating system
D)​user

Question 30

A(n)____ is a field or set of fields used to uniquely identify each row.​

A)primary key
B)​foreign key
C)object identifier
D)​attribute

Question 31

Data elements in a relational database are organized into ____.​

A)attributes
B)​objects
C)tables
D)​tuples

Question 32

​A separate relation must be created to store the attributes of a ____ relationship among two other classes.

A)one-to-one
B)​one-to-many
C)many-to-many
D)​not any (not necessary)

Question 33

____ are a critical element of relational database design because they are the bases for representing relationships among tables.​

A)Keys
B)​Attributes
C)Fields
D)​Tables

Question 34

A write lock on a database allows other users to read the data,but they cannot update any data.​

Question 35

A(n)____ describes the structure,content,and access controls of a physical data store or database.​

A)relation
B)​DBMS
C)schema
D)​attribute

Question 36

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.​

A)first
B)​second
C)third
D)​fourth

Question 37

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.​

A)first
B)​second
C)third
D)​fourth

Question 38

In a relational database,a row can be referred to as a(n)____.​

A)field
B)tuple​
C)attribute
D)​relation

Question 39

A(n)____ is a field or set of fields stored in one table that also exists as a primary key in another table.​

A)primary key
B)​foreign key
C)object identifier
D)​candidate key

Question 40

​One column of a table in a relational database is called a(n)____.

A)attribute
B)​relation
C)tuple
D)​element

Question 41

Which of the following contains both global and local schemas with distinct DBMSs?​

A)Decentralized database
B)Distributed database​
C)Heterogeneous distributed database
D)Homogeneous distributed database​

Question 42

In a database a two-dimensional data structure consisting of columns and rows is called a(n)_______.​

Question 43

Which is not one of the responsibilities of the DA?​

A)Provide data naming standards
B)​Keep track of who owns the data
C)Set up standards for data validation
D)​Establish user authentication for data access

Question 44

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.​

Question 45

Non-key ("bad")redundancy can be systematically identified and eliminated from a relational database by ____________________ of the database.​

Question 46

Which of the following is not a synonym of the others?​

A)row
B)​Tuple
C)record
D)​field

Question 47

​What can be said about the following relational database table (key is underlined): (Choose the most correct answer)
StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

A)Not in any valid normal form
B)​In First Normal Form
C)In First and Second Normal Form
D)​​In First, Second, and Third Normal Form

Question 48

The condition that requires that every value in a foreign key must have an equivalent value as the primary key in another table is called ________ ______.​

Question 49

A(n)____________________ describes the structure,content,and access controls of a physical data store or database.​

Question 50

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.​

Question 51

A database lock that does not allow another user to update the data is called what?​

A)Write lock
B)​Shared lock
C)Transaction lock
D)​Database lock

Question 52

Microsoft SQL Server is an example of what?​

A)An application server
B)​A database management system
C)A programming language compiler
D)​A Web server

Question 53

A data type that is supported directly by computer hardware or a programming language is called a(n)_______  data type.​

Question 54

In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________.​

A)data replication
B)​horizontal partitioning
C)vertical partitioning
D)​synchronization

Question 55

In a many-to-many association,the primary key of the created table consists of which of the following?

A)The primary keys of the associated tables
B)An invented key with computer generated values​
C)The foreign keys of the associated tables
D)​Does not need a key field

Question 56

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)​ CourseSectionID,StudentID,Grade,StudentName

A)Not in any valid normal form
B)​In First Normal Form
C)In First and Second Normal Form
D)​​In First, Second, and Third Normal Form

Question 57

In a distributed database when the data is divided so that separate columns of the same table are at distinct locations that is referred to as _________.

A)data replication
B)​horizontal partitioning
C)vertical partitioning
D)​synchronization

Question 58

Which is NOT one of the responsibilities of the database administrator?​

A)Backup the database
B)​Do performance tuning
C)Set up user authentication
D)​Determine data confidentiality

Question 59

A field in a relational table called "address" would be an example of what?​

A)candidate data type
B)​primitive data type
C)compound data type
D)​complex data type

Question 60

Which of the following is not a synonym of the others?​

A)column
B)​attribute
C)field
D)​tuple

Question 61

A software system whose purpose is to manage and control the data in a database is called a(n)_______ _______ ______.​

Question 62

A constraint which is stored in the schema and which ensures that all foreign keys have associated primary keys is called a(n)______ ______ ______.​

Question 63

If there is more than one field in a database table that is unique for all rows only one of those fields will be identified as the ______ ______ for the table.​

Question 64

A _______ is an integrated collection of stored data that is centrally managed and controlled​

Question 65

​In a database table a tuple is the same thing as a(n)______.

Question 66

An attribute or set of attributes that uniquely define the rows in a table is called a(n)______.​

Question 67

A formal technique for transforming a relational schema to an equivalent one that eliminates data anomalies is called _______.​

Question 68

______ ______ ______ is a query language used to access and update the data in a relational database.​

Question 69

A specific type of DBMS that organizes the data into tables is called a(n)______ ______ _____ _____.​

Question 70

If there is more than one field in a database table that is unique for all rows each one may be called a(n)______ _____.​

Question 71

The person who is in charge of the safety and operation of the DBMS is called the _____ _____.​

Question 72

When it is necessary to update one database copy with changes made to the other database,it is called _________.​

Question 73

A database table is in _____ _____ _____ if all non-key attributes are functionally dependent on the entire key.​

Question 74

A data type that is defined by extending or combining other data types is called a(n)______  data type.​

Question 75

The person who is in charge of the structure and integrity of the data is called the _____ _____.​

Question 76

GUID stands for ______ ______ ______.​

Question 77

​What does SQL stand for?

Question 78

What does DBA stand for?​

Question 79

In a database table a column is the same thing as a(n)______.​

Question 80

What does DBMS stand for?​