Chapter 1 Fundamentals of DB Systems Training Exam Questions With Solved Solutions.
4 views 0 purchase
Module
Fundamentals of Database Systems
Institution
Fundamentals Of Database Systems
Traditional database applications - Answer In this type of database application, Most of the information that is stored and accessed is either textual or numeric
Big data - Answer New types of database systems they have been created to manage data for social media applications
Cloud sto...
Chapter 1 Fundamentals of DB Systems
Training Exam Questions With Solved
Solutions.
Traditional database applications - Answer In this type of database application, Most of the information
that is stored and accessed is either textual or numeric
Big data - Answer New types of database systems they have been created to manage data for social
media applications
Cloud storage - Answer Storage capabilities on the web for managing all types of data including
documents programs images videos and emails
Geographic information systems (G I S) - Answer Can store and analyze maps, weather data, and
satellite images.
Data warehouses and online analytical processing (0LAP) - Answer Very large databases, used to
support decision-making
Real - time and active database technology - Answer Used to control industrial and manufacturing
processes
Database - Answer A collection of related data
Data - Answer Known facts that can be recorded and that have implicit meaning
Mini world or universe of discourse (U0D) - Answer Some aspect of the real world
Properties of a database - Answer 1. represents some aspect of the real world, sometimes called the
mini world 2. databases is a logically coherent collection of data with some inherent meaning
, 3. a database is designed, built and populated with data for a specific purpose. It has an intended group
of users and some preconceived applications in which these users are interested
DBMS - Answer A computerized system that enables users to create an maintain a database. the DBMS
is a general purpose software system that facilitates the process of defining, constructing, manipulating,
and sharing databases among various users in applications
Defining - Answer Specifying the data types, structures, and constraints of the data to be stored in the
database
Meta-data - Answer The database definition or descriptive information stored in the DBMS in the form
of a database catalog or dictionary
Constructing - Answer The process of storing the data on some storage medium that is controlled by
the DBMS
Manipulating - Answer Includes functions such as querying the database to retrieve specific data,
updating the database to reflect changes in the mini world, and generating reports from the data
Sharing - Answer Allows multiple users and programs to access the database simultaneously
Query - Answer Typically causes some data to be retrieved
Transaction - Answer May cause some dated to be read and some dated to be written into the
database
System protection - Answer System protection against hardware or software malfunction
Security protection - Answer protection against unauthorized or malicious access
Data records - Answer Data of the same type
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TestSolver9. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.14. You're not tied to anything after your purchase.
