Daily IT Quiz Mcq – 13

Dear Aspirants,

Daily IT Quiz is the basic part of the Himachal GK. It is helpful to increase your knowledge based on information technology. It is a series of Himachal Gk MCQs. You can also play our weekly quiz and download all quizzes PDF as well.

1. Which type of relationship is established when multiple students can enroll for one course?
(A) One-to-one
(B) One-to-many
(C) Many-to-many
(D) Many-to-one

2. Which of the following types of relationships enables you to merge two tables for faster access?
(A) One-to-one
(B) Many-to-many
(C) One-to-many
(D) Many-to-one

3. Which of the following specifies a key that is made up of more than one attribute? 
(A) Primary key
(B) Foreign key
(C) Composite key
(D) Alternate key

4. Which of the following keys is an attribute that is a candidate for the primary key but is it not the primary key?
(A) Candidate key
(B) Alternate key
(C) Composite key
(D) Foreign key

5. Which of the following is the result of taking the union of two or more lower-level entity sets to produce a higher-level entity set?
(A) Generalization
(B) Relationship
(C) Specialization
(D) Supertype

6. What is a weak entity in the database?
(A) An entity which exists temporary
(B) An entity which exists for some time
(C) An entity whose existence depends on some other entity
(D) None of these

7. A subtype is a subset of another entity. In what kind of entity set it depends on?
(A) Generalization
(B) Supertype
(C) Specialization
(D) All the above

8. What is the intersect operator builds?
(A) Builds a relation consisting of tuples that appear in the left
(B) Builds a relation consisting of tuples that appear in the right
(C) Builds a relation consisting of tuples that appear the whole
(D) Builds a relation consisting of tuples that appear in both

9. What is the difference operator?
(A) Builds a relation of tuples appearing in the first but not in the second
(B) Builds a relation of tuples appearing in the second not in first
(C) Builds a relation of tuples appearing the whole
(D) Builds a relation of tuples appearing in both

10. In the ER diagram to represent a relationship what symbol is used?
(A) Rectangles
(B) Eclipse
(C) Diamond
(D) All the above