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. After right click the field selector button, which do you choose to delete a field in design view?
(A) Delete field
(B) Delete rows
(C) Remove field
(D) Remove rows
Answer: (B) Delete rows
Q2. Which of the following queries prompts users for input data by displaying dialog boxes?
(A) Append
(B) Delete
(C) Parameter
(D) Update
Answer: (C) Parameter
Q3. This database has only one table.
(A) Relational
(B) Large
(C) Flat-file
(D) DBMS
Answer: (C) Flat-file
Q4. To set a password for the database, select __ in the Microsoft Access open window.
(A) Open read only
(B) Open write only
(C) Open explicit
(D) Open exclusive
Answer: (D) Open exclusive
Q5. The task of arranging data in order is called
(A) Searching
(B) Sorting
(C) Ordering
(D) Shorting
Answer:(B) Sorting
Q6. Which control type do you use to create a calculated control?
(A) Command button
(B) Combo box
(C) Text box
(D) List box
Answer: (C) Text box
Q7. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records the second has 8. With using a right outer join, how many records will the resulting recordset have?
(A) 5
(B) 8
(C) 24
(D) Not enough information to tell
Answer: (C) 24
Q8. The __ is used to access one record at a time.
(A) Query
(B) Filter
(C) Form
(D) Report
Answer:(C) Form
Q9. Which of the following query type is best suitable to analyze data?
(A) Cross tab queries
(B) Parameter queries
(C) Action queries
(D) None of above
Answer: (A) Cross tab queries
Q10. Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
(A) Foreign key
(B) Native key
(C) Composite key
(D) Primary key
Answer: (D) Primary key
Q11. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
(A) Datasheet border
(B) Datasheet underline
(C) Column Header underline
(D) Vertical gridline
Answer: (C) Column Header underline
Q12. In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
(A) The join line but not the relationship between the two tables
(B) The relationship between the two tables locally
(C) The relationship between the two tables globally
(D) The primary key of the first table
Answer: (B) The relationship between the two tables locally
Q13. Which of the field has width 8 bytes?
(A) Memo
(B) Number
(C) Date/time
(D) Hyperlink
Answer: (C) Date/time
Q14. What type of control in a form can display data from database table?
(A) Bound control
(B) Unbound control
(C) Both of above
(D) None of above
Answer: (A) Bound control
Q15. HSAM stands for __
(A) Hierarchic Sequential Access Method
(B) Hierarchic Standard Access Method
(C) Hierarchic Sequential and Method
(D) Hierarchic Standard and Method
Answer: (A) Hierarchic Sequential Access Method
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.