40 Short Questions DBMS- 8 Marks - SEE COMPUTER SCIENCE 2080

 

40 Short Questions DBMS- 8  Marks - SEE COMPUTER SCIENCE 2080

1.          Define RDBMS.

2.          Define MS Access.

3.          What is primary key?

4.          What is foreign key?

5.          What is data sorting?

6.          Define filtering.

7.          What is data processing.

8.          What are field properties?

9.          What is table in Access?

10.          What is form in Access?

11.          What is query in Access?

12.          What is report in Access?

13.          What is select query?

14.          What is action query?

15.          Why caption field property is used in MS-Access?

16.          What are validation text and validation rule?

17.          Write any four importance of table.

18.          Mention any four uses of form.

19.          Mention any four uses of report.

20.      List any four advantages of query.

21.      List any two major differences between forms and reports.

22.      What type of work is done in MS-Access using form and query object.

23.      Differentiate between select query and update query.

24.      Differentiate between Select query and Action query.

25.      Write the difference between data and information.

26.      Differentiate between Primary key and Foreign key with example.

27.      Differentiate between fields and records with an examples.

28.      Differentiate between text and memo data type.

29.      Mention the functions of any four data types of MS-Access.

30.      Write any four advantages of DBMS [Computerized Database]

31.      Write any four advantages of MS-Access.

32.      List any three advantages of primary key.

33.      List any two advantages of sorting.

34.      Why is it important to specify primary key in database?

35.      What do you understand by Data Redundancy? How can it reduced in data redundancy.

36.      Why table is called the building block of database?

37.      What is the purpose of database?

38.      List out the data type used for the following data in MS Access

Student' Name, Students' Roll Number, Address, Fee paid

39.      Identify a record, field and value from the following table structure.

Symbol No.	Name	Marks
00100202S	Aarambha Gharti	85
00100203T	Subash Rayamajhi	91

 

40.      While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth

Write a similarity and a difference between Number field type and Currency filed type.