#dbms quiz #geeksforgeeks dbms quiz# questions with answers dbms quiz #tutorialspoint dbms quiz #sanfoundry dbms quiz #basic dbms mcqs //SANJAY SIR//

 हम सभी लोग  जानते हैं कि इस टाइम पर ऑनलाइन परीक्षा बहुत कठिन परीक्षाओं में से एक है, इसलिए हम आप लोगो के लिये DBMS की बेहतर क्विज लेकर  आये है , जो कि  बहुत महत्वपूर्ण है।  यदि आप उस समय अधिक स्कोर प्राप्त करना चाहते हैं तो आपको D.B.M.S.  क्विज का डेली   प्रयास करना होता है | 

 || चलिये अब हम चलते है अपनी क्विज पर || 

                          आओ स्टार्ट करें  क्वेश्चनों की कहानी | 
                                        जो आप को बनायेगी सबसे अलग | | 

 आप हमारे व्हाट्सएप पर जुड़ने के लिए इस लिंक👉https://chat.whatsapp.com/HSSdTk22q3m10GbCzW4ECV

हमारे टेलिग्राम पर जाने के लिए क्लिक करें👉

joinhttps://t.me/joinchat/SsML9EY2fVoyODg1

 

1. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

A) Name
B) ID
C) City
D) City,ID

ANSWER= (B) ID
Explain:- Here the id is the only attribute which can be taken as a key. Other attributes are not uniquely identified.

 

2. The subset of a super key is a candidate key under what condition?

A) No proper subset is a super key
B) All subsets are super keys
C) Subset is a super key
D) Each subset is a super key

ANSWER= (A) No proper subset is a super key
Explain:- The subset of a set cannot be the same set. Candidate key is a set from a super key which cannot be the whole of the super set..

 

3. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A) Rows
B) Key
C) Attribute
D) Fields

ANSWER= (B) key
Explain:- Key is the constraint which specifies uniqueness.

 

4. Which one of the following attribute can be taken as a primary key?

A) Name
B) Street
C) Id
D) Department

ANSWER= (C) Id
Explain:- The attributes name, street and department can repeat for some tuples. But the id attribute has to be unique. So it forms a primary key.

 

5. Which one of the following cannot be taken as a primary key?

A) Id
B) Register Number
C) Dept_id
D) Street

ANSWER= (D) Street
Explain:- Street is the only attribute which can occur more than once.

 

6. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

A) Candidate key
B) Sub key
C) Super key
D)Foreign key

ANSWER= (C) Super key
Explain:- Super key is the superset of all the keys in a relation.

 

7. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

A) Candidate
B) Primary
C) Super
D)Sub

ANSWER= (B) Primary
Explain:- The primary key has to be referred in the other relation to form a foreign key in that relation.

 

8. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________

A) Referential relation
B) Referencing relation
C) Referenced relation
D)Referred relation

ANSWER= (C) Referenced relation
Explain:- None

 

9. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

A) Referential relation
B) Referencing relation
C) Referenced relation
D)Referred relation

ANSWER= (C) Referenced relation
Explain:- None

10. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

A) Referential
B) Referencing
C) Specific
D) Primary

ANSWER= (A) Referential
Explain:- A relation, say r1, may include among its attributes the primary key of another relation, say r2. This attribute is called a foreign key from r1, referencing r2. The relation r1 is also called the referencing relation of the foreign key dependency, and r2 is called the referenced relation of the foreign key.