PS Exam

  • Increase font size
  • Default font size
  • Decrease font size

MS-Access : Objective Questions (MCQs) Set 2

Multiple Choice Questions (MCQs) - Multiple Choice Questions - MCQs from MS-Access
E-mail Print PDF

MS-Access Multiple Choice Questoins - Set 2 for objective exam


41. Which command is used for inserting records

a. INSERT
b. ADD
c. Both of above
d. None of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
42. Query is a statement requesting for
a. Insertion of information
b. Deletion of information
c. Update of information
d. Retrieval of information
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
43. The activity of a file
a. Is a low percentages of number of records added or deleted from a file
b. If high, reduces processing efficiency for sequential and non sequential files
c. Is a measure of the percentage of existing records updated during a run
d. Refers to how closely the files fit into the allocated
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
44. Which statement is not valid about indexing?
a. it stores the index fields
b. it stores the corresponding record number
c. it maintains the alphabetically order
d. it duplicate the database file
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
45. Devices that could be used to input data into a database are
a. Keyboard, fax roller ball
b. Mouse, keyboard, monitor
c. Mouse, keyboard, touch screen
d. None of the above
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
46. which command is used for sorting
a. list
b. browse
c. index
d. sort
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
47. List command is used to get
a. List of database contents
b. List of database contents
c. List of variables used in database file
d. None
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
48. A field that uniquely identifies a record is called a
a. Main field
b. Header
c. Key field
d. None of above
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
49. Corrupted index file is corrected using
a. Modifyindex
b. Recreateindex
c. Updateindex
d. Reindex
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
50. the navigation buttons enable you to
a. move from record to record in a table or form
b. move from page to page in report
c. move from object in a database window
d. a and b
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
51. Different levels of access are assigned to personnel records in the hgealth and fitness bym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
a. Password
b. User id’s
c. Status
d. All of above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
52. you can switch back and forth between design and datasheet view by clicking the
a. queries object tab
b. switch command on the view menu
c. view button
d. select query title bar
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
53. The table wizard
a. Quickly creates a default report
b. Displays a subset of the data in a database
c. Contains sample tables and fields you can use to create a table
d. Automatically edits your data as you enter it
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
54. the names, address, and account balance of all of your customers, select the best fit for answer
a. record
b. file
c. database
d. key field
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
55. an integrated collection of all of the data about your customers. Select the best fit for answer
a. Record
b. File
c. Database
d. Key field
Correct Answer: b
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
56. An identification field in a record. Select the best fit for answer
a. Record
b. File
c. Database
d. Key field
Correct Answer: c
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
57. What is part of database that holds all of the information about one item or subject?
a. Record
b. File
c. Query
d. Chart
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
58. What is a stored question about information in a database?
a. Record
b. Field
c. Report
d. Query
Correct Answer: d
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
59. RDBMS stands for
a. Relational Database Management System
b. Relation Data Module System
c. Right Data Base Management System
d. None of the above
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
60. Pack command is used to
a. Remove records permanently
b. Remove records temporarily
c. Restore records permanently
d. Restore records temporarily
Correct Answer: a
Microsoft Access Multiple Choice Questions (MCQs) published on http://www.psexam.com
 
Comments (0)
Write comment
Your Contact Details:
Gravatar enabled
Comment:
<strong> <em> <span style="text-decoration:underline;"> <a target=' /> [quote] [code] <img />   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.
< Prev   Next >
 

Nepal Flights

Nepal Travel Guide and Information on Nepal Hotels, Nepal Flights, Holiday & Car with AceTravels.com: Best Price Guaranteed.

www.acetravels.com

Baba

A personal blog of Baba Pandey - A self taught SEO Expert

www.babapandey.com

Subscribe PS Exam

Wish to get contents in your Email?
Enter your email address:

Delivered by FeedBurner

Who's Online

We have 42 guests online