PART – A
1. Choose the correct answers
20 x 1 = 20
1. what is used to uniquely identify each records in a table
A) foreign key B) field C )Data type D) primary key.
2.________ Is usually Suitable for less amount of data.( Relational or flat
Files.)
3.Akshat You want to store a huge amount of Information about his firm in a
database. Which type of table organization would be most suitable For this
purpose.
A) Relational. B). Flat file C.) Either relational or Flat files. D). Hierarchical.
4.A Table is a. Set of data element. That is organized Using a model of
vertical. _______and the horizontal __________
A) Rows, column. B) Columns, rows. C). Rows, columns. D). Forms, reports.
5. Binary data type In your database Can be using for storing__________
A )Photos, music files, etc B.) Integer value. C). Only image files. D). only
video file.
6. Database Servers are. Referred to us.__________
A) Front end. B). Back end. C) Clients. D). Model.
7. what data type Should you Choose for a Zip code Filled in your table.?
A) Text. B.) Number C). Varchar. D). All The above.
8. The types The dictates What sort of data can be Stored within your field Is
known as.____________
9. In a text type Data field. We can put. Maximum.____________ Characters.
10. Say true or false? There can be Only one relationship Defined for a table.
11. The process of arranging record In order by One or more field Is known
as.__________
A). Shorting B) Linking. C). Ordering. D) Editing.
12.In order to Display only Those records in a query based on months Tables
Where total_ Mark are More than 74.9., bits of the Row. From the bottom.
Section of the query design. View will be. Used to define the condition. For
the query?
A) Field B). Function. C) criterion D) alias
13. In your summary, query Records are. Summarized on the. Basis of
a____________.
A). Primary key B). Short field C) Group field D) Foreign key.
14. A database.______ is a Stored Object that extract Data from a Database
As per a condition. And presents It in your readable Formatted form.
A) Form B) query C.) Reports. D) link.
15. The._______ Window is used to. Great, view, and Edit Relationships.
16. A___________ relationship. Is where multiple. Records of a table are
related. To many records Of another table.
A) One to many B) Many to one. C) one to one D). Many. To many.
17. Which of the? Following fields Would not make a Suitable primary key.
A). a customer's account number. B). a date field. C) An auto number field
D). A student Admission number.
18. Which of the following Field properties Ensure that Data cannot be
Skipped In the field Or. Field cannot be Left empty?
a) format b)Entry Required c)Default Value d) Length
19) Say true or false A foreign key is the primary key of another table.
20 . Data Should be organized Into table based on:
A). Field properties. B). Subject associated with the real data. C.) Character
lengths D). All of these.
Part B
2. Answer the following questions.
7 x 2 = 14.
1. Write any two advantages of using database.
2. What do you Understand by data Inconsistency?
3. What is primary key?
4. What is mean by data redundancy?
5.what does a table wizard do?
6. Discuss various Field types that are available in BASE.
7. Define referential integrity.
8.what is group_ field?
9. create table EMPLOYEE
EMPID Char(4)
EMPNAME Varchar(15)
DESIGN Varchar(20)
SALARY Decimal
PART C
1. Answer the following questions
4 x 4 = 16
1.How do you create queries in base?
2. What do you understand by tables in the database Management
system. ? write some popular DBMS.
3. How can a Table be created in BASE?
4. Explain any four data types in open office Base.
5. Discuss different types of relationships Along with the examples.
