DBMS 110 FINAL EXAM STUDY GUIDE
Which data analysis phase considers the processes and data that may be incomplete,
contain duplicates, or contain errors?
Group of answer choices Data Analysis Data Processing Data Cleaning
Communications Data Processing - Correct Answers -Data Cleaning
Big Data can only store data that is:
Structured
Semi-Structured
Unstructured
All of the above - Correct Answers -All of the above
In what decade did the type of data stored in a database evolve. - Correct Answers -
2000
What does the management of data involve? - Correct Answers -Defining structures for
storage of information and providing mechanism for manipulating data.
What is the role of data abstraction in a database? - Correct Answers -Hide the
complexity of storing data from the user.
A transaction is a collection of operations that performs a single logical function in a
database application. - Correct Answers -True
Information processing drives the growth of computers. - Correct Answers -True
What was the first relational database product? - Correct Answers -IBM System R
What does a database design involve? - Correct Answers -The design of a database
schema
The storage manager components includes: - Correct Answers -File manager
Authorization and integrity manager
Buffer manager
Transaction manager
The three properties of transaction management discussed in this book are: - Correct
Answers -Durability
Atomicity
Consistency
, A query is: - Correct Answers -A statement used to retrieve information for the
database.
Responsibilities of Database Administrators includes: - Correct Answers --Defining the
storage structure and access method definition
-Defining the schema definition
-Applying schema and physical organization modification
A variety of new data-intensive applications and the need for rapid development lead to
NoSQL database. - Correct Answers -True
The earliest database system arose in 1980s - Correct Answers -False
What is a domain constraint? - Correct Answers -Domains that specify possible values
that can be store in an attribute
An instance can be defined as: - Correct Answers -A collection of information stored in
the database at a particular moment
What are applications? - Correct Answers -Programs that are used to interact with the
database
Examples of the Database Administrator routine maintenance activities include: -
Correct Answers --Ensure enough free disk space is available
-Backing up the database
-Ensuring database performance
A database management system (DBMS) is - Correct Answers -A collection of
interrelated data and set of programs used to access data
What language would you use to specify the storage structure of a database schema? -
Correct Answers -DDL
Data manipulation language is a language that enables users to access or manipulate
data. - Correct Answers -True
A query language is a language in which a user can request information from the
database. - Correct Answers -True
Relational algebra consist of set of operations including: - Correct Answers --Project
-Cartesian Product
-Select
-Rename
-Join
Which data analysis phase considers the processes and data that may be incomplete,
contain duplicates, or contain errors?
Group of answer choices Data Analysis Data Processing Data Cleaning
Communications Data Processing - Correct Answers -Data Cleaning
Big Data can only store data that is:
Structured
Semi-Structured
Unstructured
All of the above - Correct Answers -All of the above
In what decade did the type of data stored in a database evolve. - Correct Answers -
2000
What does the management of data involve? - Correct Answers -Defining structures for
storage of information and providing mechanism for manipulating data.
What is the role of data abstraction in a database? - Correct Answers -Hide the
complexity of storing data from the user.
A transaction is a collection of operations that performs a single logical function in a
database application. - Correct Answers -True
Information processing drives the growth of computers. - Correct Answers -True
What was the first relational database product? - Correct Answers -IBM System R
What does a database design involve? - Correct Answers -The design of a database
schema
The storage manager components includes: - Correct Answers -File manager
Authorization and integrity manager
Buffer manager
Transaction manager
The three properties of transaction management discussed in this book are: - Correct
Answers -Durability
Atomicity
Consistency
, A query is: - Correct Answers -A statement used to retrieve information for the
database.
Responsibilities of Database Administrators includes: - Correct Answers --Defining the
storage structure and access method definition
-Defining the schema definition
-Applying schema and physical organization modification
A variety of new data-intensive applications and the need for rapid development lead to
NoSQL database. - Correct Answers -True
The earliest database system arose in 1980s - Correct Answers -False
What is a domain constraint? - Correct Answers -Domains that specify possible values
that can be store in an attribute
An instance can be defined as: - Correct Answers -A collection of information stored in
the database at a particular moment
What are applications? - Correct Answers -Programs that are used to interact with the
database
Examples of the Database Administrator routine maintenance activities include: -
Correct Answers --Ensure enough free disk space is available
-Backing up the database
-Ensuring database performance
A database management system (DBMS) is - Correct Answers -A collection of
interrelated data and set of programs used to access data
What language would you use to specify the storage structure of a database schema? -
Correct Answers -DDL
Data manipulation language is a language that enables users to access or manipulate
data. - Correct Answers -True
A query language is a language in which a user can request information from the
database. - Correct Answers -True
Relational algebra consist of set of operations including: - Correct Answers --Project
-Cartesian Product
-Select
-Rename
-Join
