n Triggers, BEFORE means before the changes are made in memory but after the changes are permanently saved to disk. Select one: a. True b. False

ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following  statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%

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

In SQL code: Create a PL/SQL block to retrieve the name of each employee from the EMPLOYEE table and print the first initial of each name on the screen, incorporating an INDEX BY table.

in sql The keyword that you would use to grant an object privilege to all database users is:                                     Select one: a. PUBLIC  b. ADMIN c. ALL d. GRANT

In what situations might the SOUNDEX function be useful in SQL when querying text data?

Branch Table BranchNo Name B001 Location 567, Kileleshwa 890, Karen 894, Rongai Kileleshwa BO02 Karen ВООЗ Rongai i). Write appropriate SQL statement to display all staff who work at BranchNo "BO02"

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

SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings representing students names, and 2 integers representing the marks they received in DBS311. The function will determine which student had the higher mark and return the name of the student. If the marks were the same, then return the word "same" and return "error" if an error occurs or the calculation can not be determined.