1 |
Which of the following is the correct association? |
File = column
Record = row
Field = row
Record = table
|
2 |
A collection of data that consists of name, address and email of a person is called: |
Byte
Record
Character
Field
|
3 |
The smallest meaningful unit of data in a database is called: |
Byte
Record
Character
Field
|
4 |
Each set of related items in a table is called: |
Table
Record
Field
Query
|
5 |
Each separate piece of information stored in a record is called: |
Table
Record
Field
Query
|
6 |
A report may be based on a : |
Table
Query
Both a and b
None
|
7 |
An example of a query is: |
Selection of all records that match a set of criteria.
Importing of a spreadsheet file into the database
Search for a specific record
Both a and c are correct
|
8 |
The maximum numbers of tables in a database can be: |
1
2
3
Any
|
9 |
The columns of a table correspond to: |
Table
Record
Field
Cell
|
10 |
Which of the following are objects in an MS Access database? |
Tables,forms,queries, and reports
Database, Datasheet, And forms views
Folders and Tools
All of these
|
11 |
Which object is used to store data and define structure for the data in a database? |
Table
Macro
Form
Query
|
12 |
Which of the following is NOT a database object? |
Table
Query
Report
MS word
|
13 |
Which is displayed in title bar of an open database? |
Program name
Database name
Object type
All of these
|
14 |
Which option in MS Access is used to create a new database form scratch? |
Access template
Blank database
Existing databse
New folder
|
15 |
An MS Access table contains: |
Fields
Records
Characters
All
|
16 |
A report is a complete set of _______ field: |
Distinct
Related
Designed
All
|
17 |
Microsoft access saves the database with the extension: |
.mdb
.msdb
.madb
.mxls
|