MCQ Sets

Now you are at Home » Microsoft Access Online MCQ Quiz » MS Access & DBMS MCQ Questions Set 11

MS Access & DBMS MCQ Questions Set 11

by 5 Comments

MS Access & DBMS MCQ Questions – Welcome to MCQSets! Here we have yet another set of multiple choice questions (MCQ) from Access & DBMS.

Attempt following questions by selecting radio button against correct options and submit your test by clicking on ‘Show Result’.

This Access & DBMS MCQ Questions contains four options each but there is only one correct answer for every question.

Microsoft Access & DBMS MCQ Questions

 

MS Access & DBMS MCQ Questions Set 11

MS Access Multiple Choice Questions

1. What it is called to present information in a particular order based on numeric or alphabetical value?
 
 
 
 
2. The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
 
 
 
 
3. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
 
 
 
 
4. Which control type do you use to create a calculated control?
 
 
 
 
5. What type of relationship is created when you select a primary key in both related tables?
 
 
 
 
6. Microsoft Access is a
 
 
 
 
7. which program do you use to edit code for data access pages?
 
 
 
 
8. When adding an image, which size mode will change the height or width of the image fit the control?
 
 
 
 
9. It is most common type of query. It retrieves records from one or more tables and then displays the
 
 
 
 
10. Which tool do you use to create a query object?
 
 
 
 
11. Which of the following store command to retrieve data from database?
 
 
 
 
12. What is the maximum length a text field can be?
 
 
 
 
13. in MS Access, OLE Object Data type can store
 
 
 
 
14. Which of the following is the file extension for an Extensible Markup Language?
 
 
 
 
15. What does an inner join display?
 
 
 
 
16. The expression builder is an access tool that controls an expression___ for entering an expression
 
 
 
 
17. Database properties do NOT include ___________.
 
 
 
 
18. in a relational schema, each tuple is divided into fields called
 
 
 
 
19. Search engines use a(n) __________ to automatically index sites.
 
 
 
 
20. The basic elements of a form or a report are called:
 
 
 
 

 

We’ve made utmost effort to present error free Multiple Choice Quiz, however, if you encounter any, please report by commenting on following form. Please copy and paste the question where you found any mistake.

If you liked this MS Access & DBMs MCQ Questions set, don’t forget to share it over social network!

Comments

  1. Dear MCQ Sets
    It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
    a. Parameter
    b. Select
    c. Crosstab
    d. Append
    (We can also calculate the sum, average, count from select query. So correct answer should be both Select and cross tab query. Please verify which is correct option and how?)

    Reply

    • Chandra,

      Please look at the essential uses of each of the query types. Cross tab query is primarily used to calculate and restructure data for analyzing.

      Reply

  2. Which is not a command that is selectable from right click menu of a field column?
    a. Hide columns
    b. Unhide columns
    c. freeze columns
    d. sort descending
    ( Option D should be correct answer)

    Reply

  3. Which of the following is not a field type in access

    Memo
    Hyperlink
    Ole object
    Lookup wizard

    i am confuse sir….. Memo
    Hyperlink
    Ole object
    Lookup wizard are all access field type..

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments

Suresh Khanal

Suresh Khanal

Teacher, Blogger. A simple man who believes in sharing. Currently blogging in Bivori that teaches you how to create, promote and monetize blogs.Compiling and presenting MCQ Questions in MCQSets.com. PS Exam can be useful to Computer Science Students and ICT Trends for the candidates of Computer Operator Exam.

View Full Profile →