[ Database ]

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

[ Database ]

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

31. SQL में aggregate function का कौन सा example है?

[A] COUNT

[B] SUM

[C] AVG

[D] All of the above

31. Which of the following is an example of an aggregate function in SQL?

[A] COUNT

[B] SUM

[C] AVG

[D] All of the above

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

व्याख्या: सभी aggregate functions हैं

Correct Answer: All of the above

Explanation: All are aggregate functions

32. Database में trigger क्या होता है?

[A] Event पर run होने वाला stored procedure

[B] Unique key बनाने का method

[C] Constraint

[D] Relationship define करने का method

32. What is a trigger in a database?

[A] A stored procedure that runs on event

[B] Generate unique keys

[C] Constraint

[D] Define relationships

सही उत्तर: Event पर run होने वाला stored procedure

व्याख्या: Trigger event पर run होता है

Correct Answer: A stored procedure that runs on event

Explanation: Executes on event

33. NoSQL database की characteristic क्या है?

[A] Fixed schema

[B] Horizontal scaling

[C] Tables

[D] All of the above

33. Characteristic of NoSQL database?

[A] Fixed schema

[B] Horizontal scaling

[C] Tables

[D] All of the above

सही उत्तर: Horizontal scaling

व्याख्या: NoSQL horizontally scale करता है

Correct Answer: Horizontal scaling

Explanation: Supports horizontal scaling

34. SQL में sorting के लिए कौन सा clause use होता है?

[A] ORDER BY

[B] HAVING

[C] WHERE

[D] GROUP BY

34. Which SQL clause is used to sort results?

[A] ORDER BY

[B] HAVING

[C] WHERE

[D] GROUP BY

सही उत्तर: ORDER BY

व्याख्या: Sorting के लिए use होता है

Correct Answer: ORDER BY

Explanation: Used for sorting

35. Most common DBMS model कौन सा है?

[A] Relational

[B] Network

[C] Hierarchical

[D] Object-Oriented

35. Most common DBMS model today?

[A] Relational

[B] Network

[C] Hierarchical

[D] Object-Oriented

सही उत्तर: Relational

व्याख्या: Most widely used model

Correct Answer: Relational

Explanation: Most common model

36. Transaction operations कौन कौन से हैं?

[A] COMMIT

[B] ROLLBACK

[C] SAVEPOINT

[D] All of the above

36. Operations in DBMS transactions?

[A] COMMIT

[B] ROLLBACK

[C] SAVEPOINT

[D] All of the above

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

व्याख्या: सभी transaction operations हैं

Correct Answer: All of the above

Explanation: All are transaction operations

37. NOT a SQL constraint कौन सा है?

[A] PRIMARY KEY

[B] UNIQUE

[C] FOREIGN KEY

[D] DISPLAY

37. Which is NOT a SQL constraint?

[A] PRIMARY KEY

[B] UNIQUE

[C] FOREIGN KEY

[D] DISPLAY

सही उत्तर: DISPLAY

व्याख्या: DISPLAY constraint नहीं है

Correct Answer: DISPLAY

Explanation: Invalid constraint

38. Modern relational model कौन सा है?

[A] Hierarchical

[B] Relational

[C] Object-Oriented

[D] Network

38. Data model used in modern DB?

[A] Hierarchical

[B] Relational

[C] Object-Oriented

[D] Network

सही उत्तर: Relational

व्याख्या: Modern database model

Correct Answer: Relational

Explanation: Most used model

39. Text functions का example क्या है?

[A] CONCAT()

[B] LENGTH()

[C] UPPER()

[D] All of the above

39. SQL text functions example?

[A] CONCAT()

[B] LENGTH()

[C] UPPER()

[D] All of the above

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

व्याख्या: All are text functions

Correct Answer: All of the above

Explanation: All are text functions

40. Update command कौन सा है?

[A] MODIFY

[B] CHANGE

[C] UPDATE

[D] INSERT

40. Which command updates data?

[A] MODIFY

[B] CHANGE

[C] UPDATE

[D] INSERT

सही उत्तर: UPDATE

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

Correct Answer: UPDATE

Explanation: Used to update data