[ DOT NET Core MCQS ]
झारखंड में आयोजित होने वाली JPSC, JSSC, JET, झारखंड पुलिस भर्ती परीक्षा आदि के लिए उपयोगी सामान्य अध्ययन।
[ DOT NET Core MCQS ]
Useful GK for JPSC, JSSC, JET, Jharkhand Police and other exams.
671. Connection Pooling किस Component द्वारा Manage की जाती है?
[A] ADO.NET Provider
[B] SqlCommand
[C] DataSet
[D] DataTable
671. Who manages Connection Pooling?
[A] ADO.NET Provider
[B] SqlCommand
[C] DataSet
[D] DataTable
सही उत्तर: ADO.NET Provider
व्याख्या: Connection Pool Automatically Manage होती है।
Correct Answer: ADO.NET Provider
Explanation: Connection pools are managed automatically.
672. Open और Close Connection बार-बार करने पर कौन सी सुविधा Performance बढ़ाती है?
[A] Connection Pooling
[B] Transactions
[C] Stored Procedures
[D] Views
672. Which feature improves performance when opening and closing connections frequently?
[A] Connection Pooling
[B] Transactions
[C] Stored Procedures
[D] Views
सही उत्तर: Connection Pooling
व्याख्या: Existing Connections Reuse होती हैं।
Correct Answer: Connection Pooling
Explanation: Previously created connections are reused.
673. ExecuteReaderAsync() Method का उपयोग किसलिए होता है?
[A] Asynchronous Data Reading
[B] Synchronous Data Reading
[C] Data Update
[D] Data Delete
673. What is ExecuteReaderAsync() used for?
[A] Asynchronous Data Reading
[B] Synchronous Data Reading
[C] Data Update
[D] Data Delete
सही उत्तर: Asynchronous Data Reading
व्याख्या: Async Programming में Data Read करने के लिए।
Correct Answer: Asynchronous Data Reading
Explanation: Reads data asynchronously.
674. ExecuteNonQueryAsync() Method क्या करती है?
[A] Async INSERT/UPDATE/DELETE Execute करती है
[B] Data Read करती है
[C] Connection Close करती है
[D] Transaction Rollback करती है
674. What does ExecuteNonQueryAsync() do?
[A] Executes INSERT/UPDATE/DELETE Asynchronously
[B] Reads Data
[C] Closes Connection
[D] Rolls Back Transaction
सही उत्तर: Async INSERT/UPDATE/DELETE Execute करती है
व्याख्या: Non Query Commands को Async रूप में Execute करती है।
Correct Answer: Executes INSERT/UPDATE/DELETE Asynchronously
Explanation: Runs non-query commands asynchronously.
675. OpenAsync() Method का उपयोग किसलिए होता है?
[A] Asynchronous Connection Open करने के लिए
[B] Connection Close करने के लिए
[C] Transaction Start करने के लिए
[D] Data Read करने के लिए
675. What is OpenAsync() used for?
[A] Open Connection Asynchronously
[B] Close Connection
[C] Start Transaction
[D] Read Data
सही उत्तर: Asynchronous Connection Open करने के लिए
व्याख्या: Database Connection Async तरीके से Open करती है।
Correct Answer: Open Connection Asynchronously
Explanation: Opens database connection asynchronously.
676. SqlBulkCopy Class का उपयोग किसलिए किया जाता है?
[A] Bulk Data Insert
[B] Bulk Delete
[C] Bulk Update
[D] Bulk Select
676. What is SqlBulkCopy used for?
[A] Bulk Data Insert
[B] Bulk Delete
[C] Bulk Update
[D] Bulk Select
सही उत्तर: Bulk Data Insert
व्याख्या: Large Amount Data तेजी से Insert करने के लिए।
Correct Answer: Bulk Data Insert
Explanation: Used for high-speed bulk inserts.
677. SqlBulkCopy का मुख्य लाभ क्या है?
[A] High Performance Insert
[B] Security
[C] Authentication
[D] Routing
677. What is the main advantage of SqlBulkCopy?
[A] High Performance Insert
[B] Security
[C] Authentication
[D] Routing
सही उत्तर: High Performance Insert
व्याख्या: Large Data Migration में उपयोगी है।
Correct Answer: High Performance Insert
Explanation: Useful for large-scale data migration.
678. CommandTimeout Property क्या निर्धारित करती है?
[A] Query Execution Time Limit
[B] Connection String
[C] Database Name
[D] Table Name
678. What does CommandTimeout define?
[A] Query Execution Time Limit
[B] Connection String
[C] Database Name
[D] Table Name
सही उत्तर: Query Execution Time Limit
व्याख्या: Specified Time के बाद Command Timeout हो जाता है।
Correct Answer: Query Execution Time Limit
Explanation: Command times out after specified duration.
679. Default CommandTimeout सामान्यतः कितने Seconds होता है?
[A] 30
[B] 10
[C] 60
[D] 120
679. What is the default CommandTimeout value?
[A] 30
[B] 10
[C] 60
[D] 120
सही उत्तर: 30
व्याख्या: SQL Server Provider में सामान्य Default Value 30 Seconds होती है।
Correct Answer: 30
Explanation: Typically 30 seconds for SQL Server provider.
680. Isolation Level का उद्देश्य क्या है?
[A] Transaction Concurrency Control
[B] Authentication
[C] Routing
[D] Logging
680. What is the purpose of Isolation Level?
[A] Transaction Concurrency Control
[B] Authentication
[C] Routing
[D] Logging
सही उत्तर: Transaction Concurrency Control
व्याख्या: Concurrent Transactions के व्यवहार को नियंत्रित करती है।
Correct Answer: Transaction Concurrency Control
Explanation: Controls behavior of concurrent transactions.