Question 1

Typically,a database management system is managed by a person called a _____,who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

Accepted Answer

A)   database administrator
B)   business intelligence analyst
C)   database consumer
D)   big data analystE) All of the above
F) B) and D)

Question 2

A repeating group is a set of one or more fields that can occur only once in a single record,with each occurrence having the same value.

Accepted Answer

A) True 
 B)False  False

Question 3

A subschema is a view of the database used by one or more systems or users.

Accepted Answer

A) True 
 B)False

Question 4

To bridge the gap between a database and the Internet,it is necessary to use _____,which is software that integrates different applications and allows them to exchange data.

Accepted Answer

A)   middleware
B)   a stack
C)   a server
D)   firmwareE) None of the above
F) All of the above

Question 5

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

Accepted Answer

A)   Encapsulation
B)   Normalization
C)   Abstraction
D)   EncryptionE) A) and D)
F) B) and C)

Question 6

With a _____,users provide an example of the data requested.

Accepted Answer

A)   query language
B)   data table
C)   query by example language
D)   data frameE) All of the above
F) A) and B)

Question 7

To resolve potential database connectivity and access problems,companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Accepted Answer

A) True 
 B)False

Question 8

A common method of cardinality notation is called _____ because of the shapes,which include circles,bars,and symbols that indicate various possibilities.

Accepted Answer

A)   big O notation
B)   dark resistor's notation
C)   crow's foot notation
D)   hash topology notationE) B) and D)
F) C) and D)

Question 9

In a table or file,each column represents a record and each row represents a field.

Accepted Answer

A) True 
 B)False

Question 10

A logical record is a set of field values that describes a single person,place,thing,or event.

Accepted Answer

A) True 
 B)False

Question 11

Designing tables is easier if a _____ is used to show a table's structure,fields,and primary key.

Accepted Answer

A)   distinct notation format
B)   multifaceted notation format
C)   viewport notation format
D)   standard notation formatE) C) and D)
F) A) and B)

Question 12

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

Accepted Answer

A)   procedural language
B)   query by example language
C)   query language
D)   imperative languageE) A) and D)
F) C) and D)

Question 13

A table design that contains a repeating group is called _____.

Accepted Answer

A)   normalized
B)   unnormalized
C)   unsynchronized
D)   synchronizedE) A) and B)
F) All of the above

Question 14

Like a primary key,a foreign key must be unique.

Accepted Answer

A) True 
 B)False

Question 15

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.

Accepted Answer

A)   Scalability
B)   Compatibility
C)   Cardinality
D)   FunctionalityE) A) and D)
F) A) and B)

Question 16

Describe how middleware is used.

Accepted Answer

To access data in a web-based system,the database must be connected to the Internet or intranet.The database and the Internet speak two different languages,however.Databases are created and managed by using various languages and commands that have nothing to do with HTML,which is the language of the web.The objective is to connect the database to the web and enable data to be viewed and updated.
To bridge the gap,it is necessary to use middleware,which is a software that integrates different applications and allows them to exchange data.Middleware can interpret client requests in HTML form and translate the requests into commands that the database can execute.When the database responds to the commands,middleware translates the results into HTML pages that can be displayed by the user's browser.

Question 17

Most magazine subscription codes are action codes.

Accepted Answer

A) True 
 B)False  False

Question 18

A web-based data design requires users to have powerful workstations.

Accepted Answer

A) True 
 B)False

Question 19

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

Accepted Answer

A) True 
 B)False

Question 20

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

Accepted Answer

A)   second normal form
B)   zeroth normal form
C)   third normal form
D)   fourth normal formE) A) and D)
F) B) and C)

Exam 9: Data Design

Typically,a database management system is managed by a person called a _____,who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

Correct Answer
verified

A repeating group is a set of one or more fields that can occur only once in a single record,with each occurrence having the same value.

Correct Answer
verified
False

A subschema is a view of the database used by one or more systems or users.

Correct Answer
verified

To bridge the gap between a database and the Internet,it is necessary to use _____,which is software that integrates different applications and allows them to exchange data.

Correct Answer
verified

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

Correct Answer
verified

With a _____,users provide an example of the data requested.

Correct Answer
verified

To resolve potential database connectivity and access problems,companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Correct Answer
verified

A common method of cardinality notation is called _____ because of the shapes,which include circles,bars,and symbols that indicate various possibilities.

Correct Answer
verified

In a table or file,each column represents a record and each row represents a field.

Correct Answer
verified

A logical record is a set of field values that describes a single person,place,thing,or event.

Correct Answer
verified

Designing tables is easier if a _____ is used to show a table's structure,fields,and primary key.

Correct Answer
verified

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

Correct Answer
verified

A table design that contains a repeating group is called _____.

Correct Answer
verified

Like a primary key,a foreign key must be unique.

Correct Answer
verified

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.

Correct Answer
verified

Describe how middleware is used.

Most magazine subscription codes are action codes.

Correct Answer
verified
False

A web-based data design requires users to have powerful workstations.

Correct Answer
verified

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

Correct Answer
verified

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

Correct Answer
verified

Exam 9: Data Design

Typically,a database management system is managed by a person called a _____,who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

Correct AnswerverifiedShow Answer

A repeating group is a set of one or more fields that can occur only once in a single record,with each occurrence having the same value.

Correct AnswerverifiedFalse

A subschema is a view of the database used by one or more systems or users.

Correct AnswerverifiedShow Answer

To bridge the gap between a database and the Internet,it is necessary to use _____,which is software that integrates different applications and allows them to exchange data.

Correct AnswerverifiedShow Answer

_____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

Correct AnswerverifiedShow Answer

With a _____,users provide an example of the data requested.

Correct AnswerverifiedShow Answer

To resolve potential database connectivity and access problems,companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Correct AnswerverifiedShow Answer

A common method of cardinality notation is called _____ because of the shapes,which include circles,bars,and symbols that indicate various possibilities.

Correct AnswerverifiedShow Answer

In a table or file,each column represents a record and each row represents a field.

Correct AnswerverifiedShow Answer

A logical record is a set of field values that describes a single person,place,thing,or event.

Correct AnswerverifiedShow Answer

Designing tables is easier if a _____ is used to show a table's structure,fields,and primary key.

Correct AnswerverifiedShow Answer

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

Correct AnswerverifiedShow Answer

A table design that contains a repeating group is called _____.

Correct AnswerverifiedShow Answer

Like a primary key,a foreign key must be unique.

Correct AnswerverifiedShow Answer

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.

Correct AnswerverifiedShow Answer

Describe how middleware is used.

Most magazine subscription codes are action codes.

Correct AnswerverifiedFalse

A web-based data design requires users to have powerful workstations.

Correct AnswerverifiedShow Answer

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

Correct AnswerverifiedShow Answer

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified