[C-Sharp Programming MCQS ]

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

[ C-Sharp Programming MCQS ]

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

631. Lazy Loading क्या है?

[A] Immediate load

[B] On-demand load

[C] No load

[D] Cache load

631. What is lazy loading?

[A] Immediate load

[B] On-demand load

[C] No load

[D] Cache load

सही उत्तर: On-demand load

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: On-demand load

Explanation: Important question.

632. Eager Loading क्या है?

[A] On-demand load

[B] Pre-load related data

[C] No load

[D] Cache only

632. What is eager loading?

[A] On-demand load

[B] Pre-load related data

[C] No load

[D] Cache only

सही उत्तर: Pre-load related data

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Pre-load related data

Explanation: Important question.

633. Explicit Loading क्या है?

[A] Automatic load

[B] Manually load related data

[C] No load

[D] Cache load

633. What is explicit loading?

[A] Automatic load

[B] Manually load related data

[C] No load

[D] Cache load

सही उत्तर: Manually load related data

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Manually load related data

Explanation: Important question.

634. Include() का use क्या है?

[A] Delete relation

[B] Eager loading

[C] Threading

[D] Caching

634. What is Include() used for?

[A] Delete relation

[B] Eager loading

[C] Threading

[D] Caching

सही उत्तर: Eager loading

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Eager loading

Explanation: Important question.

635. AsNoTracking() का benefit क्या है?

[A] High memory usage

[B] Better performance

[C] Slow queries

[D] Lock database

635. What is benefit of AsNoTracking?

[A] High memory usage

[B] Better performance

[C] Slow queries

[D] Lock database

सही उत्तर: Better performance

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Better performance

Explanation: Important question.

636. Primary Key का purpose क्या है?

[A] Duplicate allow

[B] Unique identification

[C] Thread control

[D] Memory control

636. What is primary key used for?

[A] Duplicate allow

[B] Unique identification

[C] Thread control

[D] Memory control

सही उत्तर: Unique identification

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Unique identification

Explanation: Important question.

637. Foreign Key क्या है?

[A] Primary identifier

[B] Relationship between tables

[C] Thread key

[D] Cache key

637. What is foreign key?

[A] Primary identifier

[B] Relation between tables

[C] Thread key

[D] Cache key

सही उत्तर: Relationship between tables

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Relation between tables

Explanation: Important question.

638. Index का use क्या है?

[A] Slow query

[B] Fast search

[C] Memory delete

[D] Thread stop

638. What is index used for?

[A] Slow query

[B] Fast search

[C] Memory delete

[D] Thread stop

सही उत्तर: Fast search

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Fast search

Explanation: Important question.

639. Indexing से क्या फायदा होता है?

[A] Slow performance

[B] Fast query execution

[C] Memory leak

[D] Thread block

639. What is benefit of indexing?

[A] Slow performance

[B] Fast execution

[C] Memory leak

[D] Thread block

सही उत्तर: Fast query execution

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: Fast execution

Explanation: Important question.

640. Stored procedure क्या है?

[A] C# function

[B] SQL precompiled query

[C] Thread process

[D] File process

640. What is stored procedure?

[A] C# function

[B] SQL precompiled query

[C] Thread process

[D] File process

सही उत्तर: SQL precompiled query

व्याख्या: महत्वपूर्ण प्रश्न।

Correct Answer: SQL precompiled query

Explanation: Important question.