DBMS

Question 1

What is database?

Answer 1

Database is the organized collection of data, which can be easily managed and accessed.

Question 2

Define DBMS

Answer 2

DBMS are the collection of programs used for creating and managing databases.

Question 3

Types of database

Answer 3

1. Relational database
2. Hierarchical database
   3.Network database

Question 4

advantages of dbms

Answer 4

1. No redundant data (duplicate data)
2. Data integrity and consistency
3. High data security

Question 5

Define RDBMS

Answer 5

A relational database management system is a database management system that stores data in multiple tables and links each other to share, retrieve, and organize.

Question 6

Advantages of rdbms

Answer 6

1. Reduced data redundancy and inconsistency
2. Data integrity and high security

Question 7

Define MS access

Answer 7

MS access is the RDBMS developed by Microsoft used to create, organize, store, and manage data in database.

Question 8

Advantages of Ms access

Answer 8

1. It can import data from multiple sources.
2. It supports many high level language that works on windows os

Question 9

extension of ms access

Answer 9

.accdb

Question 10

Objects of Ms access database

Answer 10

1. Table
2. Query
3. Form
4. Report

Question 11

Elements of table

Answer 11

1. Field
2. Row
3. Column
4. Record

Question 12

Define field in database

Answer 12

Field in database is heading under which similar information are stored.

Question 13

Define record

Answer 13

Record is the collection of related data that are treated as single unit of information.

Question 14

Define column

Answer 14

Column is that field that is managed vertically.

Question 15

Define rows

Answer 15

Row is the record that is managed horizontally

Question 16

Define query

Answer 16

Query is the request for data and information

Question 17

Define form

Answer 17

Form is the object of database which allows entering data, display and update data in customized format.

Question 18

Define report

Answer 18

Report is the object of database which displays the data in manageable format for printing.

Question 19

Define data integrity

Answer 19

Data integrity is the accuracy, completeness, and quality of data and its maintenance over time.

Question 20

Define data consistency

Answer 20

Data consistency is the accuracy, completeness and correctness of data stored in database

Question 21

What does data redundancy mean?

Answer 21

Data redundancy mean the repetition of same data in multiple place within database.

Question 22

application fields

Answer 22

1. Business field
2. School and office.
3. Banking and finance

Question 23

features of rdbms

Answer 23

1. Reduced data redundancy and inconsistency
2. Data integrity and enhanced sercurity
3. Data stored in tabular structure enhance the representation of data

Question 24

difference between data redundancy and data inconsistency.

Answer 24

data redundancy refers to repetition of data in database and it leads to increased storage requirements.

Data inconsistency refers to the different values of same data in a database. and it leads to incorrect or inaccurate query results.

Question 25

define primary key

Answer 25

Primary key is a special field, or combination of field, that uniquely identifies each record.

Question 26

two importance of primary key

Answer 26

1. It prevents duplication of data.
2. It creates referential integrity constraints to establish relation between tables.