DBMS Flashcards

(26 cards)

1
Q

What is database?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Define DBMS

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Types of database

A
  1. Relational database
  2. Hierarchical database
    3.Network database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

advantages of dbms

A
  1. No redundant data (duplicate data)
  2. Data integrity and consistency
  3. High data security
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Define RDBMS

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Advantages of rdbms

A
  1. Reduced data redundancy and inconsistency
  2. Data integrity and high security
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Define MS access

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Advantages of Ms access

A
  1. It can import data from multiple sources.
  2. It supports many high level language that works on windows os
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

extension of ms access

A

.accdb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Objects of Ms access database

A
  1. Table
  2. Query
  3. Form
  4. Report
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Elements of table

A
  1. Field
  2. Row
  3. Column
  4. Record
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Define field in database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Define record

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Define column

A

Column is that field that is managed vertically.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Define rows

A

Row is the record that is managed horizontally

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Define query

A

Query is the request for data and information

17
Q

Define form

A

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

18
Q

Define report

A

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

19
Q

Define data integrity

A

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

20
Q

Define data consistency

A

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

21
Q

What does data redundancy mean?

A

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

22
Q

application fields

A
  1. Business field
  2. School and office.
  3. Banking and finance
23
Q

features of rdbms

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

difference between data redundancy and data inconsistency.

A

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.

25
define primary key
Primary key is a special field, or combination of field, that uniquely identifies each record.
26
two importance of primary key
1. It prevents duplication of data. 2. It creates referential integrity constraints to establish relation between tables.