60 Very Short Questions DBMS - 2 Marks - SEE COMPUTER SCIENCE 2080

 1.      Which data type is suitable to store photographs of students in MS-Access? OLE Object

2.      Which data type is used to store date of birth of an employee in MS-Access? Date/Time

3.      Which data type is suitable to store salary of an employee in MS-Access? Currency

4.      Which data type is used to store your school fee in MS-Access? Currency

5.      Which data type is used to store lengthy text and numbers? Memo (Long Text)

6.      What is the storage size of memo and text data type in MS- Access? Memo – 65535 / 64000 Characters / Text – 255 Characters

7.      What is the storage size of Auto number and currency data type? Auto number – 4 Bytes / Currency 8 Bytes

8.      What is the storage size of Date/Time and OLE object data type? Date/Time – 8 bytes / OLE Object 1 GB

9.      What is the storage size of integer and long integer number data type? Integer – 2 Bytes / Long integer –4 Bytes

10.   What is the storage size of single and double number data type? Single – 4 Bytes / Double – 8 Bytes

11.   What is the storage size of yes/no field and hyperlink data type? Yes/no – 1 bit / Hyperlink – 2048 Characters

12.   What is the storage size of attachments data type. 2GB

13.   Which data type is the default type in MS Access? - Text

14.   What is the maximum length of field name in MS-Access? 64 Characters

15.   What is the maximum size of caption field properties in MS-Access? – 2048 Characters

16.   What is the default size of number field in MS-Access? – Long Integer

17.   Which field property gives alternative name for any field? Caption

18.   Is table a database? No,  A table is an object inside a database

19.   Write any three components of database? Table, record and field

20.   What is a record source for a report in MS Access? Table and Query

21.   How many ways to sort data in MS-Access? Ascending or Descending order according to text or numbers

22.   Which object is used to store the data in database? Table

23.   What is the extension of MS-Access 2007? 2003 version - .mdb , 2007 version - .accdb

24.   What is the primary building block of a database? Table

25.   What terms are used to refer to a row and a column in a table? Row – Tuple/Record, Column – Attribute/Field

26.   Which object of DBMS is used to print information? Report

27.   Which object of MS Access is used to provide graphical interface to enter data into a table? Form

28.   Which data type of MS Access is used for data that can store only one of two possible values? Yes/No

29.   Which data type displays data from another table? Lookup Wizard

30.   Which data type provides a link “address” to a document? Hyperlink

31.   Which object of MS-Access is used to retrieve data from the table? Query

32.   Which key sets relationship between tables? Primary key

33.   Which query is used to view the data stored in database? Select query

34.   Which view is used to modify a table structure in MS-Access? Design view

35.   Which query is used to make changes in data stored in database? Action query

36.   Which view is used to modify a record in MS-Access? Datasheet view

37.   Which data type is also known as logical data type in MS-Access? Yes/No

38.   What is the purpose of a query in a database? To ask question to the database.

39.   Which data type is used to store alpha numeric characters or special symbols in MS-Access? Text

40.   Which field property speeds up searching and sorting of records based on a field? Indexed Field Property

41.   Write two examples of primary key fields.  SEE Registration Number,  National Identity Number

42.   What happens while we enter text in number data type? It display error message.

43.   What is relationship? An association or connection between two tables based on a common field or fields.

44.   Which field property controls the value of a record and sets in a specific format? Input Mask

45.   Which field property is used to specify whether a value is required in a field or not? Required

46.   Which field property displays value automatically for a field when new record is added to a table? Default Value

47.   In how many ways we can create a table in Ms Access?

48.   In how many ways we can create a form in Ms Access?

49.   In how many ways we can create a report in Ms Access?

50.   In how many ways we can create a query in Ms Access?

51.   List the types of query.

52.   List the types of action query.

53.   Write any four objects of MS-Access.

54.   Write any four data types used in  MS-Access.

55.   Write any four field properties used in MS-Access.

56.   Write any four examples of database.

57.   Write any four examples of DBMS

58.   Write any four examples of RDBMS.

59.   Define database.

60.   Define DBMS.