[ Database ]

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

[ Database ]

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

71. DBMS utility NOT?

[A] Backup

[B] Loading

[C] Process organization

[D] File org

71. Which is not DBMS utility?

[A] Backup

[B] Loading

[C] Process

[D] File org

सही उत्तर: Process organization

व्याख्या: Not DBMS utility

Correct Answer: Process organization

Explanation: Not a utility

72. Foreign key creates?

[A] Network

[B] Parent-child

[C] One-to-many

[D] All

72. Foreign key creates?

[A] Network

[B] Parent-child

[C] One-to-many

[D] All

सही उत्तर: Parent-child

व्याख्या: Table relationship

Correct Answer: Parent-child

Explanation: Relationship

73. DBMS consistency tool?

[A] Pointer

[B] Cursor

[C] Lock

[D] Trigger

73. Which maintains consistency?

[A] Pointer

[B] Cursor

[C] Lock

[D] Trigger

सही उत्तर: Lock

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

Correct Answer: Lock

Explanation: Ensures consistency

74. Spreadsheet file use?

[A] DBMS direct

[B] ASCII file

[C] All

[D] None

74. Spreadsheet file format?

[A] DBMS

[B] ASCII

[C] All

[D] None

सही उत्तर: DBMS direct

व्याख्या: Direct usable

Correct Answer: DBMS direct

Explanation: Used directly

75. Create view similar command?

[A] Create table as

[B] Create view

[C] Like

[D] With data

75. Equivalent of create view?

[A] Create table as

[B] Create view

[C] Like

[D] With data

सही उत्तर: Create table as

व्याख्या: Similar behavior

Correct Answer: Create table as

Explanation: Similar structure

76. View updatable condition?

[A] 1 table

[B] No group by

[C] No aggregate

[D] All

76. When is view updatable?

[A] 1 table

[B] No group by

[C] No aggregate

[D] All

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

व्याख्या: All conditions required

Correct Answer: All of the mentioned

Explanation: All conditions must match

77. ROLLUP use?

[A] Subtotals

[B] Groups

[C] Right-left grouping

[D] Cross tab

77. ROLLUP used for?

[A] Subtotals

[B] Groups

[C] Right-left

[D] Cross tab

सही उत्तर: Right-to-left grouping

व्याख्या: Subtotals generate करता है

Correct Answer: Right-to-left grouping

Explanation: Computes subtotals

78. Attribute representation?

[A] Dot

[B] Concatenation

[C] Relational

[D] All

78. Best attribute representation?

[A] Dot

[B] Concatenation

[C] Relational

[D] All

सही उत्तर: Concatenation

व्याख्या: Fields combine करता है

Correct Answer: Concatenation

Explanation: Joins attributes

79. DDL purpose?

[A] Manipulate

[B] Retrieve

[C] Define structure

[D] None

79. DDL used for?

[A] Manipulate

[B] Retrieve

[C] Define

[D] None

सही उत्तर: Define structure

व्याख्या: Schema define करता है

Correct Answer: Define structure

Explanation: Defines schema

80. Histogram function?

[A] ntile

[B] rank

[C] bucket

[D] all

80. Which creates histogram buckets?

[A] ntile

[B] rank

[C] bucket

[D] all

सही उत्तर: ntile

व्याख्या: Bucket ranking करता है

Correct Answer: ntile

Explanation: Creates buckets