More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
Computer Science Ics Part 2 Chapter 6 Online Test MCQs With Answers
Question # 1
Each of the following is an example of a valid Access data type EXCEPT:
Choose an answer
Memo
Currency
Name
Text
Previous
Skip
Next
Question # 2
Why are validation rules used in a database?
Choose an answer
Ensure correct data is entered
To avoid typing errors
Both A and B
Neither A nor B
Previous
Skip
Next
Question # 3
Which of the following view in MS Access looks like an electronic spreadsheet?
Choose an answer
Datasheet
QBE
Relationship
Design
Previous
Skip
Next
Question # 4
The data in tables is entered in:
Choose an answer
Design view
Normal view
Datasheet view
Layout view
Previous
Skip
Next
Question # 5
The name of actual and formal parameters
Choose an answer
May or may not be same
Must be same
Must be different
Must be in lowercase
Previous
Skip
Next
Question # 6
How many table views are available in Microsoft Access?
Choose an answer
4
3
2
1
Previous
Skip
Next
Question # 7
Which of the following methods are used for creating a table in Access?
Choose an answer
Creating table in Design view
Creating table by using wizard
Creating table by entering data
All
Previous
Skip
Next
Question # 8
To select all records that begin with letters A through G
Choose an answer
<="G"
Like "G"
<> A
> A
Previous
Skip
Next
Question # 9
A record is a ------------------- in table
Choose an answer
row
field
table
data
Previous
Skip
Next
Question # 10
Dummy question 2
Choose an answer
a
2
b
f
Previous
Skip
Next
Question # 11
All numbers greater than 0 and less than 100
Choose an answer
< 0 and > = 100
> 0 and < = 100
< > 100
> = 1
Previous
Skip
Next
Question # 12
Which of the following is NOT suitable for an input mask?
Choose an answer
Street address
Telephone number
A date
Social security number
Previous
Skip
Next
Question # 13
Every field in a table has:
Choose an answer
Field name and data type
field name and a field number
Field number and a data type
Field name, field number, and data type
Previous
Skip
Next
Question # 14
The table columns describe the ?
Choose an answer
data type
actual data
unique name
all
Previous
Skip
Next
Question # 15
Which view is used to add, edit or delete records form a table?
Choose an answer
Record view
Datasheet view
Design view
Edit view
Previous
Skip
Next
Question # 16
Which data type can be used to define a field that consists on only numbers to be used in calculations?
Choose an answer
Text
Memo
Number
Date/Time
Previous
Skip
Next
Question # 17
Field properties are shown in :
Choose an answer
Design view
Datasheet view
A and B
None
Previous
Skip
Next
Question # 18
Which of the following can be found in an MS Access database file?
Choose an answer
Tables
Forms
Queries
All
Previous
Skip
Next
Question # 19
Which of the following menus is used to switch between table views?
Choose an answer
Edit
File
Tools
View
Previous
Skip
Next
Question # 20
Which rule states that a record form a table cannot be deleted if its associated record exists in related table?
Choose an answer
Referential integrity
Entity relationship
Normalization
All
Previous
Skip
Next
Question # 21
What symbol indicates that you are editing a record?
Choose an answer
Pencil
Black arrow
Key
Asterisk
Previous
Skip
Next
Question # 22
The name cannot exceed characters in length
Choose an answer
64
50
56
70
Previous
Skip
Next
Question # 23
What is the default field size of a text data type field?
Choose an answer
2
5
20
50
Previous
Skip
Next
Back