50 VERY SHORT DBMS QUESTIONS - SEE COMPUTER SCIENCE 2080 - PART I

 50 VERY SHORT DBMS QUESTIONS - 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 used in MS-Access to store address of a person? Memo

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

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

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

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

8.     What is the default size of text field in MS-Access?

The default size of a text field is 50 characters (2003 version) and 255 characters (2007 version) in MS-Access.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

34.   Which key sets relationship between tables? Primary key

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

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

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

38.   Which query is used to modify and calculate data in DBMS? Update query

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

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

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

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

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

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

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

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

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

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

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

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

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

Student' Name - Text

Students' Roll Number – Auto number

Address - Memo

Fee paid - Currency