Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
531
What is the primary difference between a DBMS and an RDBMS?
Answer:
An RDBMS is based on the relational model, which is a specific type of DBMS.
RDBMS (Relational Database Management System) is a type of DBMS that stores data in a structured format, using rows and columns (tables), based on the principles of the relational model. All RDBMS are DBMS, but not all DBMS are RDBMS.
532
What is a UNIQUE constraint?
Answer:
It ensures that all values in a column are different.
The UNIQUE constraint ensures that all values in a specific column (or a set of columns) are unique. Unlike a primary key, a unique constraint can allow one NULL value in some database systems.