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