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

Which of these data types is an approximate numeric?

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

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

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

What is the result of this query? SELECT 'abc\ def' AS Result;

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?

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

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

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 does a RIGHT JOIN ensure?