B. embedded SELECT statement
D. None of the above is correct.
Answer: Option C
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
SQL Server does not support the BEFORE trigger.
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.