Computer Ms Access For Crpf Radio Operator, Cipher and Radio Fitter Entrance Exams

1. What are the different views to display a table?
A) Datasheet View
B) Design View
C) PivotTable & PivotChart View
D) All of the above

Correct Answer: D) All of the above


2. Which of the following creates a dropdown list of values to choose from?
A) Ole Object
B) Hyperlink
C) Memo
D) Lookup Wizard

Correct Answer: D) Lookup Wizard


3. The command center of Access file that appears when you create or open the MS Access database file is……
A) Database Window
B) Query Window
C) Design View Window
D) Switchboard

Correct Answer: A) Database Window


4. In a database table, the category of information is called……….
A) Tuple
B) Field
C) Record
D) All of the above

Correct Answer: B) Field


5. ……………. uniquely identifies each record.
A) Primary Key
B) Key Record
C) Unique Key
D) Field Name

Correct Answer: A) Primary Key


6. ……….. is an association between two tables having common fields.
A) Line
B) Relationship
C) Primary Key
D) Records

Correct Answer: B) Relationship


7. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
A) Data definition
B) Data refinement
C) Establishing relationship
D) None of the above

Correct Answer: A) Data definition


8. A database language concerned with the definition of the whole database structure and scheme is………
A) DCL
B) DML
C) DDL
D) All of the above

Correct Answer: C) DDL


9. Which of the field has width 8 bytes?
A) Memo
B) Number
C) Date/Time
D) Hyperlink

Correct Answer: C) Date/Time


10. Which of the following statement is true?
A) Foreign key fields don’t allow duplicate values
B) In primary key field, you can enter duplicate value
C) In an indexed field, you may or may not enter duplicate value depending upon setting
D) All statements are true

Correct Answer: C) In an indexed field, you may or may not enter duplicate value depending upon setting


11. Following is not a database model.
A) Network database model
B) Relational database model
C) Object-oriented database model
D) None

Correct Answer: D) None


12. Microsoft Access is a………
A) RDBMS
B) OODBMS
C) ORDBMS
D) Network database model

Correct Answer: A) RDBMS


13. DCL provides commands to perform actions like……….
A) Change the structure of tables
B) Insert, update, or delete records and data values
C) Authorizing access and other control over database
D) None of the above

Correct Answer: C) Authorizing access and other control over database


14. The database language that allows you to access or maintain data in a database is……….
A) DCL
B) DML
C) DDL
D) None of the above

Correct Answer: B) DML


15. What is the maximum length of a text field?
A) 120
B) 255
C) 265
D) 75

Correct Answer: B) 255


16. Which of the following is not a database object?
A) Tables
B) Queries
C) Relationships
D) Reports

Correct Answer: C) Relationships


17. A ………. enables you to view data from a table based on a specific criterion.
A) Form
B) Query
C) Macro
D) Report

Correct Answer: B) Query


18. What are the rows in a Microsoft Access table called?
A) Rows
B) Records
C) Fields
D) Columns

Correct Answer: B) Records


19. Which of the following is not a type of Microsoft Access database object?
A) Table
B) Form
C) Worksheets
D) Modules

Correct Answer: C) Worksheets


20. How many types of objects are available in MS-Access?
A) 4
B) 5
C) 6
D) 2

Correct Answer: C) 6


21. How many primary keys can be added in a table?
A) 1
B) 4
C) 3
D) 6

Correct Answer: A) 1


22. How many types of action queries are available in MS Access?
A) 4
B) 5
C) 3
D) 2

Correct Answer: A) 4


23. .accdb is the extension name of ……………… file.
A) MS Access-2003
B) MS PowerPoint 2007
C) MS-Access 2007
D) MS Excel 2010

Correct Answer: C) MS-Access 2007


24. In a datasheet, what does a column represent?
A) Record
B) Field
C) Database
D) Table

Correct Answer: B) Field


25. What do you call a primary key field included in another table?
A) Foreign key
B) Parent key
C) Child key
D) Index

Correct Answer: A) Foreign key


26. Which type of field is incremented automatically?
A) Auto Elevate
B) AutoNumber
C) Auto Increment
D) Auto Value

Correct Answer: B) AutoNumber


27. Queries in Access can be used as…….
A) View, change, and analyze data in different ways
B) A source of records for forms and reports
C) Only a filter
D) Both A & B

Correct Answer: D) Both A & B


28. It is the most common type of query. It retrieves records from one or more tables and then displays records.
A) Parameter
B) Select
C) Crosstab
D) All of the above

Correct Answer: B) Select


29. This data type allows alphanumeric characters and special symbols.
A) Text
B) Memo
C) AutoNumber
D) None of the above

Correct Answer: A) Text


30. A ……… enables you to view data from a table based on a specific criterion.
A) Form
B) Query
C) Macro
D) Report

Correct Answer: B) Query

Leave a Comment