[ Database ]

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

[ Database ]

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

41. Non-relational database कौन सा है?

[A] Oracle

[B] MySQL

[C] MongoDB

[D] PostgreSQL

41. Which is non-relational database?

[A] Oracle

[B] MySQL

[C] MongoDB

[D] PostgreSQL

सही उत्तर: MongoDB

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

Correct Answer: MongoDB

Explanation: NoSQL database

42. One-to-many relation क्या है?

[A] One-to-one

[B] One-to-many

[C] Many-to-many

[D] None

42. One-to-many relationship?

[A] One-to-one

[B] One-to-many

[C] Many-to-many

[D] None

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

व्याख्या: एक record कई से जुड़ता है

Correct Answer: One-to-many

Explanation: One to many relation

43. Normalization का purpose क्या है?

[A] Increase redundancy

[B] Simplify queries

[C] Remove redundancy

[D] Speed up

43. Purpose of normalization?

[A] Increase redundancy

[B] Simplify queries

[C] Remove redundancy

[D] Speed up

सही उत्तर: Remove redundancy

व्याख्या: Redundancy हटाना

Correct Answer: Remove redundancy

Explanation: Eliminates redundancy

44. HAVING clause का use?

[A] Before filter

[B] After grouping filter

[C] Calculation

[D] None

44. Use of HAVING clause?

[A] Before grouping

[B] After grouping

[C] Calculation

[D] None

सही उत्तर: After grouping filter

व्याख्या: Group के बाद filter

Correct Answer: After grouping

Explanation: Filters grouped data

45. Foreign key क्या है?

[A] Candidate key

[B] Link tables

[C] Composite key

[D] Super key

45. What is foreign key?

[A] Candidate key

[B] Link tables

[C] Composite key

[D] Super key

सही उत्तर: Link tables

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

Correct Answer: Link tables

Explanation: Connects tables

46. Relational model में data कहाँ store होता है?

[A] Objects

[B] Tables

[C] Tree

[D] Network

46. Where is data stored in relational model?

[A] Objects

[B] Tables

[C] Tree

[D] Network

सही उत्तर: Tables

व्याख्या: Tables में data store होता है

Correct Answer: Tables

Explanation: Stored in tables

47. DBMS का main function क्या है?

[A] Store & manage data

[B] Only files

[C] Only calculations

[D] Only relations

47. Primary function of DBMS?

[A] Store & manage data

[B] Files

[C] Calculations

[D] Relations

सही उत्तर: Store & manage data

व्याख्या: Data manage करना

Correct Answer: Store & manage data

Explanation: Manages data

48. Duplicate remove करने का keyword?

[A] DISTINCT

[B] UNIQUE

[C] NO_DUPLICATE

[D] NONE

48. SQL keyword to remove duplicates?

[A] DISTINCT

[B] UNIQUE

[C] NO_DUPLICATE

[D] NONE

सही उत्तर: DISTINCT

व्याख्या: Duplicates हटाता है

Correct Answer: DISTINCT

Explanation: Removes duplicates

49. DBMS advantage क्या है?

[A] Enhanced security

[B] High redundancy

[C] Poor integrity

[D] Complexity

49. Advantage of DBMS?

[A] Enhanced security

[B] High redundancy

[C] Poor integrity

[D] Complexity

सही उत्तर: Enhanced security

व्याख्या: Security improve करता है

Correct Answer: Enhanced security

Explanation: Improves security

50. Table create syntax?

[A] CREATE TABLE

[B] CREATE table_name

[C] TABLE CREATE

[D] None

50. SQL table creation syntax?

[A] CREATE TABLE

[B] CREATE table_name

[C] TABLE CREATE

[D] None

सही उत्तर: CREATE TABLE

व्याख्या: Correct syntax

Correct Answer: CREATE TABLE

Explanation: Standard SQL syntax