Question 1

3NF requires that a table be in 2NF and have transitive dependencies.

Accepted Answer

3NF requires that a table be in 2NF and have no transitive dependencies.

Question 2

Normalization involves altering a table so that it satisfies one or more of four normal forms, or sets of rules for constructing a well-designed database.

Accepted Answer

False

Question 3

In database management systems, a particular way of looking at a database is sometimes called a(n) ____.&#10;A) segment&#10;B) identity&#10;C) view&#10;D) value

Accepted Answer

A view is a particular way of looking at a database that can limit the amount of data displayed or show data from different tables as if they were a single table. Segments refer to a section or portion of a database, while identity and value are not terms commonly associated with a way of looking at databases. Therefore, the correct answer is option C) view.

Question 4

Database software recognizes the distinction between text and numeric data.

Accepted Answer

Yes, database software is capable of recognizing the difference between text and numeric data. This is important as numeric data is often used for calculations and sorting, while text data is used for labeling and identification purposes.

Question 5

Database software provides the means to ensure that data integrity is enforced.

Accepted Answer

Database software includes features such as constraints, relationships and validation rules to ensure that data remains consistent and accurate. This helps to maintain data integrity.

Question 6

Connecting two tables based on the values in a common column is called a(n) ____ operation.&#10;A) union&#10;B) join&#10;C) intersection&#10;D) liberation

Accepted Answer

A join operation connects two tables based on a common column, allowing information from both tables to be combined into one result set. The other options (union, intersection, liberation) are not applicable for connecting two tables based on a common column.

Question 7

A symbol that means &#34;any&#34; or &#34;all&#34; is known as a ____.&#10;A) placeholder&#10;B) token&#10;C) substitution&#10;D) wildcard

Accepted Answer

The symbol that means "any" or "all" is known as a wildcard. It is used in computer programming to represent one or more characters in a string of text. This symbol is often represented by the asterisk (*) or question mark (?) and allows for flexible searching and filtering of data.

Question 8

When a field in a database contains a null value, it means that ____.&#10;A) the field holds zeros&#10;B) the field holds spaces&#10;C) no data has been entered in the field&#10;D) the field holds asterisks

Accepted Answer

When a field in a database contains a null value, it means that no data has been entered in the field.

Question 9

In a database, the files often are called ____ because you can arrange their contents in rows and columns.&#10;A) sheets&#10;B) pages&#10;C) forms&#10;D) tables

Accepted Answer

In a database, the files are represented as tables, with rows and columns to organize and display the data. Choice A refers to a format used in spreadsheet applications, while choice B refers to a physical or digital page of content. Choice C may be used to display data in a database application, but it is not synonymous with a file or table.

Question 10

In some database software packages, such as Microsoft Access, you indicate a primary key simply by selecting a column name and clicking a button that is labeled with a key icon.

Accepted Answer

This is correct. In Microsoft Access, you can indicate a primary key by selecting a column name and clicking the primary key icon, which looks like a key.

Question 11

Structured Query Language is a commonly used language for accessing data in database tables.

Accepted Answer

The answer of Structured Query Language is a commonly used...

Question 12

A common reason you create a one-to-one relationship is security.

Accepted Answer

The answer of A common reason you create a one-to-one...

Question 13

If an employee record contains both a company-assigned employee ID and a Social Security number, then both columns are ____ keys.&#10;A) primary&#10;B) candidate&#10;C) secondary&#10;D) foreign

Accepted Answer

The answer of If an employee record contains both a...

Question 14

In many database systems, some &#34;deleted&#34; records are not physically removed, but they are just marked as deleted so that they will not be used to process active records.

Accepted Answer

The answer of In many database systems, some &#34;deleted&#34; records...

Question 15

After you choose a primary key from among candidate keys, the remaining candidate keys become ____ keys.&#10;A) primary&#10;B) secondary&#10;C) alternate&#10;D) candidate

Accepted Answer

The answer of After you choose a primary key from...

Question 16

A key that is constructed from multiple columns is called a compound key or ____ key.&#10;A) composite&#10;B) combined&#10;C) joined&#10;D) joint

Accepted Answer

The answer of A key that is constructed from multiple...

Question 17

Entering data into an existing table is not difficult, but it requires a good deal of time and accurate typing.

Accepted Answer

The answer of Entering data into an existing table is...

Question 18

Some database designers insert an exclamation point after the key instead of underlining it.

Accepted Answer

The answer of Some database designers insert an exclamation point...

Question 19

Depending on the software you use, you might create a query by filling in blanks in a process called ____.&#10;A) query by example&#10;B) query by reference&#10;C) query by demonstration&#10;D) query by comparison

Accepted Answer

The answer of Depending on the software you use, you...

Question 20

The basic form of the SQL statement that retrieves selected records from a table is ____.&#10;A) GET-FROM-WHERE&#10;B) SELECT-FROM-WHERE&#10;C) RETRIEVE-FROM-WHERE&#10;D) SELECTION-FROM-WHERE

Accepted Answer

The answer of The basic form of the SQL statement...

Question 21

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.&#10;A) permissions&#10;B) controls&#10;C) locks&#10;D) attributes

Accepted Answer

The answer of The ____ assigned to a user indicate...

Question 22

A table that contains repeating groups is ____.&#10;A) unnormalized&#10;B) normalized&#10;C) simplified&#10;D) non-normalized

Accepted Answer

The answer of A table that contains repeating groups is...

Question 23

