to Retrieve all data from exam table

join on the tables is a query that merges the data from two different tables.

We can use Aliases instead of complete table name

We Can use Aliases also function with the JOIN keyword

The default form of JOIN

Return rows where there is a match in both tables

RIGHT OUTER JOIN only includes matching rows from the right side of the table

RIGHT OUTER JOIN only includes matching rows from the left side

All rows in a ....... OUTER JOIN are included in both tables

view is a virtual table you can dynamically generate using a previously saved query

View advantage is

After establishing the view, you Can't use it in a SELECT query's

WITH LOCAL CHECK OPTION, which rejects any insert or update that does not fulfill the conditions of the WHERE clause

database trigger is a stored procedure that is automatically called whenever a specific event happens in the database.

Authentication refers to the process of identifying a user.

What is the purpose of a trigger in a database?

Which join type returns all rows from the left table and the matching rows from the right table, and fills in NULL values for non-matching rows on the right table?

Which join type returns all rows from the left table and the right table, regardless of whether they have matching values?

Which of the following scenarios is an appropriate use case for a trigger in a database?

What is a foreign key in a database?

Which of the following modifications can be performed using the ALTER TABLE statement?