1.
What is extension of access
database? (MS-Access 2003 version)
DBF MDB MBD DBM
2.
_____ is the table design creating
option to create custom table design.
Datasheet Design view Wizard Link Table
3.
Object primarily used to store the
data in database.
Table Form Query Report
4.
A field name can be up to _____
characters long.
40 46 64 2048
5.
_____ is a data type used for
lengthy text and numbers
Text Long Text OLE Object Memo
6.
Data type that requires 8 bytes of
storage.
Yes/No Currency Long Integer All of them
7.
The name of caption can be declared
up to _____ characters.
1024 2024 2048 2005
8.
Memory space used by a auto number
data type is _____
1
Byte 2 Bytes 4 Bytes 8 Bytes
9.
The primary key contains _____
value.
Null No Null Number Auto
number
10.
Which specifies the expression that
checks the invalid data.
Validation
Rule Validation Text Input Mask Required
11.
_____ is not a field property of
MS-Access.
Caption Index Color Format
12.
Format symbol that converts all
characters to uppercase.
@ & < >
13.
What
kind of data is kept in memo field?
(i) Hyperlink (ii) Software (iii) Data (iv)
Pictures
14.
What
is the extension of database file in Access?
(i) .DB (ii) .MDB (iii)
.DBF (iv) .ADB
15.
What
is the default size of Access?
(i) 10 (ii) 20 (iii) 30 (iv) 50
16.
Which
is not the database?
i.
Phone diary ii. Mark
ledger iii. Attendance Register iv. Report Card
17.
MS-Access
is a software.
i.
Utility ii. Application iii. System iv. None of the above.
18.
Which
is DBMS?
i.
Database ii. Metabase iii. dBase iv. MS-Excel.
19.
__________uniquely
identifies records of a table.
i.
Foreign key ii.
Primary key iii. Field name iv. Composite key
20.
The
object of MS-Access that stores data is known as________
i.
Query ii. Table iii. Form iv. Report
21.
Which
of the following is not the data type used in MS-Access?
i.
Date/Time ii.
Counter iii. Hyperlink iv. Caption
22.
The
object of MS-Access that is used to prepare read-to-print document is_________
i.
Query ii. Table iii. Form iv. Report
23.
The
Date/Time fields data type occupies_ Bytes of memory.
i.
4 ii. 2 iii. 8 iv.
16
24.
The
extension of database file in MS-Access
is_____________
i.
.DBF ii. .DMB iii. .MDB iv. DMB
25.
A
field property that limits the data to be entered in a field is___________
i.
Validation Rule ii. Format iii. Input Mask iv. Indexed
26.
Which
is the subtype of number data type?
i.
Integer ii. Byte iii. Single iv. All of the above.
27.
__________allows
MS-Access to query and sort record faster.
i.
Sorting ii. Editing iii. Filtering iv. Indexing
28.
The
maximum number of characters that can be stored in a field is determined by_
i.
Field Type ii. Field
Size iii. Field Length iv. Field width
29.
The
logical field data type of MS-Access is______________
i.
Yes/No ii. True/False iii. On/Off iv. All of the above.
30.
The
field size of logical field data type is __________ in MS-Access.
i. 1 bit ii. 1 byte iii. 2 bytes iv.
2 bits
31.
A (n)
____________________ is an organized collection of the related information.
Object database Property document
32.
Field size, format,
input mask, caption and default values are:
Key
elements field
properties Navigating modes data types
33.
The storage size of
date/time type is
4 bytes 1 bytes 8 bytes 16
bytes
34.
The _________________
key uniquely identifies each record
Primary database Object premier
35.
___________________ is a
set of rules used by Access to ensure that the relationships between tables are
valid and that the related data is not accidentally changed or deleted.
Relationship Referential integrity Query Forms
36.
__________________ is an
Access databases objects that information in a printed format.
Table Form Query Report
37.
A
Database Management System can be used to .
i. retrieve information ii. search information iii. sort information iv. all of the above
38.
The
storage size of date and time is .
i.4 bytes ii.6 bytes iii.8 bytes iv.12 bytes
39.
The
data type appropriate to store address is .
i. Memo ii. Currency iii. Text iv.
Auto number
40.
The
object of MS-ACCESS that issued to present the data stored in tables or queries
in a printed form.
i. Query ii. Table iii.Form iv.
Report
41.
A
collection of records for a single subject, such as all of the customer
records.
i. Field ii. Record iii.
Table iv. Data
42.
Which
of the following is not a data type in Microsoft Access?
i. Text ii. Currency iii.
Hypertext iv. Date/Time
43.
A key is a field that
uniquely identifies a record.
i. Candidate
ii. Alternate iii. Primary iv. Foreign
44.
What
is the extension of Access database file?
i. .MBD ii..MDB iii..DBF iv..DFB
45.
The
logical data type of access is .
i. Yes/No ii. True/False iii. On/Off iv. All of the above
46.
Primary
key does not accept
.
i. Text ii. Number iii. Null value iv. None of the above
47.
Field
name can be up to
characters long.
i.64 ii.16 iii.128 iv.40
48.
The
default field size of “AutoNumber” data type is .
i. Byte ii. Integer iii. Long Integer iv.
Long Integer
49.
An
is an organized collection of related information.
i)
object ii) database iii) property iv) document
50.
The
maximum text field size in Access is
i)50 ii)256 iii)10 iv)255
51.
Uniquely
identifies any field.
i)Index ii)Memo field iii)Primary key iv)Query
52.
The
object of Access that stores the data the data is known as
i) Query ii)Table iii)Form iv)Report
53.
Which
of the following is not MS-Access database object?
i.
Table ii. Form iii. Query iv. Print
54.
Which
of the following data type is appropriate to store gender of person in terms M
or F?
i.
Memo ii. Currency iii. Yes no iv. Auto number
55.
Form
is designed for
i.
filters data ii. Sort
data iii. Sort data iv. Modify data
56.
Query
is used to
i.
retrieves data from database ii.
Create table in database iii. Print
database iv. All
57.
Report
is used for
i.
Printing database ii.
Process database iii. Filter
database iv. None
58.
Which
of the following is not a data type?
i.
Picture ii.date/time iii.text iv.number
59.
What
is the maximum length of text field?
i.512
characters ii.50 characters iii. 255 characters iv.No limit
60.
Which
of the following is not field property?
i.
indexed ii. Field size iii.color iv.format
61.
What
field type is used to store picture in a table?
i.memo ii.OLE iii.hyperlink iv.None
62.
Which
of the following uniquely identifies any field.
i.Index ii.Memo iii.Primary key iv.Query
63.
The
object of MS-Access that stores the data is known as
i.Query ii.Table iii.Form iv.report
64.
Which
is the example of Relational Database Management System?
i.Oracle ii.FoxBASE iii.Sybase iv.FoxPro
65.
The
datatype which is used for only integer value.
i.text ii.currency iii.number iv.OLE
66.
What
kind of data are kept in memo field?
i.Name
of Student ii.Students phone number iii.Students Bio data iv.Students picture
67.
Which
of the following is not the datatype of MS-Access?
i.yes/no ii.true/false iii.on/off iv.All
68.
A
field is also known as
i.records ii.column iii.Database iv.entity
69.
Which
of the following field property limits from wrong data entry.
i.Input
mask ii.caption iii.required iv.validation rule
70.
The
default field size value of text field is ___________.
40 50 256 64
71.
Which
component of MS-Access is used to enter data?
Query Forms Report Both (i) and (ii)
72.
__________
is a Database Management System.
DBase MSAV EXCEL All of above
73.
A
column in MS-Access Table is __________
Field Query Database Record
74.
MS-Access
is a
DBMS RDBMS Database Metabase
75.
A
row in a table is known as _____________.
Field Content Record Text table
76.
Which
is the database?
Data of SLC Exam Oracle MS-Access Excel
77.
A
key which uniquely identifies each record of a table is ____________.
Primary key Foreign key Both (i) and (ii) None
of above
78.
Field
size of logical field is __________ in Access.
1 bit 1 byte 8
byte 0 bit
79.
Which
component of MS-Access is used to print data?
Query Form Report None
80.
MS-Access
is used to create _____________.
Database DBMS Record Table
81.
A
caption can have maximum of __________ character.
2062 2048 64000 2006
82.
The
logical data type of Access is __________
Yes/No True/False On/Off All
83.
What
is the extension of Access database?
MBD MDB DBF ADB
84.
Number
field is used for storing only _______________.
Number Text and Number Number
and Time Number and Year
85.
___________
is not DBMS.
Oracle dBase FoxPro Paint
86.
MS-Access
is a kind of ______________.
System Software Operating System Application Software Utility
Software
87.
Which
is an example of database?
DBase MS-Access Telephone
Directory All
88.
Report
is the printed output we generate from _______________.
Table Query Forms Both (i) and (ii)
89.
Which
of them is not a data type?
Memo Yes/No Time/Date Caption
90.
Which
is the subtypes for the number data type?
Hyperlink Bit Index Integer
91.
The
maximum size of the text field is _______________.
253 255 256 254
92.
database
is a
i.tool
of editing documents ii. way
to automate common tasks
ii.
collection of related information
93.
a
collection of records for a single subject,such as all of the customer record
is called
i.Field
ii.Record iii.Table
94.
which
of the following is not a datatype
i. text ii.currency iii.hypertext
95.
…………..
are web pages that allow you to view and work with data that is stored in an
access database on the internet
i.form ii.data access page iii. module
96.
……………
defines a standard pattern for the appearance of all data entered in the field
i.format ii.input mask iii.default value
97.
a
…………. Key is a field that uniquely idectifies each record
i.candidate
ii.alternate iii.primary
98.
A
report is a
i.printed
version of the data in a database ii.way
of sorting and filtering data
iii.
tool that deletes information in your database
99.
The
logical data type of MS-ACCESS is
i. Yes/ NO ii. On/Off iii. True/False iv. All
100.
Which
is the example of database?
i. dBASE ii. MS-ACESS iii. Telephone
directory iv. All
101.
Primary
key does not accept
i. Text ii. Number iii.
Null value iv. None
102.
Which
component of MS-ACCESS does not allow entering data?
i. Table ii. Query iii.
Form iv. None of them
103.
……………
is not the data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
i) Number ii) Text iii) Memo iv) Form
104.
……………
is the DBMS.
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
105.
Primary
key does not accept ……………
i) Text ii) Number iii) Null value iv) None of the above
i) Text ii) Number iii) Null value iv) None of the above
106.
In
MS-Access we enter data using ………….
i) Form ii) Table iii) Report iv) Both (i) &(ii)
i) Form ii) Table iii) Report iv) Both (i) &(ii)
107.
Date/Time
occupies ………. bytes of memory.
i) 4 ii) 2 iii) 8 iv) 16
i) 4 ii) 2 iii) 8 iv) 16
108.
The
extension of database file in MS-Access is……….
i) DBF ii) DBM iii) MDB iv)DMB
i) DBF ii) DBM iii) MDB iv)DMB
109.
The
object of MS-Access that is used to generate hard copy of records.
i) Query ii) Table iii) Form iv) Report
i) Query ii) Table iii) Form iv) Report
110.
A
………….. Key uniquely identifies a record.
i) Primary ii) Foreign iii) Composite iv) None
i) Primary ii) Foreign iii) Composite iv) None
111.
Which
is not a type of query?
i) Search ii) Select iii) Update iv)All of the above
i) Search ii) Select iii) Update iv)All of the above
112.
The
storage size of data and time is :
i) 4 bytes ii)6 bytes iii)8 bytes iv)10 bytes
i) 4 bytes ii)6 bytes iii)8 bytes iv)10 bytes
113.
Collecting multiple related files is called:
i)Records ii)Table iii) Forms iv)Query
i)Records ii)Table iii) Forms iv)Query
114.
The
data type appropriate to store salary is:
i)Memo ii)Currency iii)Text iv) Auto number
i)Memo ii)Currency iii)Text iv) Auto number
115.
……………….
Is not a data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
i) Number ii) Text iii) Memo iv) Form
116.
Primary
key does not accept ……….
i) Text ii) Number iii) Null value iv) None of the above
i) Text ii) Number iii) Null value iv) None of the above
117.
………………..
object of access is used to print formatted data.
i) Query ii) Form iii) Report iv) Table
i) Query ii) Form iii) Report iv) Table
118.
In
MS-Access data are stored in ………………
i) Form ii) Query iii) Table iv) All of the above
i) Form ii) Query iii) Table iv) All of the above
119.
Which
of the following is not a database application?
i) Oracle ii) Foxpro iii) MS-Access iv) MS-Excel
i) Oracle ii) Foxpro iii) MS-Access iv) MS-Excel
120.
Memory
space consumed by a currency data type maximally is …………
i) 2 bytes ii) 4 bytes iii) 8 bytes iv) 1 GB
i) 2 bytes ii) 4 bytes iii) 8 bytes iv) 1 GB
121.
c) The default data type of MS-Access is:
i) Number ii)Text iii) Memo iv) Auto number
i) Number ii)Text iii) Memo iv) Auto number
122.
Row
is also called …………
i) Record ii) Field iii) Database iv) Table
i) Record ii) Field iii) Database iv) Table
123.
The
columns in database tables are called:
i)
Record ii) Field iii) Report iv) Memo
124.
Which
is suitable data type to store video?
i) Text ii) Number iii) Hyperlink iv)
OLE object
125.
Text
data type can store maximum of ___characters
i)
250 ii) 350 iii) 255 iv) 355
126.
Which
of the following is database application?
i)
MS-Word ii) MS-Access iii) MS-Excel iv)
QBASIC
127.
The
maximum size of text field in MS-Access is ………….
i) 50 ii) 10 iii) 6400 iv) 255
i) 50 ii) 10 iii) 6400 iv) 255
128.
The
default data type in MS-Access is ……..
i) Number ii) Date/Time iii) Memo iv) Text
i) Number ii) Date/Time iii) Memo iv) Text
129.
Report
can be generated by using data from …………
i) Table ii) Query iii) Forms iv) Both (i) &(ii)
i) Table ii) Query iii) Forms iv) Both (i) &(ii)
130.
……………..
query changes value in main table.
i) Select ii) Update iii) Both (i) &(ii) iv) None of the above
i) Select ii) Update iii) Both (i) &(ii) iv) None of the above
