Database Management Final
What is an information system?
People, databases, hardware, software, etc. That allows for the collection, storage, and retrieval of data
A database
A database and its server
A network
Systems analysis vs systems development
The process used to design an information system and the process of creating it
The process of create an information system and the process used to design it
The two terms are synonymous
What is an SDLC and what does it stand for?
A Systems Development Life Cycle is the phase by phase breakdown of the development of an information system
A Systems Development Life Cycle is the phase by phase breakdown of the development of an database
A Systems De-analysis Life Cycle is the phase by phase breakdown of the removal of an information system
What is a DBLC and what does it stand for?
A Database Life Cycle is the phase by phase breakdown of creating a database
A Database Life Cycle is the phase by phase breakdown of creating an information system
A Data Brevity Life Cycle is the phase by phase breakdown of how data integrity is improved
Centralized vs. Decentralized Database Design
A smaller number of DB objects and a larger number of DB objects
Data from one database and data from several databases
All information stored in one table and information not being stored in tables but in arrays
What is the minimal data rule? Why is it important?
"All that is needed is there, and all that is there is needed." This ensures the model only has data that is needed and nothing more.
"All that is needed is there, and all that is there is needed." This ensures the model has less data than what is need.
"All that is needed is there, and all that is there is needed." This ensures the model has more data than what is needed.
"All that is needed is there, and all that is there is needed." This looks cool etched onto a wall.
What are business rules?
Business rules are specifications the designer uses to understand how the database operates.
Business rules are a set of specifications that determine the price of items in the database.
Business rules are a kind of creed, one that permits its subjects free reign over assassination territory.
Top down approach vs bottom up approach
Top down breaks data sets into data elements (large DB), bottom up groups data elements into data sets (small DB)
Top down breaks data sets into data elements (small DB), bottom up groups data elements into data sets (large DB)
Top down groups data elements into data sets (large DB), bottom up breaks data sets into data elements (small DB)
What is a data dictionary?
It is a store of all each database object's definition to prevent redundancy
It is a table
It is a collection of all data in one long continous file
What is normalization?
Normalization is the assignment of attributes that limit redundancy.
Normalization is the assignment of attributes that maximize redundancy.
Normalization is the assignment of attributes that limits the usage of space.
What is a normal form?
The degree to which an entity is normalized.
The degree to which an entity is redundant.
A form that is collected to make sure each table is normalized.
A form that is collected to make sure each table is not stupid.
What areimportant factors in DBMS software selection?
Cost, tools, portability, hardware requirements, and model type.
Cost, asthetics, network connectivity, hardware requirements, and model type.
Publisher, licencing company, developer
What are the three levels of backup in database recovery?
Full (everything), differential (only new additions), and transaction log
Full (everything), fractional (a portion of the DB)
A Potato
What is 1NF?
Defined primary key, no repeated groups
No partial dependencies
A number that can be natural or floating point
What is 2NF?
1NF + no dependencies
No dependencies
A character type that is used in place of natural or floating point values
What is 3NF?
2NF + no transitive dependencies
No transitive dependencies
You know that skin 'round the testes and the anus? That.
What is BCNF?
3NF where each determinant is a candidate key
3NF + Btyecoding
Bytecode Normalization Format
How is a transaction a logical unit of work?
A transaction must have all its statements executed (as a unit) or else it will be aborted
A transaction should be treated as a single piece of data
A transaction consists of only one SQL statement (a unit) to execute
What is a transaction?
A transaction is a collection of database requests that must be executed together.
A transaction is a database request that adds or remove money from an account.
A transaction is a collection of database requests in which only one must be executed.
What are the properties of a transaction?
Atomicity, Consistency, Isolation, Durability
Atomicity, Consequence, Isolation, Durability
Atomicity, Consistency, Isolation, Duration
Atomicity, Consistency, Integration, Durability
What is a transaction log?
It is a collection of every transaction and is used to roll back the database
It is a collection of every transaction and is used to delete the database
It is a collection of every transaction and is used to duplicate the database
What does the scheduler do?
It schedules transactions that are executed concurrently
It schedules transactions that are executed serially
It schedules the time in which the database should be updated
What is a lock?
It is a procedure used by a transaction to prevent data from being accessed by another transaction
It is a procedure used by a transaction to prevent data from being accessed ever again
It is a procedure used by a table to prevent data frombeing stolen by your charlatan mother
What is concurrency control?
It is the coordination of concurrent transactions to prevent errors and maintain consistency
It is the deletion of concurrent transactions to prevent errors and maintain consistency
It is the deletion of concurrent transactions free up storage space
How can a deadlock be avoided?
Avoidance (preemtive locking), prevention (abort causes of deadlock) and detection (scan for deadlock, abort latest transactions)
Avoidance (preemtive locking), abortion (abort causes of deadlock) and detection (scan for deadlock, abort latest transactions)
Avoidance (preemtive locking),abortion (abort causes of deadlock) and detection (scan for deadlock, abort latest transactions)
What triggers a database recovery?
Human error, hardware/software failure, natural distaster
Human error, new database addtion, natural distaster
Human error, hardware/software failure, network breach
What is business intelligence?
BI is a set of tools to capture, collect, store, and analyze data for business decision
BI is a program to capture, collect, store, and analyze data for business decision
BI is a set of beliefs to capture, collect, store, and analyze data for business decision
What is a DSS?
A Decision Support System is a computerized tool to help managers make decisions
A Database Support System is a computerized tool to help managers make decisions
A Decision Support System is a computerized tool to help employees sock the decks.
What are the components of a BI architecture?
ELT tools, data store, query and analysis tools, and presentation/visualization tools
ELT tools, data store, query and analysis tools, and payment tools
BLT tools, data store, query and analysis tools, and presentation/visualization tools
Operation data vs Decision Support data
Operation is for single, short unaggregated term transactions, decision support is long term collection of all transactions and effects
Decision support is for single, short unaggregated term transactions, operational is long term collection of all transactions and effects
What is a data warehouse?
An integrated, subject oriented, time varied, nonvolatile collection of data used to make decisions
An integrated, subject oriented, time varied, nonvolatile collection of data used to make purchases
An integrated, subject oriented, time varied, nonvolatile collection of data used save all company files
An integrated, subject oriented, time varied, nonvolatile collection of data used bite the clitoris
{"name":"Database Management Final", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is an information system?, Systems analysis vs systems development, What is an SDLC and what does it stand for?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
More Quizzes
Hoeveel weet jij van nanotechnologie?
740
Discover Your Preferences Quiz
1169
How Well Do You Know Madeline??
1367
De grote Benjamin Smit quiz!
1050
Totally legit hidden trivia
520
B
210
Recycling in Switzerland - take the quiz
1050
Area IV 4.Clinical Sciences (1-64)
64320
Fall 2018
420
Test Your Knowledge of Taiwan!
1166
Physical
520
There will be a test
31160