[ Database ]

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

[ Database ]

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

81. Schema command?

[A] Cluster

[B] Package

[C] Schema

[D] All

81. Command for multiple CREATE?

[A] Cluster

[B] Package

[C] Schema

[D] All

सही उत्तर: Schema

व्याख्या: Multiple SQL statements

Correct Answer: Schema

Explanation: Transaction schema

82. Encryption safety key?

[A] Primary

[B] Auth

[C] Encryption

[D] Decryption

82. Key for encryption?

[A] Primary

[B] Auth

[C] Encryption

[D] Decryption

सही उत्तर: Encryption key

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

Correct Answer: Encryption key

Explanation: Used for encryption

83. OLAP slicing?

[A] Dicing

[B] Pivot

[C] Slicing

[D] Both

83. Cross tab process?

[A] Dicing

[B] Pivot

[C] Slicing

[D] Both

सही उत्तर: Slicing

व्याख्या: Single dimension extraction

Correct Answer: Slicing

Explanation: Extracts cube slice

84. Best normalization form?

[A] 4NF

[B] 3NF

[C] 2NF

[D] 5NF

84. Best normal form for RDBMS?

[A] 4NF

[B] 3NF

[C] 2NF

[D] 5NF

सही उत्तर: 3NF

व्याख्या: Adequate normalization

Correct Answer: 3NF

Explanation: Most used form

85. RAID best write performance?

[A] RAID0

[B] RAID1

[C] RAID2

[D] RAID3

85. Best RAID for logs?

[A] RAID0

[B] RAID1

[C] RAID2

[D] RAID3

सही उत्तर: RAID1

व्याख्या: Mirroring provides performance

Correct Answer: RAID1

Explanation: Best write performance

86. Tuple calculus query?

[A] Bracket

[B] P(t)

[C] t|P(t)

[D] All

86. Tuple relational calculus?

[A] Bracket

[B] P(t)

[C] t|P(t)

[D] All

सही उत्तर: t|P(t)

व्याख्या: Correct format

Correct Answer: t|P(t)

Explanation: Valid query

87. Oldest DB model?

[A] Network

[B] Physical

[C] Hierarchical

[D] Relational

87. Oldest DB model?

[A] Network

[B] Physical

[C] Hierarchical

[D] Relational

सही उत्तर: Hierarchical

व्याख्या: Oldest model

Correct Answer: Hierarchical

Explanation: IBM model

88. DBA role output?

[A] Error

[B] Drop

[C] Access

[D] Query allowed

88. Result after revoke?

[A] Error

[B] Drop

[C] Access

[D] Query allowed

सही उत्तर: Query allowed

व्याख्या: SCOTT still has access

Correct Answer: Query allowed

Explanation: Access remains

89. Hierarchical schema?

[A] Top-bottom

[B] Network

[C] Relational

[D] All

89. Top-to-bottom model?

[A] Relational

[B] Network

[C] Hierarchical

[D] All

सही उत्तर: Hierarchical

व्याख्या: Tree structure

Correct Answer: Hierarchical

Explanation: Tree structure

90. Buffer function?

[A] Storage

[B] Catalog

[C] Block transfer reduce

[D] None

90. Buffer role?

[A] Storage

[B] Catalog

[C] Block transfer

[D] None

सही उत्तर: Block transfer reduction

व्याख्या: Memory optimization

Correct Answer: Block transfer reduce

Explanation: Optimizes memory