MS Access And DBMS MCQ Questions Set 16

MS Access MCQ Collection – Welcome to MCQSets. Here we present the next set of multiple choice questions from Microsoft Access and Database Management System (DBMS)

Answer following questions by selecting correct answer among given four options and submit your test by clicking on ‘Show Result’. Correct answers will be marked with green tick mark and wrong ones with red cross.

Multiple Choice Questions from MS Access & DBMS

MS Access Multiple Choice Questions

Enter email to receive quiz results:

1. Which of the following is a method to create a new table in MS Access?

 Create table in Design View

 Create Table using wizard

 Create Table by Entering data

 All of above

2. The most popular commercial DBMS.

 Microsoft SQL Server

 Microsoft Access

 MySQL

 Oracle

3. According to access help, what?s a good way to design a database?

 Start from data access pages and work backward

 Sketch the design of your database using a pencil and paper

 Use the table analyzer to reverse-engineer your flat source data.

 None of above

4. in a relational schema, each tuple is divided into fields called

 Relations

 Domains

 Queries

 All of the above

5. Which of the following is not a view for interacting with a form object?

 Datasheet view

 Design view

 Form view

 Layout view

6. In access, this displays the results of a calculation in a query

 Lookup field

 Calculated field

 Source field

 Child field

7. In relational database schema each tuple is divided into fields known as?

 Relations

 Queries

 Records

 Domains

8. The common field linking the two datasheets is the ___ key field in the main datasheet and the ___ key field in the linked datasheet.

 primary, foreign

 primary, common

 foreign, primary

 foreign, common

9. When entering field name, how many characters you can type in maximum?

 60

 64

 68

 Any number of character

10. the executive responsible for the data processing function in an organization is

 Pm

 Dbms

 Dp

 Dpm

11. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

 Press [Ctrl]+[C] and [Ctrl]+[V].

 Right-click, choose from the shortcut menu Copy and Paste.

 Press [Ctrl]+[+] and [Ctrl]+[-].

 From the ribbon, select Copy and Paste.

12. The size of Yes No field is always

 1 bit

 1 byte

 1 character

 1 GB

13. In one-to-many relationship the table in ?one? side is called _______ and on ?many? side is called _______

 Child , Parent

 Parent , Child

 Brother , Sister

 Father , Son

14. Microsoft Access is a

 RDBMS

 OODBMS

 ORDBMS

 Network database model

15. The default and maximum size of text field in access

 50 and 255 characters

 8 and 1 gb

 266 characters & 64000 characters

 None of above

16. The arranging of data in a logical sequence is called

 Sorting

 Classifying

 Reproducing

 Summarizing

17. the complete picture of data stored in database is known as

 Record

 Scheme

 System flowchart

 Dbms

18. What is the keyboard shortcut to move to the last records in a table?

 [Tab]

 [Shift]+[Tab]

 [Ctrl]+Home]

 [Ctrl]+[End]

19. The ability of a database to grow as the data tracking needs grow is its __________.

 scalability

 expandability

 maintainability

 platform-independence

20. What do you call a collection of records matching parameters of a query?

 Field

 Record

 Query

 Dynaset

 Loading…