Which type of relationship is represented by a foreign key in a relational database? MCQ with Answer and Explanation

Explanation:
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.

Explanation:
A Foreign Key constraint enforces referential integrity, preventing updates or deletions that would leave orphaned child records pointing to non-existent parent rows.

Explanation:
Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.