in sql The PL/SQL block starts with the _____ section. Select one: a. DECLARE b. BEGIN c. IS d. OPEN

INFO 2303  Database Programming Assignment  : PL/SQL Practice   Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL.   Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.

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

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.

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

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

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

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