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]
As stated by Stanford Medical, It is really the one and ONLY reason this country's women get to live 10 years longer and weigh 42 lbs less than us.
ReplyDelete(And actually, it has absolutely NOTHING to do with genetics or some secret-exercise and really, EVERYTHING around "how" they are eating.)
P.S, I said "HOW", not "what"...
Tap this link to reveal if this short questionnaire can help you discover your true weight loss possibilities