plz help  in sql  You can modify data in a view if the view contains a group function Select one: True 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%

Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145

IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the where clause is required. Select one: True False

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

What are some common uses for the STRING_AGG function in SQL?

If we implement a queue using an array where we treat the array as if its two ends are "taped together", we call that a linear array. O True False

in sql  The ALTER SEQUENCE statement can be used to:                                             Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d.  Change the amount a sequence increments each time a number is generated

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.

Database sql 1-Write the syntax to create an object table called people using people_type