DBMS
Popular dbms
MySQL, Oracle Database, and Microsoft Access.
what is data consistency?
That the same data is viewed at all times Ex: on Live data, dbms handle the updated and added easily.
what does the data become when it is processed?
a meaning information
what is dbms?
a software or a tool - to do creation, definition, manipulation, store, process and analyse the data.
what is canned transaction?
a standard type of query or update which is used to query the database for some data or update the database for some changes.
which database user whose jobs design and implement DBMS modules & interfaces as a package? a. System designers and implementers b. Tool Developers c. Operators and maintenance personnel d. Database Administrator e. Database Designer f. End user g. System Analyst and application programmer
a. System designer and implementors
which database user whose work is involving in using larger database in daily basis? a. actor on the scene b. worker behind the scene
a. actor behind the scene
which database user whose responsibility is to ministering primary/secondary resource, authorizing access to the database, co-ordinating & monitoring use of database, and acquiring hardware & software resource as needed? a. Database administrator(DBA) b. Database Designer c. End user d. system analyst and application programmer
a. database administrator (DBA)
which database user that is responsible for identifying the data to be stored in the database, choosing appropriate structures to represent and store data, and communicating with database user to design the designated database? a. Database administrator (DBA) b. Database Designer c. End user d. System analyst and application programmer
b. Database Designer
which database user whose job design and implement tool (software packages)? a. System Designers and implementers b. Tool Developers c. Operators and maintenance personnel d. Database Administrator e. Database Designer f. End user g. System analyst and application programmer
b. Tool developers
which database user whose work is maintaining the database system environment? a. actor on the scene b. worker behind the scene
b. worker behind the scene
which database user whose jobs require access to the data for querying, updating, and generating reports? a. Database Administrator (DBA) b. Database Designer c. End user d. System analyst and application programmer
c. End user
what do we call a collection of related data?
database
which database user whose job responsible for actual running and maintenance of hardware and software? a. Database Administrator (DBA) b. Database Designer c. End User d. System Analyst and application programmer e. System Designer and Implementor f. Tool developer g. Operators and maintenance personnel
g. Operators and maintenance personnel
what are the component of dbms?
hardware, software, data, procedure, and data access language.
what is cookie in the web browser?
is the term used to describe a type of message that appears on your web page generated by a web server.
what is the purpose to organize the data using database?
so that the data can be easily accessed, managed and updated.
What is the sole purpose of using database?
storing data
What is Data?
○ A fact or statistic that are stored or free flowing over a network ○ Raw or unprocessed
What is the main purpose of cookie?
- to identify users - to customize web page for the user - to save site login information for user.
how many type are there in database users?
2 types: - Actors on the scene - workers on the scene
what is query?
A command to retrieve data from tables
What is a query language?
A query language provides operators to check conditions before selecting data to display.
What is data redundancy?
Duplication of data Storing the same data in multiple places Storing duplicate data in multiple places
