कम्प्युटर र सूचना प्रविधि (प्राविधिक)
कम्प्युटर र सूचना प्रविधि (प्राविधिक)
Computer & IT (Technical) · ५,०७६ प्रश्न
५,०७६ प्रश्न उपलब्ध। मोड छान्नुहोस्:
कम्प्युटर र IT: प्रश्न र उत्तर
सही लागेको विकल्पमा थिच्नुहोस्। सही भए हरियो, गलत भए रातो देखिन्छ; ३ सेकेन्डपछि सही उत्तर र व्याख्या देखिन्छ।
सही: ० / ०
-
Unlike a primary key column, a foreign key column:
सही उत्तर: ख) Can contain NULL values and duplicate values
A foreign key must match a referenced key value or be NULL, and many child rows may share the same foreign key value.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
A system-generated key with no business meaning, such as an auto-increment ID, used as the primary key is called a:
सही उत्तर: क) Surrogate key
A surrogate key is an artificial identifier created only to identify rows uniquely, unlike natural keys such as citizenship number.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
In the extended ER model, treating a relationship together with its participating entities as a higher-level entity so that it can take part in another relationship is called:
सही उत्तर: घ) Aggregation
Aggregation lets a relationship set be treated as an abstract entity, e.g. linking a 'works-on' relationship to a 'Manager' entity.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
Creating a higher-level entity set, such as 'Vehicle', from lower-level entity sets such as 'Car' and 'Bus' by extracting their common features is called:
सही उत्तर: ग) Generalization
Generalization is a bottom-up process combining common attributes into a superclass; specialization is the reverse, top-down process.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
The attribute that distinguishes weak entities belonging to the same owner entity, shown with a dashed underline, is called the:
सही उत्तर: ख) Partial key (discriminator)
A weak entity is identified by its owner's key combined with its partial key (discriminator).
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
The relationship between a weak entity set and its owner (identifying) entity set is shown in an ER diagram by a:
सही उत्तर: क) Double diamond
An identifying relationship is drawn as a double diamond; the weak entity itself is a double rectangle.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
In an ER diagram, a double line connecting an entity set to a relationship set indicates:
सही उत्तर: घ) Total participation of that entity set in the relationship
Total participation means every entity in the set must take part in at least one relationship instance.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
In an ER diagram, the key (identifying) attribute of an entity is shown by:
सही उत्तर: ग) Underlining the attribute name
The primary key attribute's name is underlined inside its ellipse.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
In an ER diagram, a derived attribute such as 'Age' (calculated from date of birth) is shown by a:
सही उत्तर: ख) Dashed ellipse
A dashed ellipse marks a derived attribute whose value can be computed from other attributes.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
-
The network data model, standardised by CODASYL, differs from the hierarchical model because it:
सही उत्तर: क) Allows a record to have more than one parent (owner)
The network model represents data as a graph of records and sets, so a member record can belong to several owners, supporting many-to-many relationships.
💬 टिप्पणी / गल्ती रिपोर्ट (०)
यी अभ्यास प्रश्न हुन्, आधिकारिक प्रश्न होइनन्। पाठ्यक्रम, विज्ञापन र नतिजाका लागि सम्बन्धित निकायको आधिकारिक वेबसाइट हेर्नुहोस्। उत्तरमा गल्ती भेटे प्रश्नमुनिको "टिप्पणी / गल्ती रिपोर्ट" मा लेख्नुहोस्।
नमस्ते! पाठ्यक्रम, सामान्य ज्ञान, भाषा परीक्षा वा कुनै प्रश्नको उत्तर बुझ्न सोध्नुहोस्।
AI ले गल्ती गर्न सक्छ। महत्वपूर्ण कुरा आधिकारिक स्रोतमा जाँच्नुहोस्।