ITSS 3300 PRACTICE EXAM 2
QUESTIONS AND ANSWERS
Which of these is not a function of a database management system?
a. Create a database
b. Process a database
c. Interpret a database
d. Administer a database - ANS c. Interpret a database
Select all the functions of a database.
Mine data
Centralize data
Control redundant data
Store duplicate data - ANS Centralize data
Control redundant data
How does a relational DBMS represent data?
a. Two-dimensional matrices
b. Two-dimensional tables
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 1
,c. Two-dimensional scatterplots
d. Two-dimensional Gantt charts - ANS b. Two-dimensional tables
The field used to uniquely identify each record (row) is called the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS a. Key field
The field used for key fields in a table, which is used for organization, is called the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS b. Primary Key
In general, the most unique field in a table is the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS b. Primary Key
The ________ is used in a second table as the look-up field to identify records from original
table.
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 2
, a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS c. Foreign Key
What is the hierarchy of data elements in a database?
a. Bytes (Characters) -> Table (File) -> Fields (Columns) -> Records (Rows)
b. Bytes (Characters) -> Table (File) -> Records (Rows) -> Fields (Column)
c. Table (File) -> Fields (Columns) -> Records (Rows) -> Bytes (Characters)
d. Table (File) -> Records (Rows) -> Fields (Columns) -> Bytes (Characters) - ANS d. Table (File)
-> Records (Rows) -> Fields (Columns) -> Bytes (Characters)
Match the term to the definition:
a. Attribute (Metadata) 1.
b. Column (Field) 2.
c. Database 3.
d. Entity 4.
e. Row (Record) 5.
f. Table (File) 6.
1. Each characteristic, or quality, describing the entity 2. Group of related characters, words,
numbers, etc. 3. Group of related columns (fields)
4. Group of related rows (records)
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 3
QUESTIONS AND ANSWERS
Which of these is not a function of a database management system?
a. Create a database
b. Process a database
c. Interpret a database
d. Administer a database - ANS c. Interpret a database
Select all the functions of a database.
Mine data
Centralize data
Control redundant data
Store duplicate data - ANS Centralize data
Control redundant data
How does a relational DBMS represent data?
a. Two-dimensional matrices
b. Two-dimensional tables
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 1
,c. Two-dimensional scatterplots
d. Two-dimensional Gantt charts - ANS b. Two-dimensional tables
The field used to uniquely identify each record (row) is called the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS a. Key field
The field used for key fields in a table, which is used for organization, is called the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS b. Primary Key
In general, the most unique field in a table is the:
a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS b. Primary Key
The ________ is used in a second table as the look-up field to identify records from original
table.
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 2
, a. Key field
b. Primary Key
c. Foreign Key
d. Look-up field - ANS c. Foreign Key
What is the hierarchy of data elements in a database?
a. Bytes (Characters) -> Table (File) -> Fields (Columns) -> Records (Rows)
b. Bytes (Characters) -> Table (File) -> Records (Rows) -> Fields (Column)
c. Table (File) -> Fields (Columns) -> Records (Rows) -> Bytes (Characters)
d. Table (File) -> Records (Rows) -> Fields (Columns) -> Bytes (Characters) - ANS d. Table (File)
-> Records (Rows) -> Fields (Columns) -> Bytes (Characters)
Match the term to the definition:
a. Attribute (Metadata) 1.
b. Column (Field) 2.
c. Database 3.
d. Entity 4.
e. Row (Record) 5.
f. Table (File) 6.
1. Each characteristic, or quality, describing the entity 2. Group of related characters, words,
numbers, etc. 3. Group of related columns (fields)
4. Group of related rows (records)
COPYRIGHT © 2025 BRAINBARTER ALL RIGHTS RESERVED 3
