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. 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
Q2. Which of the following is not a database object in MS Access?
(A) Tables
(B) Query
(C) Report
(D) Relationship
Answer: (D) Relationship
Q3. A summary query can be created by adding which row to the design grid of a select query?
(A) Arguments
(B) Group
(C) Summary
(D) Total
Answer: (D) Total
Q4. This form displays multiple records, one per row, in the form window
(A) Datasheet
(B) Tabular
(C) Columnar
(D) Justified
Answer: (A) Datasheet
Q5. How can you link a table with another so that a field in current table will display values in drop down box from another table while data:
(A) Query Wizard
(B) Look up Wizard
(C) Form Wizard
(D) Report Wizard
Answer: (B) Look up Wizard
Q6. The________ button on the tool box display data from a related table
(A) Sub form sub report
(B) Relationships
(C) Select objects
(D) More controls
Answer: (A) Sub form sub report
Q7. A primary key in any table has the properties
(A) Not Null
(B) No Duplicates
(C) Both of above
(D) None of above
Answer: (C) Both of above
Q8. What does an inner join display?
(A) Records from the second recordset and only records from the first recordset where the common fields are equal
(B) Records from the first recordset and only records from the second recordset where the common fields are equal
(C) Records that have the same value in the common field
(D) Records from the first recordset only
Answer: (C) Records that have the same value in the common field
Q9. In the second sub-form wizard dialog box you specify the table to use as the data source and the
(A) Records from the selected form
(B) Form from the selected table
(C) Fields from the selected table
(D) Content from the selected form
Answer: (C) Fields from the selected table
Q10. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
(A) Text
(B) AutoNumber
(C) Number
(D) Currency
Answer: (A) Text
Q11. Which of the following database object is created first before any other created?
(A) Table
(B) Form
(C) Report
(D) Query
Answer: (A) Table
Q12. A is a unit of information in a
(A) Record, field
(B) Field, record
(C) Data source, field
(D) Record, data source
Answer:(B) Field, record
Q13. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
(A) Datasheet
(B) Justified
(C) Stacked
(D) Tabular
Answer: (D) Tabular
Q14. In relational database schema each tuple is divided into fields known as?
(A) Relations
(B) Queries
(C) Records
(D) Domains
Answer: (D) Domains
Q15. Which do you click to display the table\’s primary key and indexes in a separate window?
(A) Indexes button
(B) Primary key button
(C) View datasheet button
(D) View design button
Answer: (A) Indexes button
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.