# dbms MBA Quiz# dbms quiz # Relational Database Quiz# questions with answers dbms quiz #Database Schema quiz #basic dbms mcqs //SANJAY SIR//

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

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

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

     

आप हमारे व्हाट्सएप पर जुड़ने के लिए इस

  लिंक👉       https://chat.whatsapp.com/HSSdTk22q3m10GbCzW4ECV

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

joinhttps://t.me/joinchat/SsML9EY2fVoyODg1

 

 

1. A relational database consists of a collection of

A) Tables
B) Fields
C) Records
D) Keys

ANSWER= (A) Tables
Explain:- Fields are the column of the relation or tables. Records are each row in a relation. Keys are the constraints in a relation.

 

2. A ________ in a table represents a relationship among a set of values.

A) Column
B)Key
C) Row
D) Entry

ANSWER= (C) Row
Explain:- Column has only one set of values. Keys are constraints and row is one whole set of attributes. Entry is just a piece of data.

 

3. The term _______ is used to refer to a row.

A) Attribute
B) Tuple
C) Field
D) Instance

ANSWER= (B)Tuple
Explain:- Tuple is one entry of the relation with several attributes which are fields.

 

4. The term attribute refers to a ___________ of a table.

A) Record
B)Column
C) Tuple
D) Key

ANSWER= (B)Column
Explain:- Attribute is a specific domain in the relation which has entries of all tuples..

 

5. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute..

A) Domain
B)Relation
C) Set
D) Schema

ANSWER= (A)Domain
Explain:- The values of the attribute should be present in the domain. Domain is a set of values permitted.

 

6. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

A) Instance, Schema
B)Relation, Schema
C) Relation, Domain
D) Schema, Instance

ANSWER= (D)Schema, Instance
Explain:- Instance is an instance of time and schema is a representation.

 

7. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________.

A)Relations, Attribute
B) Attributes, Relation
C) Tuple, Relation
D) Tuple, Attributes

ANSWER= (B)Attributes, Relation
Explain:- The relation course has a set of attributes course_id,sec_id,semester .

 

8. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

A) Attributes of common
B) Tuple of common
C) Tuple of distinct
D) Attributes of distinct

ANSWER= (C)Tuple of distinct
Explain:- Here the relations are connected by the common attributes.

 

9. A domain is atomic if elements of the domain are considered to be ____________ units.

A) Different
B) Indivisbile
C) Constant
D) Divisible

ANSWER= (B) indivisbli
Explain:- None

 

10. The tuples of the relations can be of ________ order.

A) Any
B) Same
C) Sorted
D) Constant

ANSWER= (A) Any
Explain:- The values only count. The order of the tuples does not matter.