.......... function is used to count the number of rows, but it counts all rows in a table including the rows with NULL values, whereas ............. counts only the non-NULL values in the specified column.

LIKE operator matchs a pattern ( case insensitive)

Which of the following should be used to find the mean of the salary?

Text requier double quotation mark

ALTER modifies table structure

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.