12th class (Fsc) computer unit 6 MCQs
26. Each of the following is an example of a valid Access data type EXCEPT:
a. Name
b. Memo
c. Text
d. Currency
27. What is the term for a characteristic or attribute of an object that determination how the object looks and behaves?
a. Size
b. Color
c. Orientation
d. Property
28. Field properties determine:
a. Default value
b. Field size
c. Input mask
d. All
29. Field properties are shown in:
a. Design view
b. Datasheet view
c. Both A & B
d. None
30. Which of the following is suitable for an input mask?
a. A date
b. Social security number
c. Telephone number
d. All
31. Which of the following is not suitable for an input mask?
a. Street address
b. Telephone number
c. Social security number
d. A date
32. Why is validation rules used in a database?
a. Ensure correct data is entered
b. To avoid typing errors
c. Both A & B
d. Neither A or B
33. Which field type can be indexed?
a. Hyperlink
b. Memo
c. OLE
d. Number
34. Which does not improve data entry?
a. Indexing
b. Input mask
c. Required fields
d. Validation rules
35. Which format property displays text in uppercase?
a. TEXT
b. Greater than sign
c. Upper
d. Less than sign
36. What happens when you enter the last field of a record and press Enter key?
a. Record selector moves to next record
b. Record is saved
c. Record selector changes to a triangle
d. All of these
37. Which data type is the default type:
a. Text
b. Memo
c. Auto Number
d. Number
38. Which of the following is logical data type in MS Access?
a. True/False
b. Boolean
c. Log
d. Yes/No
39. Which data types can be used to define a field that is also formatted for data entry and display?
a. Date/Time
b. Text and memo
c. Number and currency
d. All
40. Which of the following buttons of find and replace dialog box is clicked to start the search process?
a. Search
b. Find
c. Next
d. Find next
41. Which view is used to add, edit or delete record from table?
a. Design view
b. Record view
c. Edit view
d. Datasheet view
42. The column of a table corresponds to:
a. Record
b. Table
c. Cell
d. Field
43. Which symbol indicates that you are editing a record?
a. Key
b. Pencil
c. Asterisk
d. Black arrow
44. Which key is used to move field to field in table window in datasheet view?
a. Enter
b. Tab
c. Spacebar
d. Esc
45. In MS Access, find and replace command is found in:
a. Tool
b. File Menu
c. View Menu
d. Edit Menu
46. Find and replace command is found in:
a. Tool
b. Edit menu
c. View menu
d. File menu
47. How many types of relationship?
a. 4
b. 2
c. 5
d. 3
48. The rule that a record from a table cannot be deleted if it’s associated record exits in a related table is called ……… rule.
a. Normalization
b. Referential integrity
c. Entity– relationship
d. All of them
49. The relationship between countries and their capitals is an example of ……… relationships.
a. Many-to-many
b. One-to-one
c. None of them
d. One-to-many
50. Which of the following is a one-to-many relations:
a. Person – Date of birth
b. Student – Reg no.
c. Country – Capital
d. Mother – Daughter