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. Both conditions display on the same row in the design grid when ________operator is in use
(A) OR
(B) IN
(C) AND
(D) LIKE
Answer: (C) AND
Q2. Which of the following is the DBMS type?
(A) Flat File System
(B) Hierarchical DBMS
(C) Relational DMBS
(D) All of the Above
Answer: (D) All of the Above
Q3. Using the keyword _ will return records in which the field value equals a defined text.
(A) Between
(B) Is Null
(C) Like
(D) Not
Answer: (C) Like
Q4. Cascade update option
(A) Means do not change the value in the primary key field if that record has related records in another table
(B) Means change all the related records in child tables if the record in parent table is changed
(C) Both of above
(D) None of above
Answer: (C) Both of above
Q5. 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
Answer: (A) Data definition
Q6. A database can be best described as
(A) Organized collection of data
(B) Useful presentation of data
(C) Graphical representation of data
(D) All of above
Answer: (A) Organized collection of data
Q7. Macros can recover from _ in a controlled manner.
(A) Events
(B) Modules
(C) Arguments
(D) Errors
Answer: (A) Events
Q8. Referential integrity can be enforced if both _ belong to the same Microsoft Access database.
(A) Queries
(B) Fields
(C) Records
(D) Tables
Answer: (D) Tables
Q9. You can automatically include all of the field in a table in a query by________ a strike that appear list box in query design view
(A) Clicking
(B) Right clicking
(C) Double clicking
(D) None of the above
Answer: (C) Double clicking
Q10. When creating a new table which method can be used to choose fields from standard databases and tables?
(A) Create table in Design View
(B) Create Table using wizard
(C) Create Table by Entering data
(D) None of above
Answer: (B) Create Table using wizard
Q11. Database Management Systems are featured with:
(A) The facility to easy editing, spelling check, auto pagination, lay out and printing reports
(B) The ability to store large amount of data to facilitate easy update, sort and retrieval
(C) The ability to calculate efficiently with the help of built-in functions and analyze
(D) All of above
Answer: (B) The ability to store large amount of data to facilitate easy update, sort and retrieval
Q12. To assign a macro to an event, users need to open the form in Design View.
(A) Event
(B) Property
(C) Title
(D) Macro
Answer: (A) Event
Q13. Which of the following field properties enforces the use of parentheses when keying an area code?
(A) Field Size
(B) Format
(C) Input Mask
(D) Validation Rule
Answer:(C) Input Mask
Q14. The key uniquely identifies each record in a table.
(A) Primary key
(B) Key word
(C) Filed name
(D) All of above
Answer: (A) Primary key
Q15. What does the show check box in query design window indicate?
(A) It indicates whether the field is to be used or not
(B) It indicates whether the field is to be displayed in query result or not
(C) It indicates whether the field names to be displayed in query result or not
(D) None of above
Answer:(B) It indicates whether the field is to be displayed in query result or not
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.