Database Management System

Question 1

What is Database?

Answer 1

A database is an organised collection of data that can be visualised as a container of information.

Question 2

What are the advantages of Database?

Answer 2

Advantages of Database are:
i) Reduction in Data redundancy
ii)Reduction in Data inconsistency
iii)Sharing of Data
iv)Enforcement of Data standards
v)ensures data security
vi)data integrity
vii)interactive interface

Question 3

What are the features of Database?

Answer 3

Features of Database are:
i. there can be more than one table in a database
ii.the information is stored in tables in a database relate to one specific topic. each database contains information about 1 type of item.
iii. data can be simultaneously be accessed by many users.
iv. database offers data protection and features like recovery and backup.
v.it allows the user to view the data in different formats
vi.records unique number or letter in each table, chances of duplication of data is avoided

Question 4

What is Database Management System (DBMS)?

Answer 4

Database Management Systems (DBMS): A software application used to create, manage, maintain and retrieve the data stored in databases.

Question 5

What can one find and do in DBMS?

Answer 5

DBMS is used to build the database and manage database in a software.
i. adding new records
ii.editing changing/modifying existing data.
iii.deleting data
iv.sorting data
v.extracting data based on queries
vi.updating and manipulating data item
vii. viewing data and generating reports.
viii.performing calculations.

Question 6

What are the elements of database

Answer 6

Elements of database:
i. table: set of data elements stored in verticals and horizontal fields and records
ii. field: set of data values
iii. records: set of items stored in tables

Question 7

How many types of data can be organised in DBMS?

Answer 7

Data can be stored in 2 files
I. flat file: data stored in single tables.
II. relational: data is stored in multiple tables and tables are linked using a common field.

Question 8

What the objects in Database?

Answer 8

Database objects:
i) tables: basic element of data kept in columns and rows
ii) queries: generate some information from the table
iii) forms: provide an interface in user specified layout which lets the user to view the data or enter new data .
iv) reports: report displays the information in a format as per user’s need.

Question 9

What is Relational Database?

Answer 9

Relational Database are collection of multiple tables, rows and columns

Question 10

RDBMS Element keys

Answer 10

Primary Key
Composite Key
Key Field
Foreign Key

Question 11

What is the common field?

Answer 11

KEY FIELD

Question 12

What is the key that is used to uniquely identify records (rows) in database and is only 1?

Answer 12

Primary key

Question 13

What is the key that is a combination of two or more fields (columns) that can uniquely identify or retrieve records?

Answer 13

Composite Key

Question 14

What can Foreign key do?

Answer 14

allows tables to relate and link through a field which is common in both the tables.

Question 15

what are the data types in database

Answer 15

1. Numeric
   2.Alphanumeric
   3.Binary
2. Date Time

Question 16

Example of Binary data type in DB

Answer 16

LONGVARBINARY
&
BINARY

Question 17

What data type does ‘VARCHAR’ and ‘MEMO’ come under?

Answer 17

Alphanumeric data type

Question 18

Give example of Numeric data type

Answer 18

BOOLEAN, DECIMAL, NUMBER, INTEGER

Question 19

Which data type falls under Date Time?

Answer 19

Date/ Time

Question 20

what should be the first step to add primary key relationship to 2 Tables?

Answer 20

Click on ‘create view from task bar’
add tables from ‘Add Tables’

Question 21

how do you edit records

Answer 21

By double clicking on it

Question 22

which option should you choose to change field property?

Answer 22

Edit Option

Question 23

what is the default length of a field

Answer 23

10

Question 24

what is the purpose for ‘Entry Required’?

Answer 24

any value to be entered in a field cannot be ;eft empty.

Question 25

what does referential integrity help us to avoid?

Answer 25

Referential integrity helps to avoid:
 Adding records to a related table if there is no associated record available in the
primary key table.
 Changing values in a primary if any dependent records are present in associated
table(s).
 Deleting records from a primary key table if there are any matching related records
available in associated table(s).

Question 26

how to set relationship between 2 tables the easy way?

Answer 26

From Tools menu you ca select ‘Relationship’ and then add two tables by clicking the ‘Add’ button.

Question 27

How many relationships can be created in TABLES?

Answer 27

3 relationships

Question 28

In which relationship of the tables can 1 table be joined with 1 other table? Both must have primary key

Answer 28

One to One relationship

Question 29

In which relationship of tables can 1 tables be joined with more than 1 table? only 1 can have a primary key

Answer 29

One to Many Relationship

Question 30

what is many to many relationship?
Does it have primary key in any table

Answer 30

all columns of primary key table are associated with all columns of associated table.
No, it has no primary key

Question 31

File extension for database in openoffice

Answer 31

.obd

Question 32

three file formats in database

Answer 32

.odf
.obd
.ods