Sterliate Educations 673-A, Second Floor, Gali No.-7, Govindpuri, Kalkaji,, New Delhi 110019 Bharat MS-Access
Question : 25	Duration : 25 Minutes

1	A database management system
A: is a collection of programs for managing data in a single file
B: can do more than a record management system
C: allows simultaneous access to multiple file
D: is a collection of programs for managing data in a single file
Answer: D

2	A command that lets you change one or more fields in a record is
A: Look-up
B: Insert
C: Modify
D: Look-up
Answer: C

3	A table consists of
A: Rows and cells
B: Rows and columns
C: Fields and columns
D: Rows and cells
Answer: B

4	Which language is used by most of DBMSs for helping their users to access data?
A: HLL
B: Query language
C: SQL
D: HLL
Answer: B

5	Which of the following is at the highest level in the hierarchy of data organization?
A: Database
B: Data bank
C: Data file
D: Database
Answer: A

6	In a database, a network structure
A: allows many-to-many relationship
B: is a physical representation of the data
C: allows only one-to-one relationship
D: allows many-to-many relationship
Answer: A

7	An entry in the telephone book can be compared to a
A: Field
B: Record
C: File
D: Field
Answer: B

8	A file consists of
A: Fields and records
B: Records and sorts
C: Fields and sorts
D: Fields and records
Answer: A

9	The default and maximum size of text field in access
A: 50 and 255 characters
B: 266 characters and 6400 characters
C: 288 characters and 6880 characters
D: 50 and 255 characters
Answer: A

10	Open the Save As dialog box
A: F1
B: F2
C: F10
D: F1
Answer: D

11	Which tool do you use to create a query object?
A: Table query wizard
B: Simple query wizard
C: Simple filer wizard
D: Table query wizard
Answer: B

12	In Access, ____ are used to store the data.
A: Report
B: Form
C: Table
D: Report
Answer: C

13	What is the maximum length a text field can be?
A: 75
B: 120
C: 255
D: 75
Answer: C

14	A _____ is an area reserved for a specific piece of data.
A: Report
B: Key
C: Record
D: Report
Answer: D

15	____ is not a valid data type in MS Access.
A: Auto number
B: Currency
C: Memo
D: Auto number
Answer: D

16	Press _____ to quit MS Access.
A: Tab +F4
B: Esc+ W
C: Ctrl +F4
D: Tab +F4
Answer: D

17	A subset of characters within a data field is known as
A: Byte
B: File
C: Record
D: Byte
Answer: D

18	Which of the following is not a type of Microsoft access database object?
A: Macros
B: Modules
C: Worksheets
D: Macros
Answer: C

19	Microsoft Access is a _____
A: Network Database Model
B: RDBMS
C: ORDBMS
D: Network Database Model
Answer: B

20	Which of the following option creates a Drop Down List of values ?
A: Ole Object
B: Hyperlink
C: Memo
D: Ole Object
Answer: D

21	what can be the maximum length of a text field ?
A: 120
B: 255
C: 265
D: 120
Answer: B

22	The size of yes/no field is always ________
A: 1 Bit
B: 1 Byte
C: 1 Character
D: 1 Bit
Answer: A

23	In which method we don't need to specify the field type and size while creating a new Table?
A: Design View
B: While using Wizard
C: CreateTable By Entering Data
D: Design View
Answer: C

24	Which of the following is not a type of MS Access database object?
A: Table
B: Form
C: Worksheets
D: Table
Answer: C

25	Which field type will you select if you need to enter long text in that field?
A: Text
B: Memo
C: Currency
D: Text
Answer: B