BCOR 330 EXAM 2 WVU QUESTIONS & ANSWERS
Understand the difference between a database and a spreadsheet: - Answers -A
spreadsheet is a computer software that simulates a paper worksheet. We use it to
tabulate data and create graphs based on the data. A database is a collection of related
data that can be accessed quickly. A database is meant to hold a large amount of data
and some databases routinely do.
Why do businesses use databases today? - Answers -Databases help to manage a
huge amount of data and help users to perform more than one task at a time. Using one
software application business operations get efficient and overall expenses are
reduced.
Be able to recognize the difference between a table's primary key and a foreign key -
Answers -Primary key uniquely identify a record in the table. Foreign key is a field in the
table that is primary key in another table. There can only be one primary key but
multiple Foreign Keys.
Why is metadata important? - Answers -Metadata is essential for maintaining historical
records of long-term data sets, making up for inconsistencies that can occur in
documenting data, personnel and methods. Comprehensive metadata can also enable
data sets designed for a single purpose to be reused for other purposes and over the
longer term
What are the different type of SQL statements - Answers -1. DDL - Data Definition
Language
DDL is used to defined the structure that holds the data. ex:Create, alter, drop, and
truncate table
2. DML -Data Manipulation Language
DML is used to manipulate the data itself. Typical operations are Insert delete, update
and retrieve data from table
3. DCL - Data Control Language
DCL is used to control the visibility of data like granting database access and set
privileges to create tables
Know the difference between cloud elasticity and scalability - Answers -The purpose of
elasticity is to match the resources allocated with actual amount of resources needed at
any given point in time. Scalability handles the changing needs of an application within
the confines of the infrastructure via statically adding or removing resources to meet
applications demands if needed.
Why did we transition off the mainframe and client-server models for storing/sharing
data? - Answers -The mainframe and client-server models were much older types of
Understand the difference between a database and a spreadsheet: - Answers -A
spreadsheet is a computer software that simulates a paper worksheet. We use it to
tabulate data and create graphs based on the data. A database is a collection of related
data that can be accessed quickly. A database is meant to hold a large amount of data
and some databases routinely do.
Why do businesses use databases today? - Answers -Databases help to manage a
huge amount of data and help users to perform more than one task at a time. Using one
software application business operations get efficient and overall expenses are
reduced.
Be able to recognize the difference between a table's primary key and a foreign key -
Answers -Primary key uniquely identify a record in the table. Foreign key is a field in the
table that is primary key in another table. There can only be one primary key but
multiple Foreign Keys.
Why is metadata important? - Answers -Metadata is essential for maintaining historical
records of long-term data sets, making up for inconsistencies that can occur in
documenting data, personnel and methods. Comprehensive metadata can also enable
data sets designed for a single purpose to be reused for other purposes and over the
longer term
What are the different type of SQL statements - Answers -1. DDL - Data Definition
Language
DDL is used to defined the structure that holds the data. ex:Create, alter, drop, and
truncate table
2. DML -Data Manipulation Language
DML is used to manipulate the data itself. Typical operations are Insert delete, update
and retrieve data from table
3. DCL - Data Control Language
DCL is used to control the visibility of data like granting database access and set
privileges to create tables
Know the difference between cloud elasticity and scalability - Answers -The purpose of
elasticity is to match the resources allocated with actual amount of resources needed at
any given point in time. Scalability handles the changing needs of an application within
the confines of the infrastructure via statically adding or removing resources to meet
applications demands if needed.
Why did we transition off the mainframe and client-server models for storing/sharing
data? - Answers -The mainframe and client-server models were much older types of
