Database Management System - MS Access ----SEE Computer Science 2076 --- Practice Day 7 --- 100 Questions
Ms-Access
Questions and Answers
1. Database
[SEE 2074, 2073, 2073 U, 2072, 2071 S, 2064, 2065]
2. Electronic
Database [SQE 2075K]
3. Data
[SEE 2073] [SLC 2064] [SLC 2070] [[SLC
2065 S] [SLC 2069 S]
4. Information
[SLC 2070]
5. DBMS
(Database Management System) [SEE 2075 U] [SEE 2074 U] [SLC 2066] [SLC 2067] [SLC 2067 S] [SLC 2069 S] [SQC 2075K]
6. RDBMS
(Relational Database Management System) [SQE 2074]
7. Importance
/ Advantages of DBMS / Computerized
database [SEE 2075] [SLC 2071]
8. Objects
of MS-Access [SEE 2074 U] [SLC 2071]
9.
Form [SEE 2073 U]
[SLC 2064] [SLC 2066] [SLC 2068] [SLC
2065 S] [SLC 2069 S] [SQE 2075K] [SQE 2074]
10.
Importance
/ Function / Advantages of form [SEE 2075] [SLC 2064] [SLC 2066] [SLC 2065 S] [SLC 2070 S] [SQE
2074]
11.
Query [SEE 2075 U] [SEE 2075 S2] [SLC 2072] [SLC 2065] [SLC
2069] [SEE 2066 S] [SLC 2068 S] [MM
2076] [PMT 2075K]
12.
Advantages
of query [SLC
2065]
13.
Report [SEE 2074 U] [SEE
2071 S] [SLC 2070] [SLC 2067 S]
14.
Why is Report created? [SEE 2075 U] [SLC
2067]
15.
Importance
of report [SEE
2071 S] [SLC 2070] [SLC 2067 S]
16.
Data type
[SEE 2075 S2, 2074,
2073, 2072, 2064, 2066]
[SLC 2070]
17. While
designing table structure which data types are suitable to store information
about teacher’s name, address, salary and date of birth. [SLC 2065] [SLC 2068 S]
18. Identify
a record, field and value from the following table structure.
[SQE 2074]
Roll
Name Marks
1
Kopila
87
2
Rabin Rana 56
19.
Record
[SEE 2075 S2]
20.
Field
[SEE 2075 S2]
21. Sorting
[SEE 2073 U] [SLC 2068]
22. Primary
key [SEE 2075, 2073, 2071 S, 2067]
23. Uses
of Primary key [SLC 2069]
24. Importance
of Primary Key [SEE 2073] [SLC
2069 S]
25. Data
Redundancy [SEE 2074]
MCQ (Multiple Choice Questions)
1.
Ms-Access
is a ............ software. [SEE 2075 S2]
(i)
Word processing (ii) DBMS (iii) Spreadsheet (iv) Web
2.
Which
is an example of database? [SLC 2064]
DBase MS-Access Telephone Directory All
3. ……………
is the DBMS. [SLC 2065]
i) Fox-Pro ii) MS-Excel iii) Lotus-123 iv) All of the above
i) Fox-Pro ii) MS-Excel iii) Lotus-123 iv) All of the above
4. Which
of the following is database application? [SLC 2070]
i)
MS-Word ii) MS-Access iii) MS-Excel iv) QBASIC
5. Which
of the following is not a database application? [SLC 2069]
i) Oracle ii) Foxpro iii) MS-Access iv) MS-Excel
i) Oracle ii) Foxpro iii) MS-Access iv) MS-Excel
6. What is extension of access
database? (MS-Access 2003 version) [SLC 2066]
DBF MDB MBD DBM
7. The
data type appropriate to store salary is: [SLC 2067]
i)Memo ii)Currency iii)Text iv) Auto number
8. Date/Time
occupies ………. bytes of memory. [SLC 2066,
2067]
i) 4 ii) 2 iii) 8 iv) 16
i) 4 ii) 2 iii) 8 iv) 16
9.
The
maximum size of text field in MS-Access is …………. [SLC 2068 S] [SLC 2070]
i) 50 ii) 10 iii) 6400 iv) 255
i) 50 ii) 10 iii) 6400 iv) 255
10. The
logical field data type of MS-Access is______________ [SLC 2064]
i. Yes/No ii. True/False iii.
On/Off iv. All
of the above.
11.
Which
data type consumes the least storage space? [SEE 2074]
(i) Text (ii) Yes/No (iii) OLE object (iv)
Memo
12. The
default data type of MS-Access is: [SLC 2068 S, 2069, 2074] [SQE 2074K]
i) Number ii)Text iii) Memo iv) Auto number
i) Number ii)Text iii) Memo iv) Auto number
13. The
default field size of “AutoNumber” data type is [SEE 2075 S2] .
i. Byte ii.
Integer iii. Long
Integer iv. Long Integer
14.
Which is not MS-Access object? [SQE 2074K]
a) Form b) Query c) Caption d) Table
15. Field size, format, input mask, caption and
default values are: [SQE 2074K]
Key elements field
properties Navigating modes data
types
16. The _________________ key uniquely identifies
each record. [SLC 2066]
Primary database Object premier
17. Primary
key does not accept …………… [SLC 2064, 2065, 2068, 2074] [SQE 2074K]
i) Text ii)
Number iii) Null value iv) None of the above
18.
In
MS-Access data are stored in ……………… [SLC 2068]
i) Form ii) Query iii) Table iv) All of the above
i) Form ii) Query iii) Table iv) All of the above
19.
Which
component of MS-Access is used to enter data? [SLC 2065]
i.
Query ii.
Forms iii. Report iv. Both (i) and (ii)
20. Which
component of MS-ACCESS does not allow entering data? [SLC 2064]
i.
Table ii. Query iii. Form iv. None of them
21. ……………..
query changes value in main table. [SLC 2068 S]
i) Select ii) Update iii)
Both (i) &(ii) iv) None
of the above
22. Which
is not a type of query? [SLC 2067] [SEE 2073]
i) Search ii) Select iii) Update iv)All of the above
i) Search ii) Select iii) Update iv)All of the above
23. Report
can be generated by using data from …………[SLC 2068 S]
i) Table ii) Query iii) Forms iv) Both (i) &(ii)
i) Table ii) Query iii) Forms iv) Both (i) &(ii)
24. ………………..
object of access is used to print formatted data. [SLC 2068] [SEE 2073]
i) Query ii) Form iii) Report iv) Table
i) Query ii) Form iii) Report iv) Table
25. The
object of MS-Access that is used to generate hard copy of records. [SLC 2066]
i) Query ii) Table iii) Form iv) Report
i) Query ii) Table iii) Form iv) Report
26. __________allows
MS-Access to query and sort record faster. [SEE 2075 S2]
i. Sorting ii. Editing iii.
Filtering iv.
Indexing
27.
Collecting
multiple related fields is called: [SLC 2067]
i) Records ii)Table iii) Forms iv)Query
i) Records ii)Table iii) Forms iv)Query
28. Record
of the table is also knows as ...... [SEE 2075 S2]
(i)
Tuple (ii) Field (iii) Text (iv) All
29. Row
is also called …………[SLC 2069] [SEE 2074]
i) Record ii) Field iii) Database iv) Table
i) Record ii) Field iii) Database iv) Table
30. The
columns in database tables are called: [SLC 2070] [SEE 2073]
True / False
1. MS-ACCESS
is spread-sheet software. [SLC 2065 S]
2. MS-Access is not a spreadsheet software. [SLC
2071 S]
3. The extension of database file created by
MS-Access is .BDF. [SLC 2066 S]
4. MS-Access
is not spreadsheet software. [SLC 2067 S]
5. A
database can contain multiple tables. [SLC 2069 S]
6.
MS-Access
is DBMS software. [SLC 2072]
7.
A field name can be upto 255 characters long.
[SQE 2075K]
8. The
data in primary key field need to be unique and not null. [SLC 2065 S, 2072]
9. Primary key does not accept null value. [SLC
2066 S]
10. The
primary key field can also be left empty. [SLC 2067 S]
11.
Primary key field can accept duplicate values
. [SEE 2075 U]
12.
Primary
key accepts null value. [SEE 2074 U] [SLC 2071 S]
13.
A
query is used to select fields and records from one or more tables. [SLC 2065
S]
14. An action query makes changes in a table. [SLC 2071] [SEE 2074 U]
15.
A
query is used to select fields and records from only one table. [SLC 2072]
16. Update
Query does not change the data of table.
[SLC 2070 S]
17. A
query is used to select fields and records from many tables. [SLC 2065 S, 2067
S]
18.
Select
query is used to retrieve and display records from the selected table. [SEE
2075]
19.
The
maximum field size of text field is 255 characters. [SEE 2075 U]
20. A form is an object of MS-Access used for
entering data. [SLC 2071]
21.
Report is a database object used to print final
report.
[SEE 2073 U]
22. Index
makes sort process fast. [SLC 2070 S]
23. Index
increases the speed of the query and sort operations. [SLC 2067 S, 2071 S]
24. Index
decreases the speed of the query and sort operations. [SLC 2065 S] [SLC 2072]
25.
Indexing
is the process of arranging the records in ascending or descending order. [SEE
2075]
26.
Arranging all the records in a table either
ascending or descending order is known as filtering. [SEE 2073 U]
27. A
row in a table is known as record. [SLC 2069 S]
28.
Column is also called field [SEE 2075 U].
29.
Money is a data type used in
MS-Access. [SEE
2073 U]
30.
Table is not the data type of
MS-Access. [SLC 2071 S]
31.
The size of currency data type is 10 Bytes. [SEE 2075]
32.
Validation
rule specifies the expression that checks the invalid data. [ SQE 2075K]
33.
Validation rule will limit data
entry. [SEE 2075]
34.
OLE
is the data type of MS Access. [SQE
2075K]
35. Memo data type cannot be indexed. [SLC 2066 S]
36. The default size of text data type is 50. [SLC
2066 S]
37. Text is and object of MS-Access. [SEE 2075
U]
38. Default
text field size is of 255 characters. [SLC 2069 S]
39. Data like sound
and pictures are held by memo data type. [SLC 2069 S]
40. Auto
number data type is used to store data supplied by us. [SLC 2070 S]
41. Auto Number Data consumed 2 bytes of memory space. [SEE 2075
U]
42. Maximum data size of an auto number is 4 bytes. [SEE
2073 U]
43. Formatted
document is also called report. [SLC
2070 S] True
44. Graphics can also be stored in MS-Access
database. [SLC 2071] [SEE 2074 U]
45.
Maximum field size of
memo field is 256 characters. [SLC
2071]
