Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with a and b This question assumes the following relational schemas in the context of Kafka University: Student StuID, Lname, Fname, Address, DOB,

image text in transcribed

need help with a and b

This question assumes the following relational schemas in the context of Kafka University: Student StuID, Lname, Fname, Address, DOB, Phone, MajorID, DeptID) Primary Key: StuID Foreign key: MajorID refers to MajorID in Major Major (MajorID, MajorDesc) Primary Key: MajorID You have been given the following PL/SQL block: V DOB Student.DOB/Type; V-SID Student. StuIDType; BEGIN V-DOB :=&StudentDOB; SELECT StuID INTO V_SID FROM Student WHERE DOBV_DOB; END (a) (2 marks) Name the two different types of variables that have been used in the above PL/SQL block. Describe these variable types with one characteristic each (b) (2 marks) Discuss all the error conditions that you may come across as a result of the execution of this anonymous block. Add an appropriate exception handling section to the block in order to handle such errors

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

gpt 3 6 9 . .

Answered: 1 week ago