What does RDBMS stand for?
A
Relational Data Base Management Software
B
Relational Database Management System
C
Reliable Database Model Structure
D
Random Database Management System
Analysis & Theory
RDBMS stands for Relational Database Management System, which organizes data into tables.
Which of the following best describes an RDBMS?
A
Stores data in a flat file
B
Stores data in tables with relationships
C
Stores data only in arrays
D
Stores data in key-value pairs only
Analysis & Theory
RDBMS stores data in structured tables with relationships between them.
In MySQL RDBMS, what is a *table*?
C
A structured set of rows and columns
D
A graphical user interface
Analysis & Theory
A table in an RDBMS is a collection of rows and columns used to store related data.
What is a *primary key* in a MySQL table?
A
A key that is always empty
B
A key that connects two tables
C
A unique identifier for table rows
D
A column that stores null values
Analysis & Theory
A primary key uniquely identifies each row in a table and cannot contain NULL values.
Which constraint in MySQL RDBMS ensures *uniqueness* of data in a column?
Analysis & Theory
The UNIQUE constraint ensures all values in a column are different.
Which of these is used to define a relationship between two MySQL tables?
Analysis & Theory
FOREIGN KEY is used to define a relationship between a column in one table and a primary key in another.
In MySQL, which key combination ensures referential integrity?
A
PRIMARY KEY and DEFAULT
C
FOREIGN KEY and PRIMARY KEY
Analysis & Theory
Referential integrity is enforced by linking a FOREIGN KEY in one table to a PRIMARY KEY in another.
Which of the following is NOT a benefit of using an RDBMS like MySQL?
C
Object-oriented inheritance
Analysis & Theory
RDBMS systems like MySQL are not object-oriented and do not support inheritance directly.
Which SQL statement is used to enforce rules at the column level in MySQL RDBMS?
Analysis & Theory
CONSTRAINT is used to enforce rules such as NOT NULL, UNIQUE, PRIMARY KEY at the column level.
Which command shows the structure of a table in MySQL?
A
SHOW STRUCTURE tablename;
Analysis & Theory
DESCRIBE or DESC command in MySQL displays the structure of a table including column names, types, and keys.