1. What is the file extension of ms access database?
a. .mad b. .adb c. .dbm d. .mdb
2. The latest version of ms access is
a. 2000 b. 8.0 c. Xp d. 2006
3. Which of the following statement is not correct?
a. Save the database file before
working on it b. Macro is not an
object
c. Query works on sql standard d. Form is the front-end object
4. Which of the following statement is correct?
a. Table can be created in two ways b. Query stores the data
like table
c. From can be created in two ways d. Reports can be
generated without any table
5. Data can be defined as
a. Piece of information b.
Raw facts c. Recessed information d.
none
6. Collection of data is known as
a. Database b.
Dbms c.
Rdbms d. Information
7. When data is processed, it obtains
a. Database b.
dbms c.
rdbms d. Information
8. DBMS stands for
a. database managerial system b.
database management system
c. database basic managerial
system d.
database basic management system
9. The key difference between dbms
and rdbms is termed in
a. 12 Codd's rules b.
6 Codd's rules c. relationship d.
None of above
10. Fields are also termed as
a. column b.
record c.
entity d. row
11. Association among entities is expressed in the term of
a. attributes b. Relationship c.
query d. properties
12. When primary key is applied to the field, the field
a. will not accept null values b.
Will not accept duplicates
c. both a& b d. none of
above
13. When indexing is done in the particular field, the field
a. Will not accept null valued b. May or May not accept
duplicates
c. both a &b d. none of above
14. Which of the following option is best suit for ms access
definition?
a. dbms
b.
rdbms c.
back end d.
Microsoft database
15. Tables, forms, queries, reports all are the
a. objects b.
field c.
database d.
Options
16. You have to apply the constraint of 'not null' values, than
which property you will apply?
a. primary key b.
index c.
required d. a
& c
17. ole stands for
a. Object link & Engaging b. object linking & Embedding
c. object like & energy d. Online linking & embedding
18. Table can be created by...in ms access
a. 2 ways b.
3 ways c.
4 ways d.
5 ways
19. From which data type drop down menu can be created in access
a. ole
object b.
drop down c. hyperlink d.
Look up wizard
20. Which data types support large number of text (characters)?
a. Memo b.
text c.
ole object d. Look up wizard
21. Which of the following data type is used for Boolean Value?
a. Currency b.
Hyperlink c. Yes/No d.
Look up wizard
22. Maximum Length of field name
a.50 b.
64 c. 255 d.256
23. Which field property allows you to set date in "mm/dd/yy"?
a. date b. format c. field size
d. caption
24. Which is not part of report?
a. Title b.
Report footer c. Detail d. Page footer
25. User cannot left the field blank or field cannot contain the
null value because of the Following property
a. indexed b.
required c. validation d. default value
26. User cannot make duplicate entry because of the following
property
a. indexed b.
required c. validation rule d.
default value
27. You have to set the validation rule for 'date should be earlier
than today' which of the following is correct
a.<=date() b.<=date c.<date()
d.<date
28. you have to set the validation rule for salary should not be
less than 2500 and should not exceed 15000, which of the following is correct
a. <=2500 or >=15000 b.>= 2500 and<=15000 c.<2500
or>15000 d.<2500 and >15000
29. To create the input mask for letter (a to z), entry required,
which of the following character is used
a. l b.? c.
& d. C
30. The special form that links different objects for integration is
called...
a. Package form b.
Entry form c. Switchboard
d.
Auto form
31. Primary key is essential for
a. not to allow duplicate entry b. not to allow null
values
c. to create relationship d. all of above
32. To create the relationship, which of the following is essential?
a. primary b.
foreign key c. both of above
d.
none of above
33. While creating the relationship, the "enforce referential
integrity" means
a. Value cannot be entered into
second table other than specified in the first table's field
b. Value can be entered into the
second table other than specified in the first's table's field
c. Can not make null entries
d. Can not make entries
34. SQL stands for
a. Structured query line b.
structured question line
c. Structured query language d.
Structured question language
35. DCL is a part of DBMS and it stands for
a. Data count language b.
Data control language
c. Data computer language d. Data command language
36. In ms-access, SQL statement can be written by choosing
a. Design view b.
Datasheet view c. Query view d.
sql view
37. How many types of action queries are in ms-access?
a. 4 b. 5 c. 6 d. 7
38. To add or deduct the values on the table, which of the following
query, you will use.
a. Append query b.
update query c. select
query d. none of the above
39. Ms-access form is also termed as ----in database terminology
a. back end b. front end
c. middle edge d. application.
40. To modify a form, you will go from
a. design view b. datasheet view c. form view d.
run view
41. Form can be based on -----
a. table b.
query c. table
& query d. table, query & form
42. ---------------is the output of database
a. Report b. form c.
macro d. query
43. Report can be based on -------------
a. report b. query c. table & query d. table,
query & form
44. The text that is written inside 'Report footer' on three page
long report, how many times will repeat the footer?
a. 2 times b. 3 times c. 4 times repeat d. will not
repeat
45. The grand total is the part of report....
a. Report footer b. page footer c. details d.
report header
46. Set of actions contained in one object is known as
a. Form b. report c. macro d. Query
47. What is the difference between form and report?
a. Form is an object and report is
not. b.
Form relies on report
c. Report relies on form d. form is the front-end part and
report is the final output of database
48. Data can be entered into the table by using
a. Form b.
report c. A and
B d. none on above
49. Report can be created with -----------------table(s) at a time
a. Just one b.
two tables c. three tables d.
many
50. Macro can be used with
a. Form b. report c. Query d. all of the above
Answer Sheet
1
|
d
|
2
|
c
|
3
|
b
|
4
|
b
|
5
|
b
|
6
|
a
|
7
|
d
|
8
|
b
|
9
|
a
|
10
|
a
|
11
|
b
|
12
|
c
|
13
|
c
|
14
|
b
|
15
|
a
|
16
|
D
|
17
|
b
|
18
|
b
|
19
|
d
|
20
|
a
|
21
|
c
|
22
|
c
|
23
|
b
|
24
|
d
|
25
|
b
|
26
|
a
|
27
|
c
|
28
|
b
|
29
|
b
|
30
|
c
|
31
|
d
|
32
|
c
|
33
|
a
|
34
|
c
|
35
|
b
|
36
|
d
|
37
|
a
|
38
|
a
|
39
|
b
|
40
|
a
|
41
|
c
|
42
|
a
|
43
|
c
|
44
|
d
|
45
|
a
|
46
|
c
|
47
|
d
|
48
|
a
|
49
|
d
|
50
|
d
|
||||||||||||
