[ Database ]

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

[ Database ]

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

11. DBMS transaction error-free complete करने के लिए कौन सा control use होता है?

[A] Concurrency Control

[B] Transaction Control

[C] Data Integrity

[D] Backup Management

11. Which ensures transactions are completed without errors?

[A] Concurrency Control

[B] Transaction Control

[C] Data Integrity

[D] Backup Management

सही उत्तर: Transaction Control

व्याख्या: Transactions को safely complete करता है

Correct Answer: Transaction Control

Explanation: Ensures safe transaction completion

12. DBMS constraint कौन सा है?

[A] Primary Key

[B] Foreign Key

[C] Check

[D] All of the above

12. Primary Key

[A] Foreign Key

[B] Check

[C] All of the above

[D] All of the above

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

व्याख्या: सभी constraints होते हैं

Correct Answer: All are constraints

Explanation: 2026-05-27 15:57:42

13. SQL का full form क्या है?

[A] Structured Query Language

[B] Simple Query Language

[C] Sequential Query Language

[D] None

13. Structured Query Language

[A] Simple Query Language

[B] Sequential Query Language

[C] None

[D] Structured Query Language

सही उत्तर: Structured Query Language

व्याख्या: SQL का सही full form

Correct Answer: Correct expansion

Explanation: 2026-05-27 15:57:57

14. DBMS का advantage कौन सा है?

[A] Data Redundancy

[B] Data Integrity

[C] Less Security

[D] Data Anomalies

14. Data Redundancy

[A] Data Integrity

[B] Less Security

[C] Data Anomalies

[D] Data Integrity

सही उत्तर: Data Integrity

व्याख्या: Integrity improve होती है

Correct Answer: Improves data integrity

Explanation: 2026-05-27 15:58:10

15. Foreign key क्या है?

[A] Unique column

[B] Two tables connect करने वाला key

[C] Not null key

[D] Password key

15. Unique key

[A] Connects two tables

[B] Not null key

[C] Password key

[D] Connects two tables

सही उत्तर: Two tables connect करने वाला key

व्याख्या: Foreign key relation बनाता है

Correct Answer: Used to link tables

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

16. Relational model की feature क्या है?

[A] Tables में data

[B] Pointers

[C] Objects

[D] None

16. Tables

[A] Pointers

[B] Objects

[C] None

[D] Tables

सही उत्तर: Tables में data

व्याख्या: Data tables में store होता है

Correct Answer: Data stored in tables

Explanation: 2026-05-27 15:58:38

17. Index का purpose क्या है?

[A] Speed increase

[B] Integrity

[C] Redundancy

[D] None

17. Speed up

[A] Integrity

[B] Redundancy

[C] None

[D] Speed up

सही उत्तर: Speed increase

व्याख्या: Data retrieval fast करता है

Correct Answer: Improves query speed

Explanation: 2026-05-27 15:58:51

18. MongoDB किस type का database है?

[A] Relational

[B] Object

[C] NoSQL

[D] Network

18. Relational

[A] Object

[B] NoSQL

[C] Network

[D] NoSQL

सही उत्तर: NoSQL

व्याख्या: MongoDB NoSQL database है

Correct Answer: MongoDB is NoSQL

Explanation: 2026-05-27 15:59:05

19. SQL में rows filter करने के लिए कौन सा clause use होता है?

[A] WHERE

[B] ORDER BY

[C] HAVING

[D] GROUP BY

19. WHERE

[A] ORDER BY

[B] HAVING

[C] GROUP BY

[D] WHERE

सही उत्तर: WHERE

व्याख्या: WHERE rows filter करता है

Correct Answer: Used to filter rows

Explanation: 2026-05-27 15:59:21

20. Database structure modify करने के लिए कौन सा language use होता है?

[A] DDL

[B] DML

[C] TCL

[D] DCL

20. DDL

[A] DML

[B] TCL

[C] DCL

[D] DDL

सही उत्तर: DDL

व्याख्या: DDL structure modify करता है

Correct Answer: Data Definition Language

Explanation: 2026-05-27 15:59:40