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. both (b) and (c) Ans. D
DBMS
A command that lets you change one or more fields in a record is
A. Look-up B. Insert C. Modify D. None of these Ans. C
DBMS
A table consists of
A. Rows and cells B. Rows and columns C. Fields and columns D. Fields and columns Ans. B
DBMS
Which language is used by most of DBMSs for helping their users to access data?
A. HLL B. Query language C. SQL D. 4 GL Ans. B
DBMS
Which of the following is at the highest level in the hierarchy of data organization?
A. Database B. Data bank C. Data file D. Data record Ans. A
DBMS
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. none of these Ans. A
DBMS
An entry in the telephone book can be compared to a
A. Field B. Record C. File D. Database Ans. B
DBMS
A file consists of
A. Fields and records B. Records and sorts C. Fields and sorts D. Databases and fields Ans. A
DBMS
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. 299 characters and 6499 characters Ans. A
DBMS
Open the Save As dialog box
A. F1 B. F2 C. F10 D. F12 Ans. D
DBMS
Which tool do you use to create a query object?
A. Table query wizard B. Simple query wizard C. Simple filer wizard D. Database wizard Ans. B
DBMS
In Access, ____ are used to store the data.
A. Report B. Form C. Table D. Query Ans. C
DBMS
What is the maximum length a text field can be?
A. 75 B. 120 C. 255 D. 265 Ans. C
DBMS
A _____ is an area reserved for a specific piece of data.
A. Report B. Key C. Record D. Field Ans. D
DBMS
____ is not a valid data type in MS Access.
A. Auto number B. Currency C. Memo D. Picture Ans. D
DBMS
Press _____ to quit MS Access.
A. Tab +F4 B. Esc+ W C. Ctrl +F4 D. Alt+F4 Ans. D
DBMS
A subset of characters within a data field is known as
A. Byte B. File C. Record D. Data string Ans. D
DBMS
Which of the following is not a type of Microsoft access database object?
A. Macros B. Modules C. Worksheets D. Table Ans. C
DBMS
Microsoft Access is a _____
A. Network Database Model B. RDBMS C. ORDBMS D. OODBMS Ans. B
DBMS
Which of the following option creates a Drop Down List of values ?
A. Ole Object B. Hyperlink C. Memo D. Lookup Wizard Ans. D
DBMS
what can be the maximum length of a text field ?
A. 120 B. 255 C. 265 D. 75 Ans. B
DBMS
The size of yes/no field is always ________
A. 1 Bit B. 1 Byte C. 1 Character D. 1 KB Ans. A
DBMS
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. All of Above Ans. C
DBMS
Which of the following is not a type of MS Access database object?
A. Table B. Form C. Worksheets D. Modules Ans. C
DBMS
Which field type will you select if you need to enter long text in that field?
