what does the % operator return in my sql when using numeric value? a) the additive inverse of a value b) the reminder when dividing one value by another c) the quotient when dividing one value by another d) the absolute value of a value

What is the most efficient way to access data when you have multiple tables? a) Use the VLOOKUP function to create formulas to add data from other tables b) Use an application like Microsoft Query to consolidate the data into one table c) Create relationships between tables d) Use Power Query to consolidate the data into one table

Which clause of a SQL Select statement is required if we want to display aggregate data by category such as total population by state, department, etc.?   Question 40 options:   1)  GROUP BY   2)  ORDER BY   3)  WHERE   4)  FROM   5)  SELECT

Which of the following is NOT true about PL/SQL constants?       The CONSTANT declaration does not require data type.     A constant contains a value that cannot be changed after being declared.     A constant is declared using the CONSTANT keyword.     A CONSTANT declaration must contain an initial valu

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

In PL/SQL, which of the following variable type is used to declare a record?     %ROWTYPE     %TYPE     %RECORDTYPE     %TYPEROW

the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id      &contribution_amount If employee salary is in between $1000-$3999 And if  employee's contribution amount is less than $100 then company match $100                   if  employee's contribution amount is greater than 100 but less than $200 then company match $75                  if  employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if  employee's contribution amount is less than $100 then company match $150                   if  employee's contribution amount is greater than 100 but less than $200 then company match $100                  if  employee's contribution amount is greater than $200 then company match $75  $7000-$12000And if  employee's contribution amount is less than $100 then company match $200                   if  employee's contribution amount is greater than…

Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.