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. How many relations may exist between tables in databases?
(A) 4
(B) 3
(C) 2
(D) 1
Answer: (B) 3
Q2. Which part of the IIF expression is the action performed if the true condition exists?
(A) Inner
(B) First
(C) Second
(D) Third
Answer: (C) Second
Q3. A(n) _ is dynamic mathematical calculation that displays a single value for a specific field.
(A) Format row
(B) Criteria row
(C) Aggregate function
(D) Format layout
Answer: (C) Aggregate function
Q4. To achieve and effect when you are entering criteria in a query design window
(A) Write criteria values vertically one in a row
(B) Write criteria values horizontally
(C) Write criteria values in same field separated with and
(D) None of these
Answer: (B) Write criteria values horizontally
Q5. Referential integrity means
(A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
(B) Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
(C) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
(D) All of above
Answer: (A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Q6. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
(A) Search query
(B) Cross tab query
(C) Select query
(D) Update query
Answer: (C) Select query
Q7. The three parts of an IIF function are separated by __.
(A) Dashes
(B) Asterisks
(C) Semicolons
(D) Commas
Answer: (D) Commas
Q8. Which is not an option for Filter on a text field?
(A) Begins With
(B) Between
(C) Contains
(D) End With
Answer: (B) Between
Q9. You can set a controls border type to make the border invisible.
(A) Transparent
(B) Invisible
(C) Do not display
(D) No border
Answer: (C) Do not display
Q10. It is a database object to view, change, and analyze data in different ways
(A) Query
(B) Form
(C) Report
(D) None of the above
Answer: (A) Query
Q11. How to make a date field DOB store the dates like “2020/12/31”?
(A) By setting the input mask property to “yyyy/mm/dd”
(B) By setting the format property to “yyyy/mm/dd”
(C) By entering dates in yyyy, mm, dd order
(D) None of the above
Answer: (B) By setting the format property to “yyyy/mm/dd”
Q12. The Allow __ property controls whether new records can be added through the form.
(A) Additions
(B) Edits
(C) Deletions
(D) Data Entry
Answer: (A) Additions
Q13. A __ is a major database object used to display information in an attractive, easy-to-read screen format.
(A) Form
(B) Query
(C) Report
(D) Table
Answer: (A) Form
Q14. It is most common type of query. It retrieves records from one or more tables and then displays the
(A) Parameter
(B) Select
(C) Crosstab
(D) All of above
Answer: (B) Select
Q15. 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
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.