A(n) ____ key is a column that is not a key in a table, but it contains an attribute that is a key in a related table.&#10;A) alternate&#10;B) candidate&#10;C) foreign&#10;D) primary

Accepted Answer

The answer of A(n) ____ key is a column that...

Question 24

A primary key should be ____________________, meaning that a value does not change during normal operation.

Accepted Answer

The answer of A primary key should be ____________________, meaning...

Question 25

A ____________________ is a binary large object, which is a collection of binary data such as an image, video, or audio clip stored in a database system.

Accepted Answer

The answer of A ____________________ is a binary large object,...

Question 26

A ____ relationship is the most common type of relationship between tables.&#10;A) one-to-many&#10;B) one-to-one&#10;C) many-to-one&#10;D) many-to-many

Accepted Answer

The answer of A ____ relationship is the most common...

Question 27

A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.&#10;A) conversion&#10;B) recursion&#10;C) dependency&#10;D) anomaly

Accepted Answer

The answer of A transitive ____ occurs when the value...

Question 28

To ____ a table is to reduce it to a lower normal form by placing some repeated information back into the table.&#10;A) denormalize&#10;B) normalize&#10;C) flatten&#10;D) compose

Accepted Answer

The answer of To ____ a table is to reduce...

Question 29

____ is the unnecessary repetition of data.&#10;A) Data duplication&#10;B) Data replication&#10;C) Data normalization&#10;D) Data redundancy

Accepted Answer

The answer of ____ is the unnecessary repetition of data.&#10;A)...

Question 30

____________________ are composed of associated records.

Accepted Answer

The answer of ____________________ are composed of associated records....

Question 31

____________________ are formed from groups of related fields.

Accepted Answer

The answer of ____________________ are formed from groups of related...

Question 32

A ____ is a subset of rows in a database table that all depend on the same key.&#10;A) complete group&#10;B) flattened group&#10;C) repeating group&#10;D) normalized group

Accepted Answer

The answer of A ____ is a subset of rows...

Question 33

____ is the process of coding data into a format that human beings cannot read.&#10;A) Integrity&#10;B) Encoding&#10;C) Encryption&#10;D) RFID

Accepted Answer

The answer of ____ is the process of coding data...

Question 34

Database developers also refer to operations or transactions as ____ transactions when they appear to execute completely or not at all.&#10;A) coupled&#10;B) atomic&#10;C) decoupled&#10;D) nominal

Accepted Answer

The answer of Database developers also refer to operations or...

Question 35

When you combine two columns to create a compound key, you are ____ the columns.&#10;A) splitting&#10;B) converting&#10;C) joining&#10;D) concatenating

Accepted Answer

The answer of When you combine two columns to create...

Question 36

A ____ is a mechanism that prevents changes to a database for a period of time.&#10;A) flag&#10;B) lock&#10;C) permission&#10;D) transaction

Accepted Answer

The answer of A ____ is a mechanism that prevents...

Question 37

A(n) ____________________ is a long-term database lock required when users want to maintain a consistent view of their data while making modifications over a long transaction.

Accepted Answer

The answer of A(n) ____________________ is a long-term database lock...

Question 38

A database has ____ when it follows a set of rules that makes the data accurate and consistent.&#10;A) transparent integrity&#10;B) data availability&#10;C) data integrity&#10;D) data security

Accepted Answer

The answer of A database has ____ when it follows...

Question 39

____ techniques include storing and verifying passwords or even using physical characteristics, such as fingerprints or voice recognition, before users can view data.&#10;A) Authorization&#10;B) Data conversion&#10;C) Data normalization&#10;D) Authentication

Accepted Answer

The answer of ____ techniques include storing and verifying passwords...

Question 40

An ____ is an irregularity in a database's design that causes problems and inconveniences.&#10;A) inversion&#10;B) inference&#10;C) anomaly&#10;D) abstraction

Accepted Answer

The answer of An ____ is an irregularity in a...

Question 41

Match between columns&#10;                        Premises: A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A value that uniquely identifies a record&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;A group of database tables from which you can make connections between columns&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;Holds a group of files that an organization needs to support its applications&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;The process of returning the database to a correct form that existed before an error occurred&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;Represent a piece of information&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;The connection between two tables&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;Occurs when two database users need to modify the same record at the same time&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A question using the syntax that the database software can understand&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;A group of transactions applied all at once&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data&#10;The smallest usable units of data

Accepted Answer

The Answer of characters and fields and database and primary is...

Question 42

Discuss the issue of recovering lost data.

Accepted Answer

The answer of Discuss the issue of recovering lost data....

Question 43

List and explain the three normal forms.

Accepted Answer

The answer of List and explain the three normal forms....

Question 44

List two examples of primary keys.

Accepted Answer

The answer of List two examples of primary keys....

Question 45

Discuss the use of null values within a database table.

Accepted Answer

The answer of Discuss the use of null values within...

Question 46

Discuss a shorthand way to describe a table.

Accepted Answer

The answer of Discuss a shorthand way to describe a...

Question 47

List the three types of relationships that can exist between tables.

Accepted Answer

The answer of List the three types of relationships that...

Question 48

List four major issues with database performance and security.

Accepted Answer

The answer of List four major issues with database performance...

Question 49

Discuss how to create databases and design tables.

Accepted Answer

The answer of Discuss how to create databases and design...

Question 50

List three reasons why a primary key is important.

Accepted Answer

The answer of List three reasons why a primary key...

Question 51

Discuss how to sort the records in a table.

Accepted Answer

The answer of Discuss how to sort the records in...

Deck 14: Using Relational Databases