कम्प्युटर र सूचना प्रविधि (प्राविधिक)
कम्प्युटर र सूचना प्रविधि (प्राविधिक)
Computer & IT (Technical) · ५,०७६ प्रश्न
५,०७६ प्रश्न उपलब्ध। मोड छान्नुहोस्:
कम्प्युटर र IT: प्रश्न र उत्तर
सही लागेको विकल्पमा थिच्नुहोस्। सही भए हरियो, गलत भए रातो देखिन्छ; ३ सेकेन्डपछि सही उत्तर र व्याख्या देखिन्छ।
सही: ० / ०
-
Splitting a large database horizontally across many servers, each holding a portion of the data, to scale out is called:
सही उत्तर: घ) Sharding
Sharding distributes rows among servers by a shard key so that load and storage are spread out.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Many NoSQL systems follow the BASE model instead of ACID. In BASE, 'E' stands for:
सही उत्तर: ग) Eventual consistency
BASE means Basically Available, Soft state, Eventually consistent: replicas may differ briefly but converge over time.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Apache Cassandra is an example of which type of NoSQL database?
सही उत्तर: ख) Wide-column (column-family) store
Cassandra organises data into column families across many nodes and is designed for high write throughput and availability.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Neo4j, which stores data as nodes and relationships and is suited to social networks, is a:
सही उत्तर: क) Graph database
Graph databases store entities as nodes and their connections as edges, making relationship-heavy queries efficient.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Redis, which stores data as simple pairs of unique keys and their values, is an example of a:
सही उत्तर: क) Key-value store
Key-value stores like Redis are very fast for lookups by key and are widely used for caching and sessions.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
The protocol that ensures a distributed transaction either commits at all participating sites or aborts at all of them, using a coordinator that collects votes, is:
सही उत्तर: घ) Two-phase commit (2PC)
In 2PC the coordinator first asks all sites to prepare (vote), then sends a global commit only if every site voted yes.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
In a distributed database, splitting a table so that different rows are stored at different sites (e.g., each province's customers at its own office) is called:
सही उत्तर: ग) Horizontal fragmentation
Horizontal fragmentation divides a relation into subsets of tuples using selection conditions; vertical fragmentation divides it by columns.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Extendible hashing differs from static hashing because it:
सही उत्तर: घ) Grows the number of buckets dynamically using a directory, splitting only the overflowing bucket
Extendible hashing doubles a directory of pointers when needed and splits only the full bucket, avoiding long overflow chains.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
A file has 30,000 records of 100 bytes each, stored unspanned in 1,024-byte blocks and sorted on the key. About how many block accesses does a binary search on this file need?
सही उत्तर: ख) 12
Blocking factor = floor(1024/100) = 10, so there are 30,000/10 = 3,000 blocks; binary search needs ceil(log2 3000) = 12 accesses.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
A bitmap index is most suitable for a column that has:
सही उत्तर: ग) Few distinct values, such as gender or province
Bitmap indexes keep one bit-vector per distinct value, so they are compact and fast for low-cardinality columns in analytical queries.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
यी अभ्यास प्रश्न हुन्, आधिकारिक प्रश्न होइनन्। पाठ्यक्रम, विज्ञापन र नतिजाका लागि सम्बन्धित निकायको आधिकारिक वेबसाइट हेर्नुहोस्। उत्तरमा गल्ती भेटे प्रश्नमुनिको "टिप्पणी / गल्ती रिपोर्ट" मा लेख्नुहोस्।
नमस्ते! पाठ्यक्रम, सामान्य ज्ञान, भाषा परीक्षा वा कुनै प्रश्नको उत्तर बुझ्न सोध्नुहोस्।
AI ले गल्ती गर्न सक्छ। महत्वपूर्ण कुरा आधिकारिक स्रोतमा जाँच्नुहोस्।