UNIT 6 DATA (C182) QUESTIONS WITH
VERIFIED CORRECT ANSWERS |GRADED A+ .
Database research - correct Answers -Act of analyzing and converting data into information that
can be used in decision making
What are the 2 major layer of a typical database? - correct Answers -1. application layer
2. database management layer
What is the application layer of a database? - correct Answers -communicates with the end user
and can be fairly complex; does not directly manipulate the data, but it uses the database
management system (DBMS) as a tool to obtain the results
What is the DBMS? - correct Answers -Database Management System
What does the DBMS do? - correct Answers -The DBMS is used as a tool in the application
layer of a database to alter or retrieve information
What are the 2 component of a database table (datasheet)? - correct Answers -Records (rows that
contain data) & Fields (columns that contain a single piece of data about a records i.e. name, age,
position)
What type of data is the following: abc, def456, erf78!@? - correct Answers -Character String
What type of data is the following: 9.5, 45.5, 1.7 ? - correct Answers -Floating point numbers
What type of data is the following: True, False ? - correct Answers -Boolean Values
1
, What type of data is the following: 4, 34, 394850 ? - correct Answers -Intergers
What type of data is the following: F, !, # ? - correct Answers -Characters
What is a database model? - correct Answers -the conceptual view of a database
What are the 4 most common database models? - correct Answers -Flat-File Database,
Hierarchical Database, Relational Database, Object-oriented (OO) databases
What is a Flat-File Database? - correct Answers -A database model that stores data in plain text
files with each line of text file holding one record. This model only has one table
What is a Hierarchical Database? - correct Answers -A database model where data is organized
in a tree like structure with a parent having one or more records
What is a Relational Database? - correct Answers -A database model that contains one or more
tables joined together in logical way. Each record has a unique identifier known as a primary key
which helps create the relationship among tables
What is a foreign key? - correct Answers -A primary key found on another table within a
relational database
What is the collection of names, addresses, and account balances of all the patients of Mei's
office more technically known as? - correct Answers -Database
The name, address, and account balance of each individual patient in Mei's office is known as a:
- correct Answers -Record
What is a tree-like structure of records in a database referred to as? - correct Answers -
Hierarchical database structure
2
VERIFIED CORRECT ANSWERS |GRADED A+ .
Database research - correct Answers -Act of analyzing and converting data into information that
can be used in decision making
What are the 2 major layer of a typical database? - correct Answers -1. application layer
2. database management layer
What is the application layer of a database? - correct Answers -communicates with the end user
and can be fairly complex; does not directly manipulate the data, but it uses the database
management system (DBMS) as a tool to obtain the results
What is the DBMS? - correct Answers -Database Management System
What does the DBMS do? - correct Answers -The DBMS is used as a tool in the application
layer of a database to alter or retrieve information
What are the 2 component of a database table (datasheet)? - correct Answers -Records (rows that
contain data) & Fields (columns that contain a single piece of data about a records i.e. name, age,
position)
What type of data is the following: abc, def456, erf78!@? - correct Answers -Character String
What type of data is the following: 9.5, 45.5, 1.7 ? - correct Answers -Floating point numbers
What type of data is the following: True, False ? - correct Answers -Boolean Values
1
, What type of data is the following: 4, 34, 394850 ? - correct Answers -Intergers
What type of data is the following: F, !, # ? - correct Answers -Characters
What is a database model? - correct Answers -the conceptual view of a database
What are the 4 most common database models? - correct Answers -Flat-File Database,
Hierarchical Database, Relational Database, Object-oriented (OO) databases
What is a Flat-File Database? - correct Answers -A database model that stores data in plain text
files with each line of text file holding one record. This model only has one table
What is a Hierarchical Database? - correct Answers -A database model where data is organized
in a tree like structure with a parent having one or more records
What is a Relational Database? - correct Answers -A database model that contains one or more
tables joined together in logical way. Each record has a unique identifier known as a primary key
which helps create the relationship among tables
What is a foreign key? - correct Answers -A primary key found on another table within a
relational database
What is the collection of names, addresses, and account balances of all the patients of Mei's
office more technically known as? - correct Answers -Database
The name, address, and account balance of each individual patient in Mei's office is known as a:
- correct Answers -Record
What is a tree-like structure of records in a database referred to as? - correct Answers -
Hierarchical database structure
2
