Mis 301 exam 2 questions with complete
solutions
Data vs. Information - correct answer ✔✔-data constitute building blocks of information
-information produced by processing data
-information reveals meaning of data
data - correct answer ✔✔building block of information
facts related to any object inconsideration
-pic, image, file, pdf, etc
database - correct answer ✔✔systematic collection of data. since the data in a database is organized it
makes data management easy
Shared, integrated computer structure housing end user data and metadata
DBMS (Database Management System) - correct answer ✔✔a collection of programs which enables its
users to access database, manipulate data, and help in representation of data
-manages database structure
-controls access to data
-contains query language
Database is shared, integrated computer structure housing: - correct answer ✔✔end user data
metadata
Types of DBMS - correct answer ✔✔hierarchical
, -rarely used but employs the parent child relationship of storing data. structured like a tree with nodes
and branches representing Dif things
Network dbms
-supports many to many relationships. results in complex database structures
****relational dbms
-defines database relationships in the form of tables, relations. doesn't support many to many
relationships, usually predefined data types that they can support. most popular dbms type
object oriented relation dbms
-supports storage of new data types in the form of objects which have attributes and methods to define
what to do with this data
SQL - correct answer ✔✔Structured Query Language:
The standard language for dealing with relational databases
-can insert, search, update, and delete database records
-helps in optimizing and maintenance in databases
excel vs database - correct answer ✔✔excel has storage capacity limitation
-excel is good at calculation and db is good at storage and easy to access
-db is better when parts of the data needs to be updated (principle behind the relational db design)
Importance of DBMS - correct answer ✔✔-makes data management more efficient and effective
-query language allows quick answers to ad hoc queries
-provides better access to more and better-managed data
-promotes integrated view of organizations operations
-reduces the probability of inconsistent data
solutions
Data vs. Information - correct answer ✔✔-data constitute building blocks of information
-information produced by processing data
-information reveals meaning of data
data - correct answer ✔✔building block of information
facts related to any object inconsideration
-pic, image, file, pdf, etc
database - correct answer ✔✔systematic collection of data. since the data in a database is organized it
makes data management easy
Shared, integrated computer structure housing end user data and metadata
DBMS (Database Management System) - correct answer ✔✔a collection of programs which enables its
users to access database, manipulate data, and help in representation of data
-manages database structure
-controls access to data
-contains query language
Database is shared, integrated computer structure housing: - correct answer ✔✔end user data
metadata
Types of DBMS - correct answer ✔✔hierarchical
, -rarely used but employs the parent child relationship of storing data. structured like a tree with nodes
and branches representing Dif things
Network dbms
-supports many to many relationships. results in complex database structures
****relational dbms
-defines database relationships in the form of tables, relations. doesn't support many to many
relationships, usually predefined data types that they can support. most popular dbms type
object oriented relation dbms
-supports storage of new data types in the form of objects which have attributes and methods to define
what to do with this data
SQL - correct answer ✔✔Structured Query Language:
The standard language for dealing with relational databases
-can insert, search, update, and delete database records
-helps in optimizing and maintenance in databases
excel vs database - correct answer ✔✔excel has storage capacity limitation
-excel is good at calculation and db is good at storage and easy to access
-db is better when parts of the data needs to be updated (principle behind the relational db design)
Importance of DBMS - correct answer ✔✔-makes data management more efficient and effective
-query language allows quick answers to ad hoc queries
-provides better access to more and better-managed data
-promotes integrated view of organizations operations
-reduces the probability of inconsistent data
