DBMS Short Questions and Answers [SEE Computer Science]

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

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

3.     Which data type is used to store logical data in table? - Yes/No

4.     Write any two methods of creating table in MS Access. -Design View and Using Wizard

5.     What is the caption in the table structure of MS-Access? 

-Caption is a field property which displays an alternate name for the field to make the field name more explanatory. It can contain up to 2048 characters.

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

7.     List the four objects of the MS-Access database. – Table, Query, Form and Report

8.     Mention the name of two views of the table in MS-Access. – Design view and Datasheet View

9.     Define validation rule.

-Validation rule is a field property which enables to limit values that can be accepted into a field.

10.  What is the default field size of short text data type in MS-Access? -255 characters

11.  What is the maximum character you can use for creating a field name in MS-Access? -64 characters

12.  What is the extension of the MS-Access database file? - .mdb

13.  Define validation text. 

-Validation text is a field property which allows type text to be displayed if the user input value is prohibited by the validation rule.

14.  Which type of query is used to calculate the total marks of students in MS-Access? – Select Query

15.  In which case the Memo field type is suitable in MS-Access? 

-         If you required to keep more than 255 characters

16.  What is the memory space used by the auto-number data type in MS-Access? – 4 bytes

17.  What are the uses of reports in MS-Access? 

-to print documents according to user specifications of the summarize information through queries or tables.

18.  Which data type is suitable to store the salary of employees in MS-Access? - Currency

19.  Differentiate data and information. 

Data can be numbers, letters or symbols representing facts and figures which may or may not give any sense. E.g.: Ram, student, 20, etc.

Information is an organized collection of related data, which gives a complete sense.

“Ram is a student. He is 20 years old.”, is information that gives a complete sense.

 

20.  What is the memory space used by the Currency data type in MS-Access? – 8 bytes

21.  Mention any four data types available in MS-Access. – Text, Memo, Currency, Date/Time

22.  Define field properties. 

-Field properties describe the characteristics and behavior of data added to that field