CS 06 - 30 VERY SHORT DBMS QUESTIONS - SEE COMPUTER SCIENCE 2080 - PART II
.png)
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.
.png)