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. What is the purpose of indexing?
(A) To reduce table size
(B) To speedup data search
(C) Both A and B
(D) None of the above
Answer: (B) To speedup data search
Q2. The __ function returns a string that has been converted to uppercase text.
(A) AllCap
(B) UCase
(C) UpCase
(D) Upper
Answer: (B) UCase
Q3. In Datasheet View, new records are added to a table _.
(A) In alphabetical order
(B) At the end of the table
(C) At the beginning of the table
(D) In numerical order
Answer: (B) At the end of the table
Q4. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
(A) Columnar
(B) Justified
(C) Datasheet
(D) Tabular
Answer: (D) Tabular
Q5. 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
Q6. What do you call a collection of records matching parameters of a query?
(A) Field
(B) Record
(C) Query
(D) Dynaset
Answer: (D) Dynaset
Q7. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
(A) txt
(B) txb
(C) tbc
(D) tex
Answer: (A) txt
Q8. A(n) __ in the Record Selector indicates a new record.
(A) Check mark
(B) Pencil
(C) Asterisk
(D) Arrow
Answer: (C) Asterisk
Q9. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
(A) Crosstab
(B) Columnar
(C) Select
(D) Action
Answer: (A) Crosstab
Q10. Which of the following statement is true?
(A) Reports can be used to retrieve data from tables and calculate
(B) Queries can be printed in well formatted manner and presented as the information
(C) Queries can include calculated fields that do not exist in table
(D) Reports and forms are similar but forms are use to print but reports to display on screen only
Answer: (C) Queries can include calculated fields that do not exist in table
Q11. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
(A) Display all customers with CustID from 10 to 100
(B) Display all customers with CustID above 10
(C) Display all customers with CustID below 100
(D) Display all customers with CustID from 11 to 99
Answer:(D) Display all customers with CustID from 11 to 99
Q12. The __ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
(A) MSN Money
(B) Portfolio
(C) Financial
(D) Stock
Answer: (C) Financial
Q13. The ability of a database to grow as the data tracking needs grow is its _.
(A) Scalability
(B) Expandability
(C) Maintainability
(D) Platform-independence
Answer: (A) Scalability
Q14. The result of a query is displayed in a
(A) Record
(B) Query datasheet
(C) Query table
(D) Form
Answer: (B) Query datasheet
Q15. DCL provides commands to perform actions like
(A) Change the structure of tables
(B) Insert, update or delete records and data values
(C) Authorizing access and other control over database
(D) None of above
Answer:(C) Authorizing access and other control over database
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.