CS 06 - 30 VERY SHORT DBMS QUESTIONS - SEE COMPUTER SCIENCE 2080 - PART II

 CS 06 - 30 VERY SHORT DBMS QUESTIONS - SEE COMPUTER SCIENCE 2080 - PART II

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

Design view , Datasheet view and Using wizard

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

Design view and Using wizard

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

Design view and Using wizard

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

Design view and Using wizard

5.    List the types of query.

Select Query and Action Query

6.    List the types of action query.

Update query, delete query, make table query and append query

7.    Write any four objects of MS-Access.

Table, Form , Query and Report

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

Text, Number, Memo, Yes/No

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

Validation Rule, Validation Text, Caption and Input Mask

10. Write any four examples of database.

Telephone Directory, Marks Ledger, Dictionary, Attendance Register

11. Write any four examples of DBMS.

Ms-Access, Oracle, SQL and Dbase

12. Write any four examples of RDBMS.

Ms-Access, Oracle, SQL, MariaDB

13. Define database.

Database is a collection of systematically organized inter-related data which stores, organizes and retrieves data.

14. Define DBMS.

DBMS is a computerized system that stores data, processes them and provides information in an organized form.

15. Define RDBMS.

RDBMS is a type of DBMS that uses a relational model to organize and manage data, allowing users to easily retrieve and manipulate it.

16. Define MS Access.

MS-Access is a relational database management system developed by Microsoft Corporation which is used to store and manipulates large volume of data in multiple tables.

17. What is primary key?

A primary key is a field or combination of fields in a table that uniquely identifies each record, and is used to establish relationships between tables and enforce data integrity.

18. What is foreign key?

A foreign key in MS Access is a field that establishes a relationship between two tables by referencing the primary key of another table.

19. What is data sorting?

The process of arranging all the records in a table either ascending or descending order based on field or fields is known as sorting. Sorted data is easier to handle than unsorted data.

20. Define filtering.

Filtering is the process of viewing required record of a table that matches the specifies criteria.

 

 

21. What is data processing.

Data processing refers to the manipulation, organization, and analysis of data stored within the Access database.

22. What are field properties?

Field properties are settings or attributes that allow users to control various aspects of data entry, validation, formatting, and behavior within the database

23. What is table in Access?

Tables are the primary building block of database which stores and manages large volume of data into rows and column.

24. What is form in Access?

Form is one of the MS-Access database objects which provides graphical interface to view, modify and add data in a table or multiple linked tables

25. What is query in Access?

Query is an object of database that is used to view, retrieve, change and analyze records from a table or multiple linked tables based on specified condition.

26. What is report in Access?

Report is one of the MS-Access database objects used to present information in an effective and organized format that is ready for printing.

27. What is select query?

Select query is a type of query which is used to select and display the relevant data from the database.

28. What is action query?

Action query is a query that makes changes to or removes many records in just one operation

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

Caption is a field property which gives alternative name given for any field.

30. What are validation text and validation rule?

Validation Text is a field property which displays an error message that appears if the data entered is invalid according to the specified validation rule.

Validation Rule is a field property which is used to limit the values that can be entered into a field.