🔔 YJ Notes ke saath updated rahein! Naye notes aur exam updates ke liye notifications ON karein.
🧪
💻
Basic Computer Instructor Database Management Quiz
Computer 📌 Database Management
10:00
TIME LEFT
Progress:
0/12
Question 1 of 12
Consider the following statements regarding key - n (I) A super key is an attribute or combination of attributes that uniquely identifies records in a RDBMS table. n (II) A candidate key is a subset of a super key. n (III) All super keys are candidate keys but vice versa is not true. / Key के संबंध में निम्नलिखित कथनों पर विचार करें -
💡 Explanation: Super key table me records ko uniquely identify karti hai aur Candidate ki isi ka ek subset hoti hai (minimal super key). Isliye (I) aur (II) dono sahi hain.
Question 2 of 12
Which is not a type of NoSQL? / निम्न में से कौन सा NoSQL का प्रकार नहीं है?
💡 Explanation: CouchDB, MongoDB, aur HBase teenon bohot prasiddh NoSQL databases hain. QBase naam ka koi NoSQL database nahi hota.
Question 3 of 12
Identify the most accurate statement about the application of XML - / XML के अनुप्रयोग के बारे में सबसे सटीक कथन की पहचान करें -
💡 Explanation: XML (Extensible Markup Language) ka mukhya upyog data ko hierarchical format (tree-like structure) me user-defined tags ke sath organize aur describe karne ke liye hota hai.
Question 4 of 12
To maintain materialized view in RDBMS, we use - / RDBMS में भौतिक दृष्टिकोण (materialized view) को बनाए रखने के लिए क्या इस्तेमाल किया जाता है?
💡 Explanation: Materialized view me data physically store hota hai, isliye base table me badlav hone par view ko update karne ke liye database Triggers ka use kiya jata hai.
Question 5 of 12
Which of the following statement contains an error? / निम्नलिखित में से किस कथन में त्रुटि है?
💡 Explanation: Option D me 'FROM table_name' missing hai. SQL me bina FROM clause ke hum data select nahi kar sakte, isliye is statement me error hai.
Question 6 of 12
In relational database minimal super keys is known as - / रिलेशनल डाटाबेस में मिनिमल सुपर कीज़ कहलाती हैं -
💡 Explanation: Super key ka wo sabse chota roop (minimal set) jisme se koi bhi attribute hatane par wo unique na rahe, use Candidate Key kehte hain.
Question 7 of 12
A relation in which every non-key attribute is fully functionally dependent on the primary key and which has no transitive dependencies is in - / एक रिलेशन जिसमें कोई ट्रांज़िटिव डिपेन्डेन्सी (निर्भरता) नहीं हो, वह किस नॉर्मल फॉर्म में होता है?
💡 Explanation: 3rd Normal Form (3NF) ki do main shartein hain: pehli wo 2NF me hona chahiye, aur doosri usme koi bhi transitive dependency nahi honi chahiye.
Question 8 of 12
If SQL command DELETE FROM EMPLOYEE; is executed on relation EMPLOYEE having 'n' tuple in it, _____ will be deleted from relation EMPLOYEE. / 'n' टपल वाले रिलेशन EMPLOYEE पर यदि DELETE कमांड चलाई जाए तो क्या हटेगा?
💡 Explanation: DELETE FROM table_name; command bina kisi WHERE clause ke chalane par table ke andar ka saara data (sabhi n tuples) delete ho jata hai, halanki table ka structure bacha rehta hai.
Question 9 of 12
Which of the following is valid pair of schema change statements in SQL? / निम्न में से कौनसा SQL में स्कीमा परिवर्तन कथनों का उचित युग्म है?
💡 Explanation: Table ya database ke schema (structure) ko badalne ya hatane ke liye DDL commands DROP aur ALTER ka use kiya jata hai. DELETE aur UPDATE data badalne ke liye hain.
Question 10 of 12
Which of the following database object does not physically exist? / निम्नलिखित में से कौन सा डेटाबेस ऑब्जेक्ट भौतिक रूप से मौजूद नहीं है?
💡 Explanation: View ek virtual table hoti है jo kisi query ke result par aadharit hoti hai. Iska data physically database me store nahi hota, balki ye har baar run hone par base table se data leti hai.
Question 11 of 12
Which of the following is not a super key in a relational schema with attributes V, W, X, Y, Z and primary key VY? / निम्नलिखित में से कौनसा एट्रिब्यूट 'सुपर की' नहीं है यदि प्राइमरी की VY है?
💡 Explanation: Super key ke andar Primary Key (VY) ke dono attributes ka hona bilkul zaroori hai. Option B (VWXZ) me 'Y' missing hai, isliye ye super key nahi ho sakti.
Question 12 of 12
In SQL, _____ is an aggregate function. / SQL में _____ एक एग्रिगेट फंक्शन है।
💡 Explanation: AVG() ek aggregate function hai jo multiple rows ki numeric values ka average (औसत) nikalta hai. Baki sab SQL commands/keywords hain.
📝
Complete Quiz Summary
All answers reviewed below