What does a RIGHT JOIN ensure?

Given a table with the following structure, which query returns all student names with the highest grade? CREATE TABLE Students (StudentName varchar(50),Grade int );

What is the result of an INNER JOIN between table1 and table2?

To remove all of the content from the Students table but keep the schema, which statement should you use?

You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

What is the result of this query? SELECT 123+'123' AS Result;

Which data type will most efficiently store a person's age in years?

What is the result of this query? SELECT 1 / 2 AS Result;

You need to remove all data from a table name Products. Which query fully logs the removal of each record?

Which of these data types is an approximate numeric?

Which is the best approach to update the last name of the student Donette Figgins to Smith