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
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
