[ Database ]

झारखंड में आयोजित होने वाली JPSC, JSSC, JET, झारखंड पुलिस भर्ती परीक्षा आदि के लिए उपयोगी सामान्य अध्ययन।

[ Database ]

Useful GK for JPSC, JSSC, JET, Jharkhand Police and other exams.

1. DBMS क्या होता है?

[A] Database Management Software

[B] Database Modeling System

[C] Database Management System

[D] Database Model Software

1. What does DBMS stand for?

[A] Database Management Software

[B] Database Modeling System

[C] Database Management System

[D] Database Model Software

सही उत्तर: Database Management System

व्याख्या: DBMS का सही अर्थ Database Management System है

Correct Answer: Database Management System

Explanation: Correct expansion of DBMS

2. DBMS मॉडल का कौन सा प्रकार है?

[A] Relational

[B] Network

[C] Hierarchical

[D] सभी उपरोक्त

2. Relational

[A] Network

[B] Hierarchical

[C] All of the above

[D] All of the above

सही उत्तर: सभी उपरोक्त

व्याख्या: सभी DBMS मॉडल प्रकार सही हैं

Correct Answer: All models are valid DBMS types

Explanation: 2026-05-27 15:54:08

3. DBMS का कौन सा component नहीं है?

[A] Query Processor

[B] Database Engine

[C] Database Table

[D] Indexing Engine

3. Query Processor

[A] Database Engine

[B] Database Table

[C] Indexing Engine

[D] Database Table

सही उत्तर: Database Table

व्याख्या: Database Table DBMS component नहीं है

Correct Answer: Table is not a DBMS internal component

Explanation: 2026-05-27 15:54:31

4. DBMS में database organize करने के लिए क्या use होता है?

[A] Table

[B] Views

[C] Query

[D] All of the above

4. Table

[A] Views

[B] Query

[C] All of the above

[D] All of the above

सही उत्तर: All of the above

व्याख्या: सभी का उपयोग होता है

Correct Answer: All are used in DBMS organization

Explanation: 2026-05-27 15:54:48

5. Tree structure वाला model कौन सा है?

[A] Relational Model

[B] Network Model

[C] Hierarchical Model

[D] Object Oriented Model

5. Relational Model

[A] Network Model

[B] Hierarchical Model

[C] Object Oriented Model

[D] Hierarchical Model

सही उत्तर: Hierarchical Model

व्याख्या: Hierarchical model tree structure use करता है

Correct Answer: Hierarchical model uses tree structure

Explanation: 2026-05-27 15:55:07

6. SQL में data retrieve करने के लिए कौन सा command use होता है?

[A] SELECT

[B] INSERT

[C] UPDATE

[D] DELETE

6. SELECT

[A] INSERT

[B] UPDATE

[C] DELETE

[D] SELECT

सही उत्तर: SELECT

व्याख्या: SELECT data fetch करता है

Correct Answer: SELECT is used to retrieve data

Explanation: 2026-05-27 15:55:23

7. Normalization का मुख्य उद्देश्य क्या है?

[A] Redundancy avoid करना

[B] Performance बढ़ाना

[C] Query time reduce करना

[D] All of the above

7. Avoiding redundancy

[A] Increasing performance

[B] Reducing query time

[C] All of the above

[D] Avoiding redundancy

सही उत्तर: Redundancy avoid करना

व्याख्या: Normalization redundancy कम करता है

Correct Answer: Normalization reduces redundancy

Explanation: 2026-05-27 15:55:36

8. Primary key का उपयोग क्या है?

[A] Record uniquely identify करना

[B] Relation बनाना

[C] Duplicate रोकना

[D] All of the above

8. Uniquely identify a record

[A] Enforce relationships

[B] Prevent duplication

[C] All of the above

[D] All of the above

सही उत्तर: All of the above

व्याख्या: Primary key सभी काम करता है

Correct Answer: Primary key ensures uniqueness and integrity

Explanation: 2026-05-27 15:55:49

9. NOT a relationship type कौन सा है?

[A] One-to-One

[B] One-to-Many

[C] Many-to-Many

[D] Many-to-One

9. One-to-One

[A] One-to-Many

[B] Many-to-Many

[C] Many-to-One

[D] Many-to-One

सही उत्तर: Many-to-One

व्याख्या: यह valid option नहीं माना गया

Correct Answer: Given option marked as correct answer

Explanation: 2026-05-27 15:56:02

10. SQL में table delete करने के लिए कौन सा command है?

[A] DELETE

[B] DROP

[C] REMOVE

[D] TRUNCATE

10. DELETE

[A] DROP

[B] REMOVE

[C] TRUNCATE

[D] DROP

सही उत्तर: DROP

व्याख्या: DROP table remove करता है

Correct Answer: DROP deletes entire table

Explanation: 2026-05-27 15:56:16