Database Management

Question 1

What is the database

Answer 1

Database is the organised Collection of data that can be visualised as a container of information

Question 2

What are the advantages of database

Answer 2

Easy retrieval reduced inconsistency of data provide security has interactive interface provides easy sharing of data easy analysing of data using various tools

Question 3

Reduction in data redundancy means

Answer 3

It means duplication of data a database provides the centralise control over data that is all the data is kept at one place and any application that needs access can access it from the central location

Question 4

Reduction in data inconsistency

Answer 4

In a database data stored his consistent and remains updated in case date of an atom is changed when modification is made in one portion the changes are done in all other portions

Question 5

Data integrity means

Answer 5

It means validation of data management system and shows that only valid data can be entered into the database which is specified earlier

Question 6

What is database management system

Answer 6

A database management system is computerised Record Keeping system whose purpose is to manage the data and make it available as per the requirement

Question 7

Difference between flat file and relational file

Answer 7

In flat 5 data is stored in a single table in relational files data is stored in multiple tables and their link together

Question 8

Define table field and record

Answer 8

Table is collection of logically related records field represents one related part of table record is collection of multiple data which is stored in related fields give examples to

Question 9

What is the relational database management system

Answer 9

RDBMS is defined as a collective set of multiple data sets organised into tables records and columns

Question 10

Name the database objects

Answer 10

Tables queries forms and reports

Question 11

Define tables

Answer 11

A table is the basic element of a database in which data is kept in columns and rows called fields and records

Question 12

Define queries

Answer 12

It is a request to generate some information from the tables

Question 13

Define forms

Answer 13

Forms are user friendly interface to add or update data in a table

Question 14

Define reports

Answer 14

Report display the information in a format as per users need

Question 15

Define key field

Answer 15

In the database data between various tables can be related on the basis of a common field called key field

Question 16

What is the primary key

Answer 16

It is a field which is used to uniquely identify records in a database

Question 17

What is composite primary key

Answer 17

When one or more fields are made primary keys they are called as composite primary keys

Question 18

What is the foreign key

Answer 18

A field that is used to establish your relation between two tables or primary key of 1 table is called foreign key in another table

Question 19

What is a field name and field type

Answer 19

Field name is the identify of a field field type specifies but kind of data is to be stored in that particular field

Question 20

What is relationship in a database and types of relationship

Answer 20

It refers to link between different tables of a database matching the data on basis of a common primary he filled it types are 121 12 many many to many

Question 21

What is referential integrity

Answer 21

It is a rule in a database that states that 1 which state that a foreign key must have a matching primary second point it is applied in a database to maintain accuracy and consistency of a data in a relationship between tables 3rd point changing values in a primary key table will also reflect independent records present in associated tables

Question 22

What is o l e and define its use

Answer 22

Oily stand for object linking and a madam only objective used to insert images pictures graphics fingerprints Iris patterns at sector in a database if you are thinking of storing and image in any field you can assign the data type for the field as o l e

Question 23

What are the types of commands in a database

Answer 23

Data definition language and data manipulation language and data control language and transaction control language

Question 24

Define data definition language

Answer 24

It is a standard for commands that define the structure of a database it consists of create and alter and truncate and rename and d r o p

Question 25

Define data manipulation language

Answer 25

It is a language that enables user to retrieve update insert and delete data in a database Common statements are Select and update and insert into and delete

Question 26

Define data control language

Answer 26

It is a language that has various command which are used to grant and take bath back authority from any database base user some statements are grant and revoke

Question 27

Transaction control language

Answer 27

It is a language that has various commands which are used to manage transactions in the database some TCL statements are commit and save point and rollback