Question 76
What is the result of the CROSS JOIN (Cartesian Product) between Table A (5 rows) and Table B (4 rows)?
Cross Join combines every row of Table A with every row of Table B, yielding 5 $\times 4 = 20$ total tuples.
What is the result of the CROSS JOIN (Cartesian Product) between Table A (5 rows) and Table B (4 rows)?
Cross Join combines every row of Table A with every row of Table B, yielding 5 $\times 4 = 20$ total tuples.
Which type of lock allows multiple transactions to read a database item simultaneously but prevents writes?
Shared (Read) locks are compatible with other Shared locks, allowing concurrent read operations but preventing write locks.
Which lock mode grants exclusive read and write access on a database item to a single transaction?
An Exclusive (X) lock prevents any other transaction from acquiring shared or exclusive locks on the locked data item until released.
Which normal form requires that a table is in 1NF and contains no partial dependencies?
Second Normal Form (2NF) mandates 1NF compliance plus the elimination of partial dependencies (where a non-prime attribute depends on part of a composite candidate key).
What constitutes a partial dependency in database normalization?
A partial dependency occurs when a non-key attribute relies on only a part of a composite primary key rather than the entire key.