12th class (Fsc) computer unit 6 MCQs
chapter 6 MCQs 12th Class computer
Table and Query:
1. The degree of relation refers to the number of:
a. Field
b. Rows
c. Columns
d. Tables
2. Each set of related items in a table is called:
a. Field
b. Table
c. Query
d. Record
3. An IDE stands for:
a. Integrated Disk Environment
b. Input Desktop Error
c. Integrated Development Environment
d. Input Data Error
4. Which of the following can be found in an MS Access database file?
a. Queries
b. Tables
c. Forms
d. All
5. The data in table is entered in:
a. Datasheet view
b. Design view
c. Layout view
d. Normal view
6. How many table views are available in Microsoft access?
a. 2
b. 4
c. 1
d. 3
7. As in design view, you can move from field to field in the table window in datasheet view using ……… button.
a. Enter
b. Tab
c. Spacebar
d. Esc
8. ……… table views are available in Microsoft Access.
a. 3
b. 1
c. 4
d. 2
9. Which of the following view in MS-Access is used to define the structure of table?
a. Relationship view
b. Datasheet view
c. Design view
d. QBE view
10. Which of the following is not displayed in Design view?
a. The properties of the selected filed
b. The data type of each field
c. The field names
d. The contents of each field
11. Which of the following view in Access looks like an electronic spreadsheet?
a. Relationship view
b. Datasheet view
c. Design view
d. QBE view
12. Which is needed to add, editor delete records from a table?
a. Design view
b. Record view
c. Edit view
d. Datasheet view
13. Which of the following menus is used to switch between table views?
a. Tool
b. Edit menu
c. View menu
d. File menu
14. Which of the following menus is used to switch between table views?
a. Creating table by entering data
b. Creating table in design view
c. Creating table by using wizard
d. All
15. Every filed in a table has:
a. Field number and a data type
b. Field name and a data type
c. Field name, field number and data type
d. Field name and a field number
16. To find a four-character name that starts with H, the criteria is specified as:
a. H????
b. H*4
c. H####
d. H?4
17. What is the default field size of a Text data type in MS-Access?
a. 20
b. 2
c. 50
d. 5
18. Which data type is default type in Access?
a. Text
b. Memo
c. Auto number
d. Number
19. Create command is used to create:
a. Report
b. Table
c. Query
d. View
20. Every table must have a:
a. Primary key
b. Foreign key
c. Sort key
d. Composite key
21. Which data type can be used to define a field that consists of only numbers to be used in calculations?
a. Number
b. Text
c. Date/time
d. Memo
22. The maximum length of text type field in MS Access is:
a. 155 character
b. 50 characters
c. 255 character
d. 250 characters
23. Which data type can be used to define a field that contains data content such as a chart, picture or graphic object?
a. Memo
b. Hyperlink
c. Auto Number
d. OLE object
24. Which data type can be used to create a sequential number for each record that can also serve as a primary key?
a. Auto Number
b. Number
c. Currency
d. Memo
25. Which data type can be used to define a field that contains an active Web address as its content?
a. Lookup wizard
b. Hyperlink
c. Auto Number
d. OLE object