In the PL/SQL block shown below, determine the values for each of the following cases, after the block is run.DECLARE    customer VARCHAR2(50) := ‘APPLE’;    credit_rating VARCHAR2(50) := ‘EXCELLENT’;BEGIN    DECLARE       customer NUMBER(7) := 201;       name VARCHAR2(25) := ‘GOOGLE’;    BEGIN       credit_rating :=’GOOD’; END;a. The value of customer in the nested block is:b. The value of name in the nested block is:c. The value of credit_rating in the nested block is:d. The value of customer in the main block is:e. The value of name in the main block is:f. The value of credit_rating in the main block is:

Consider the following anonymous block:  BEGIN   INSERT INTO countries (id, name)  VALUES (‘XA’, ‘Xanadu’);  SAVEPOINT XA;   INSERT INTO countries (id, name)  VALUES (‘NV’,’Neverland’);  COMMIT;   ROLLBACK TO XA; END; What happens when the block of code finishes?

What keyword is used to check multiple conditions with an IF statement?

Which of the following variable declarations are valid?

A variable is declared as: DECLARE   v_temp employees.last_name%TYPE; BEGIN Which of the following is a correct use of the INTO clause?

What is the main purpose of a composite data type in PL/SQL?

Which of the following developed the psychosexual stages of development?

Counselors may conduct research as a master’s-level practitioner. 

Clients have autonomy within the counseling relationship. 

CBT was established by Ellis.