Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CS-10 Chapter-8 Database Management System

Total questions: 74

Worksheet time: 37mins

Name
Class
Date
1.
Name
4 lines
2.
Roll Number
4 lines
3.
Which of the following is not the MS-Access database object?
a)
Print
b)
Table
c)
Form
d)
Report
4.
Which of the following data type is appropriate to store gender of person?
a)
Memo
b)
Currency
c)
Auto number
d)
Yes/No
5.
Form is designed for ...
a)
Filter data
b)
Print the data
c)
Modify data
d)
Sort data
6.
Query is used to ...
a)
Create table
b)
Retrieve data from database
c)
Print data
d)
Add data
7.
Report is used for …
a)
Filter data records
b)
Print data records
c)
Add data records
d)
Create tables
8.
Which of the following is not a data type in MS-Access?
a)
Text
b)
Date/Time
c)
Picture
d)
Number
9.
What is the maximum length of text field?
a)
512 characters
b)
25 characters
c)
255 characters
d)
No limit
10.
Which of the following is not a field property?
a)
Indexed
b)
Field size
c)
Format
d)
Color
11.
What type of data type is used to store picture in a table?
a)
Memo
b)
OLE object
c)
Hyperlink
d)
Currency
12.
Which of the following is true for uniquely identifies any record from the database?
a)
Index
b)
Memo
c)
Row
d)
Primary key
13.
The maximum field size of Memo data type in MS-Access is … characters.
a)
64,000
b)
255
c)
No limit
d)
1024
14.
The maximum field size of Number data type in MS-Access is …
a)
1, 3, 5, or 9 bytes
b)
1, 2, 4, or 8 bytes
c)
No limit
d)
2, 4, 6, or 12 bytes
15.
The maximum field size of Date/Time data type in MS-Access is …
a)
4 bytes
b)
2 bytes
c)
6 bytes
d)
8 bytes
16.
The maximum field size of AutoNumber data type in MS-Access is …
a)
4 bytes
b)
2 bytes
c)
6 bytes
d)
8 bytes
17.
The maximum field size of Currency data type in MS-Access is …
a)
4 bytes
b)
2 bytes
c)
8 bytes
d)
12 bytes
18.
The maximum field size of OLE Object data type in MS-Access is …
a)
up to 512 mb
b)
up to 1 gb
c)
up to 4 gb
d)
no limit
19.
The maximum field size of Hyperlink data type in MS-Access is … characters.
a)
2,000
b)
1,000
c)
64,000
d)
no limit
20.
The maximum field size of Lookup Wizard data type in MS-Access is …
a)
2 bytes
b)
8 bytes
c)
6 bytes
d)
4 bytes
21.
Which of the following is/are the example of database?
a)
Marks ledger
b)
MS-Access
c)
MySQL
d)
Dictionary
22.
Which of the following is/are the examples of DBMS?
a)
Salary sheet
b)
Telephone directory
c)
ORACLE
d)
dBase
23.
Which of the following is/are the advantages of DBMS?
a)
Stores huge amount of data records
b)
Provides backup and recovery
c)
Initial cost is low
d)
Reduce data redundancy
24.
Which of the following is/are not the object of MS-Access?
a)
Table
b)
Record
c)
Form
d)
Query
25.
Which of the following is/are the data type of MS-Access?
a)
Table
b)
Auto number
c)
Caption
d)
Lookup wizard
26.
Which of the following is/are the field properties of MS-Access?
a)
Default value
b)
Required
c)
Validation text
d)
OLE object
27.
When the field in the table is set to primary key the user can not …
a)
add new data record
b)
leave the field blank
c)
delete the data record
d)
insert the duplicate data value
28.
Using the form object user can
a)
add new data record
b)
modify existing data record
c)
print the data record
d)
view the data record
29.
Using the query object user can
a)
add new data record
b)
view records in sorted form
c)
retrieve filtering the data records
d)
print data records
30.
What is/are the use of action query in MS-Access?
a)
Retrieve data records in crosstab view
b)
Mass changes in one operation
c)
Print all records at once
d)
None
31.
Which of the following data type has/have 8 bytes field size in MS-Access?
a)
Date/Time
b)
Lookup Wizard
c)
Currency
d)
Yes/No
32.

The object of MS-Access that stores the data is known as …

(a)  

33.

