[ Database ]

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

[ Database ]

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

21. Data dictionary क्या होता है?

[A] User data

[B] All data

[C] Metadata repository

[D] Special table

21. User data

[A] All data

[B] Metadata repository

[C] Table

[D] Metadata repository

सही उत्तर: Metadata repository

व्याख्या: Database metadata store करता है

Correct Answer: Stores metadata

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

22. SQL JOIN क्या करता है?

[A] Tables combine

[B] Single table

[C] Delete data

[D] Not used

22. Combine tables

[A] Single table

[B] Delete data

[C] None

[D] Combine tables

सही उत्तर: Tables combine

व्याख्या: Related tables join करता है

Correct Answer: Combines rows

Explanation: 2026-05-27 16:00:08

23. ACID का full form?

[A] Atomicity Consistency Isolation Durability

[B] Accuracy Control Integrity Data

[C] None

[D] None

23. Atomicity Consistency Isolation Durability

[A] Accuracy Control Integrity Data

[B] None

[C] None

[D] Atomicity Consistency Isolation Durability

सही उत्तर: Atomicity Consistency Isolation Durability

व्याख्या: ACID properties

Correct Answer: Transaction properties

Explanation: 2026-05-27 16:00:21

24. GROUP BY का use?

[A] Sort

[B] Filter

[C] Group records

[D] Join tables

24. Sort

[A] Filter

[B] Group

[C] Join

[D] Group records

सही उत्तर: Group records

व्याख्या: Records group करता है

Correct Answer: Used for grouping

Explanation: 2026-05-27 16:00:33

25. DML command example कौन सा है?

[A] SELECT

[B] CREATE

[C] DROP

[D] ALTER

25. SELECT

[A] CREATE

[B] DROP

[C] ALTER

[D] SELECT

सही उत्तर: SELECT

व्याख्या: SELECT DML command है

Correct Answer: DML operation

Explanation: 2026-05-27 16:00:48

26. Referential integrity क्या ensure करता है?

[A] Consistency

[B] Uniqueness

[C] Format

[D] None

26. Consistency

[A] Uniqueness

[B] Format

[C] None

[D] Consistency

सही उत्तर: Consistency

व्याख्या: Tables consistency maintain करता है

Correct Answer: Ensures consistency

Explanation: 2026-05-27 16:01:02

27. Full outer join क्या return करता है?

[A] Match only

[B] Left only

[C] Right only

[D] All records

27. Match

[A] Left

[B] Right

[C] All records

[D] All records

सही उत्तर: All records

व्याख्या: सभी records return करता है

Correct Answer: Returns all matches

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

28. DBMS disadvantage कौन सा है?

[A] High cost

[B] Security

[C] Control

[D] Integrity

28. Cost

[A] Security

[B] Control

[C] Integrity

[D] Cost

सही उत्तर: High cost

व्याख्या: DBMS costly होता है

Correct Answer: High cost system

Explanation: 2026-05-27 16:01:27

29. SUM() function क्या करता है?

[A] Count

[B] Average

[C] Total sum

[D] Min value

29. Count

[A] Average

[B] Sum

[C] Min

[D] Sum

सही उत्तर: Total sum

व्याख्या: Values का total देता है

Correct Answer: Calculates total

Explanation: 2026-05-27 16:01:41

30. 3NF किसे eliminate करता है?

[A] Redundancy

[B] Dependency

[C] Speed

[D] None

30. Redundancy

[A] Dependency

[B] Speed

[C] None

[D] Dependency

सही उत्तर: Dependency

व्याख्या: Transitive dependency हटाता है

Correct Answer: Removes transitive dependency

Explanation: 2026-05-27 16:01:54