Are you guys looking for Computer science Engineering MCQ Questions with Answers PDF Free Download as per Computer science Engineering 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 Engineering. Each question has four options followed by the right answer. These Computer science Engineering MCQ Questions are selected supported by the newest exam pattern.
Q1. The way a particular application views the data from the database that the application uses is a
(A) Module
(B) Relational model
(C) Schema
(D) Subschema
Answer:(D) Subschema
Q2. What does the expression [detail] ! [product] * 1.30 do?
(A) Multiplies the contents of detail and product fields by 1.3
(B) First divides detail by product and then multiplies by 1.3
(C) Multiplies the contents of detail in the product table by 1.3
(D) Multiplies the contents of product in the detail table by 1.3
Answer:(D) Multiplies the contents of product in the detail table by 1.3
Q3. We can remove a relationship defined between two tables by
(A) From edit menu choose delete relationship
(B) Select the relationship line and press delete
(C) Choose delete option from relationship menu
(D) All of above
Answer: (B) Select the relationship line and press delete
Q4. Collection of related records in a database is known as
(A) File
(B) Bench
(C) Table
(D) Relationship
Answer: (C) Table
Q5. The________ operator will cause a record to be selected only if two or more conditions are satisfied
(A) Or
(B) If or
(C) Range
(D) And
Answer: (D) And
Q6. Which of the following is not a type of Microsoft Access database object?
(A) Queries
(B) Workbooks
(C) Forms
(D) Tables
Answer: (B) Workbooks
Q7. Which is not a view for displaying a report object?
(A) Datasheet view
(B) Design view
(C) Print preview
(D) Layout preview
Answer: (A) Datasheet view
Q8. It is a query that when run displays its own dialog box prompting you for information, such as
(A) Select
(B) Crosstab
(C) Parameter
(D) Append
Answer: (C) Parameter
Q9. Which object is used to create a form?
(A) Tables and Queries
(B) Tables only
(C) Tables and reports
(D) Queries and reports
Answer: (A) Tables and Queries
Q10. In one-to-many relationship the table in ‘one’ side is called and on ‘many’ side is called __
(A) Child, Parent
(B) Parent, Child
(C) Brother, Sister
(D) Father, Son
Answer: (B) Parent, Child
Q11. How do you update pivot table report data after changes are made to the source data?
(A) Save your changes, close the workbook, and then reopen it
(B) Select the pivot table worksheet and press f9 on the keyboard
(C) Click the report, and on the pivot table toolbar, click the refresh data button
(D) All of the above
Answer: (C) Click the report, and on the pivot table toolbar, click the refresh data button
Q12. In MS Access, AutoNumber Data Type
(A) Can be Sequential
(B) Can be Random
(C) Can be Edited
(D) Only A & B
Answer: (D) Only A & B
Q13. Which of the following is not a form style available in the form wizard dialog box?
(A) Blends
(B) Standard
(C) Stone
(D) Highlights
Answer: (D) Highlights
Q14. Which query do you use to answer the question “What is the average salary of the employees”?
(A) Search query
(B) Cross tab query
(C) Select query
(D) Update query
Answer: (C) Select query
Q15. To create queries in Access
(A) You can drag and drop fields on query builders
(B) You can type the SQL command in SQL view
(C) You can use query wizard or design view
(D) All of above
Answer: (D) All of above
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.