Are you guys looking for computer science MCQ Questions with Answers PDF Free Download as per computer science new exam pattern? You came to the right page. This may assist you to understand and check your knowledge about the Subjects. Students also can take a free test of the Multiple Choice Questions of computer science. Each question has four options followed by the right answer. These computer science MCQ Questions are selected supported by the newest exam pattern.
Q1. A database object in MS Access that stores a question about the data in database?
(A) Table
(B) Form
(C) Query
(D) Report
Answer: (C) Query
Q2. In MS Access, Field Value may contain
(A) Text
(B) Date & Time
(C) Picture
(D) All of the Above
Answer: (D) All of the Above
Q3. Which of the following statements about tab order setting is NOT true?
(A) The actual tab order setting for a form can be used in the Form View
(B) The tab order setting determines the movement of the insertion point through a form
(C) The tab order setting is usually right-to-left and top-to-bottom
(D) The default tab order setting can be altered by moving the controls in the Design View
Answer:(C) The tab order setting is usually right-to-left and top-to-bottom
Q4. Following is not a database model
(A) Network database model
(B) Relational database model
(C) Object oriented database model
(D) None
Answer: (D) None
Q5: The size of Yes No field is always
(A) 1 bit
(B) 1 byte
(C) 1 character
(D) 1 GB
Answer: (A) 1 bit
Q6. Which of the following expresses correct order?
(A) Characters, Fields, Records, Tables, Files, Databases
(B) Characters, Fields, Records, Tables, Database, Files
(C) Databases, Tables, Files, Records, Field, Character
(D) Files, Databases, Tables, Records, Fields, Characters
Answer: (A) Characters, Fields, Records, Tables, Files, Databases
Q7. What is the use of Cascade Delete Option in MS Access?
(A) It makes sure that all the records from the parent table and child table is deleted from selected database
(B) It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
(C) It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
(D) None of above
Answer: (B) It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
Q8. Which mode sizes an image to fit the control while maintaining the proportions of the original image?
(A) Clip
(B) Fit
(C) Stretch
(D) Zoom
Answer: (D) Zoom
Q9. Which of the following is not a database object?
(A) Tables
(B) Queries
(C) Relationships
(D) Reports
Answer: (C) Relationships
Q10. How can you define a field so that when entering data for that field it will display instead of actual typed text
(A) Input mask
(B) Validation Rule
(C) Indexed
(D) IME Mode
Answer: (A) Input mask
Q11. To create primary key for a table when in design view
(A) Type PRIMARY in field type box when creating required field
(B) Mark the Primary check box in field name of required field
(C) Click the Primary Key button in Design ribbon when the cursor is in required field
(D) None of the above
Answer: (C) Click the Primary Key button in Design ribbon when the cursor is in required field
Q12. By default, what is the name of a new module in the Modules folder of the Project pane called?
(A) Bas1
(B) Module
(C) New Module
(D) Module1
Answer: (D) Module1
Q13. Referential integrity cannot be set for _ relationships.
(A) One-To-One
(B) Indeterminate
(C) One-To-Many
(D) Many-To-Many
Answer: (B) Indeterminate
Q14. What is the difference between ‘open’ and ‘open exclusively’
(A) Open statement opens access database files and open exclusively opens database files of other program like oracle
(B) Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
(C) Both open and open exclusively are same
(D) Open exclusive command does not exist in MS Access
Answer: (B) Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
Q15. Which field type will you select when creating a new table if you require to enter long text in that field?
(A) Text
(B) Memo
(C) Currency
(D) Hyperlink
Answer: (B) Memo
Microsoft Access MCQ – All Set
We hope the given computer science Engineering on Microsoft Access MCQ Questions with Answers will definitely yield fruitful results. Hope you got enough ideas on the MCQs on Microsoft Access. If you have any queries related to computer science Engineering on Microsoft Access MCQs Multiple Choice Questions with Answers, drop your questions below and will get back to you as soon as possible.