12th class (Fsc) computer unit 6 MCQs
51. A referential integrity constraint is a rule that maintain consistency among the:
a. rows of two table
b. columns of two tables
c. attribute of two tables
d. two columns of same table
52. How is primary key identified in the Relationships window?
a. Bold field
b. Key beside the field
c. Underlined field
d. Primary key typed beside the field
53. What is the advantage of enforcing referential integrity?
a. Prevents orphan records between tables
b. Ability to create a query using two tables
c. Using sub datasheet in a table
d. All
54. What must be true about two fields to create a relationship between them?
a. Same name
b. Same field type
c. Both A & B
d. None
55. Which type of relationship is most common?
a. Many-to-Many
b. One-to-One
c. Many-to-One
d. One-to-Many
56. What command is required to actually execute a filter on a table?
a. Clear grid
b. Remove filter
c. Find next
d. Apply filter
57. Which filtering method allows you to use data in a field as criterion for filtering?
a. Clear grid
b. Filter by form
c. Find next
d. Apply filter
58. Which of the following is an example of a filter by form expression?
a. 4 OR 5
b. Abdullah
c. None
d. 1985
59. What is Z to A order called?
a. Condescending
b. Ascending
c. Alphabetical
d. Descending
60. The Sort Ascending button will:
a. Filter out selected records
b. Order all records alphabetically
c. Delete selected records
d. Order all records reverse alphabetically
61. The wildcard ……… Sal[ei]ma.
a. Saleema
b. Salima
c. Both A & B
d. None of them
62. Which wildcard replaces one character only?
a. null
b. *
c. !
d. ?
63. How find four names that starts with H, the criteria is specified as?
a. H ? ? ? ?
b. H * a
c. H # #
d. H ? 4
64. The graphical query tool is known as:
a. Query form
b. Query grid
c. View form
d. Design grid
65. How many query views are available in MS Access?
a. 4
b. 2
c. 5
d. 3
66. To find a name that start with S, the criteria is written as:
a. ? S
b. S # ?
c. S *
d. S #
67. ……… is used to retrieve data from one or more tables.
a. Query
b. Macro
c. Form
d. Table
68. Which of the following describes a select query?
a. Selects records based on specific criteria
b. Limits the records shown
c. Limits the fields shown
d. All
69. What query type modifies the values in one or more records within a table?
a. Update
b. Append query
c. Select query
d. Delete
70. Which of the following is not an example of an Action query?
a. Append query
b. Delete query
c. Make table query
d. Convert query
71. Which query is used to add records from one table to the end of another table?
a. Append query
b. Delete query
c. Make Table query
d. Convert query
72. Which type of query is used to join two tables?
a. Find duplicate
b. Select
c. Cross table
d. Find unmatched
73. Why a query is created using two tables?
a. To create many special purpose queries
b. To save space
c. To use it as a basis for a form
d. All
74. Which type of query gives provides a dialog box to type a value for criteria?
a. Select query
b. Parameter query
c. Cross table query
d. Union query
75. Which type of query copies selected records to a new table?
a. Move
b. Make-Table
c. Delete
d. Append