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. In an Entity-Relationship Diagram “Ellipses” represents
(A) Attributes
(B) Weak entity set
(C) Relationship sets
(D) Multi-valued Attributes
Answer:(A) Attributes
Q2. In a _ a parent record type can be linked to one or more “child” record types, but a child record type can have only one parent.
(A) Network database
(B) Relational database
(C) Distributed database
(D) Hierarchical database
Answer: (D) Hierarchical database
Q3. _ allow us to identify uniquely a tuple in the relation.
(A) Superkey
(B) Domain
(C) Attribute
(D) Schema
Answer: (A) Superkey
Q4. Large collections of files are called
(A) Fields
(B) Records
(C) Databases
(D) File system
Answer: (C) Databases
Q5. Information can be transferred between the DBMS and a
(A) Spreadsheet program
(B) Word processor program
(C) Graphics program
(D) All of the above
Answer: (D) All of the above
Q6. Which of the following is an unary operation?
(A) Selection operation
(B) Generalized selection
(C) Primitive operation
(D) Projection operation
Answer: (B) Generalized selection
Q7. In mathematical term Row is referred as
(A) Relation
(B) Attribute
(C) Tuple
(D) Domain
Answer: (C) Tuple
Q8. If every non-key attribute is functionally dependent on the primary key, the relation will be in
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Fourth Formal Form
Answer: (C) Third Normal Form
Q9. When performing a look-up operation using a form
(A) You enter the search value into the form
(B) You look at each form sequentially until you see the one you want
(C) You type the key in an entry line, and the correct form is displayed
(D) All of the above
Answer: (A) You enter the search value into the form
Q10. In SQL, which command(s) is(are) used to enable/disable a database trigger?
(A) Modify User
(B) Change User
(C) Alter Trigger
(D) None of the above
Answer: (C) Alter Trigger
Q11. A table that displays data redundancies yields _ anomalies
(A) Insertion
(B) Deletion
(C) Update
(D) All of the above
Answer: (D) All of the above
Q12. Which of the following is not Unary operation?
(A) Select
(B) Project
(C) Rename
(D) Union
Answer: (D) Union
Q13. A logical description of some portion of database that is required by a user to perform task is called as
(A) System View
(B) User View
(C) Logical View
(D) Data View
Answer: (B) User View
Q14. A network schema
(A) Restricts the structure to a one-to-many relationship
(B) Permits many-to-many relation-ships
(C) Stores data in tables
(D) All of the above
Answer: (B) Permits many-to-many relation-ships
Q15. Which of the following is a type of DBMS software?
(A) Database manipulation language
(B) Query language
(C) Utilities
(D) Report writer
Answer: (A) Database manipulation language
Database Management System MCQ – All Set
We hope the given computer science Engineering on Database Management System MCQ Questions with Answers will definitely yield fruitful results. Hope you got enough ideas on the MCQs on Database Management System. If you have any queries related to computer science Engineering on Database Management System MCQs Multiple Choice Questions with Answers, drop your questions below and will get back to you as soon as possible.