The data type which is used only for integer value.

(a)  

34.

The logical data type of MS-Access is …

(a)  

35.

A column in a table is also known as …

(a)  

36.

A row in a table is also known as …

(a)  

37.

The suitable data type for remarks or biodata.

(a)  

38.

The suitable data type for person or product name.

(a)  

39.

The suitable data type for email or URL.

(a)  

40.

The suitable data type for salary or item price.

(a)  

41.

The suitable data type for sequence of number increased or decreased by 1.

(a)  

42.

The suitable data type for date of birth, edition year or meeting time.

(a)  

43.

The suitable data type for custom list of data or link data from another table

(a)  

44.

The field property of MS-Access limits from wrong data entry.

(a)  

45.

The field property of MS-Access that displays the field name differently in the data sheet view.

(a)  

46.

The field property of MS-Access that automatically insert value while adding new record.

(a)  

47.

The field property of MS-Access that allows user either to leave the filed blank or not.

(a)  

48.

The field property of MS-Access that displays some messages when the user violates the validation rule policy.

(a)  

49.

The field property of MS-Access that limits the user enter only the defined size of data value.

(a)  

50.

The field property of MS-Access that increases the search operation in the database.

(a)  

51.

The process of arranging data records either in ascending or descending order is also known as …

(a)  

52.

The process of retrieving only the required data records from the table or tables based on specific condition or criteria is known as …

(a)  

53.

The systematic collection of related data of any person, places, things or objects etc. is known as …

(a)  

54.
MS-Access is the Spreadsheet software.
a)
True
b)
False
55.
The default extension of MS-Access is .DBF
a)
True
b)
False
56.
Primary key field cannot be left blank.
a)
True
b)
False
57.
We can not change the data type of a field at designing time.
a)
True
b)
False
58.
Memo field is used to store long information beyond the text.
a)
True
b)
False
59.
Yes/No logical field stores one bit of data.
a)
True
b)
False
60.
More than one table can be created in MS-Access.
a)
True
b)
False
61.
Query can not be used to apply mathematical calculations in the table.
a)
True
b)
False
62.
We can not make the form as the source of table.
a)
True
b)
False
63.
* is a wild card that represents any characters in an expression.
a)
True
b)
False
64.
? is a wild card that represents any one character in an expression.
a)
True
b)
False
65.
A form allows displaying one complete information at once.
a)
True
b)
False
66.
A query can not used to select record from many tables.
a)
True
b)
False
67.
Indexed decreases the speed of the query and sort operations.
a)
True
b)
False
68.
Report is used to prepare database for final printing.
a)
True
b)
False
69.
Field name can be up to the 255 characters in MS-Access.
a)
True
b)
False
70.
DBMS
a)
Database Management System
b)
Data Manage System
c)
Database Manager System
71.
RDBMS
a)
Red Database Management System
b)
Relational Database Management System
c)
Real Database Manage System
72.
SQL
a)
Sequential Query Language
b)
Small Query Learning
c)
Structured Query Language
73.
MDB
a)
Microsoft Database
b)
Middle Database
c)
Meta Data Box
74.
DBA
a)
Data Box Admin
b)
Database Administrator
c)
Database Addition

Similar Resources on Wayground

3 SAS 2 MATEMATIKA

70 questions

3 SAS 2 MATEMATIKA

quiz

Worksheet

•

3rd Grade - University

Practice Chapter 6 Test

77 questions

Practice Chapter 6 Test

quiz

Worksheet

•

9th - 12th Grade

Honors Biology Final Practice

71 questions

Honors Biology Final Practice

quiz

Worksheet

•

KG - University

SPANISH: VERB SER & PROFESSIONS

77 questions

SPANISH: VERB SER & PROFESSIONS

quiz

Worksheet

•

KG - University

Mr. Bradley's Respitory

79 questions

Mr. Bradley's Respitory

quiz

Worksheet

•

9th - 12th Grade

Regulator Functionality and Components Quiz

78 questions

Regulator Functionality and Components Quiz

quiz

Worksheet

•

12th Grade

ICP Fall Semester Exam Study Guide

79 questions

ICP Fall Semester Exam Study Guide

quiz

Worksheet

•

KG - University

Revision of LO3.1 Cells Review

79 questions

Revision of LO3.1 Cells Review

quiz

Worksheet

•

KG - University