[ Database ]

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

[ Database ]

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

61. Table delete command correct?

[A] Delete from teaches

[B] Delete where null

[C] Remove table

[D] Drop table

61. Correct delete command?

[A] Delete from teaches

[B] Delete where null

[C] Remove table

[D] Drop table

सही उत्तर: Delete from teaches

व्याख्या: Correct delete syntax

Correct Answer: Delete from teaches

Explanation: Removes tuples

62. Procedural language कौन सा है?

[A] DRC

[B] TRC

[C] Relational algebra

[D] Query language

62. Which is procedural language?

[A] DRC

[B] TRC

[C] Relational algebra

[D] Query language

सही उत्तर: Relational algebra

व्याख्या: Procedural language

Correct Answer: Relational algebra

Explanation: Procedural language

63. Inner join क्या करता है?

[A] Non matched include

[B] Matched only

[C] All tuples

[D] None

63. What does inner join do?

[A] Non matched

[B] Matched only

[C] All tuples

[D] None

सही उत्तर: Matched only

व्याख्या: Only matching rows देता है

Correct Answer: Matched only

Explanation: Returns matching rows

64. 3NF relation क्या दर्शाता है?

[A] Single entity

[B] Multiple entities

[C] Tree

[D] Network

64. 3NF represents?

[A] Single entity

[B] Multiple

[C] Tree

[D] Network

सही उत्तर: Single entity

व्याख्या: One entity representation

Correct Answer: Single entity

Explanation: One entity

65. Catalog level structure?

[A] Schemas & Catalogs

[B] Schemas only

[C] Environment

[D] None

65. Top hierarchy level?

[A] Schemas

[B] Catalogs

[C] Environment

[D] Schemas

सही उत्तर: Catalogs & Schemas

व्याख्या: DBMS hierarchy

Correct Answer: Catalogs & Schemas

Explanation: Metadata structure

66. Cardinality क्या है?

[A] Uniqueness

[B] Min entity

[C] Max entity

[D] ERD

66. What is cardinality?

[A] Uniqueness

[B] Min

[C] Max

[D] ERD

सही उत्तर: Maximum entity count

व्याख्या: Relationship max limit

Correct Answer: Maximum entity count

Explanation: Max relation count

67. User access role?

[A] db_sysadmin

[B] db_accessadmin

[C] db_securityadmin

[D] db_setupadmin

67. Which role adds/removes user IDs?

[A] db_sysadmin

[B] db_accessadmin

[C] db_securityadmin

[D] db_setupadmin

सही उत्तर: db_accessadmin

व्याख्या: User access manage करता है

Correct Answer: db_accessadmin

Explanation: Manages access

68. Group by error query issue?

[A] Invalid group

[B] Agg issue

[C] Column mismatch

[D] None

68. Why query is erroneous?

[A] Invalid

[B] Agg

[C] Column mismatch

[D] None

सही उत्तर: Column mismatch

व्याख्या: GROUP BY rule violation

Correct Answer: Column mismatch

Explanation: Grouping rule

69. Old file system example?

[A] Object DB

[B] Relational DB

[C] Hierarchical DB

[D] Network DB

69. Traditional file system example?

[A] Object

[B] Relational

[C] Hierarchical

[D] Network

सही उत्तर: Hierarchical DB

व्याख्या: Old file system model

Correct Answer: Hierarchical DB

Explanation: Parent-child model

70. HAVING clause used for?

[A] Before filter

[B] After filter

[C] Calculation

[D] None

70. After grouping predicate?

[A] Before

[B] After

[C] Calc

[D] None

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

व्याख्या: Group filtering

Correct Answer: After grouping

Explanation: Filters groups