Database Management

Question 1

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

Answer 1

Database Application.

Question 2

A ________ is a column or group of columns that identifies a unique row in a table.

Answer 2

Key.

Question 3

A ________ is a column or group of columns that identifies a unique row in a table.

Answer 3

Key.

Question 4

A ________ is a software program; while a ________ is a collection of tables of data, relationships, and metadata.

Answer 4

DBMS; database

Question 5

A ________ is a software program; while a ________ is a collection of tables of data, relationships, and metadata.

Answer 5

DBMS; database

Question 6

Bytes are grouped into columns, which are also called ________.

Answer 6

Fields.

Question 7

Bytes are grouped into columns, which are also called ________.

Answer 7

Fields.

Question 8

Constraints on the number of entities that can be in a relationship are called ________.

Answer 8

Minimum Cardinalities.

Question 9

Constraints on the number of entities that can be in a relationship are called ________.

Answer 9

Minimum Cardinalities.

Question 10

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

Answer 10

Relationnal Databases.

Question 11

Databases that are organized in the form of tables and represent interconnections using foreign keys are called ________.

Answer 11

Relationnal Databases.

Question 12

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

Answer 12

The E-R Data Model.

Question 13

Developers use ________ to define the entities that will be stored in the database and the relationships among those entities.

Answer 13

The E-R Data Model.

Question 14

In a database, a ________ refers to a character of data.

Answer 14

Byte

Question 15

In a database, a ________ refers to a character of data.

Answer 15

Byte

Question 16

In a database, rows are also known as ________.

Answer 16

Records

Question 17

In a database, rows are also known as ________.

Answer 17

Records

Question 18

In a relational database, every table must have a ________.

Answer 18

Key

Question 19

In a relational database, every table must have a ________.

Answer 19

Key

Question 20

________ is an international standard language for processing a database and is supported by all major DBMS products.

Answer 20

SQL

Question 21

________ is an international standard language for processing a database and is supported by all major DBMS products.

Answer 21

SQL

Question 22

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

Answer 22

Query Form

Question 23

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.

Answer 23

Query Form

Question 24

The database design team expresses relationships by defining ________.

Answer 24

Foreign Keys