Current Papers
CS405 - CS405
11 Jun 2026 at 11:11 AM
*CS405 MIDTERM* *11\JUNE\2026* *S\Q* *Q1* WHAT DO YOU MEAN BY FORIEGN KEY IN A RELATION?(FROM PAST REVIEWS) *Q2* Output of the folloWING?(SAME AS ON PAGE 24) DECLARE I number (10):=0; Name va…
*CS405 MIDTERM* *11\JUNE\2026* *S\Q* *Q1* WHAT DO YOU MEAN BY FORIEGN KEY IN A RELATION?(FROM PAST REVIEWS) *Q2* Output of the folloWING?(SAME AS ON PAGE 24) DECLARE I number (10):=0; Name varchar2(10); DOB date:=sysdate; Cost real:=390; PI CONSTANT NUMBER := 3.141592654; BEGIN Dbms_output.put_line (I || name || dob || PI); END; *L\Q* *Q1* Suppose you have table students as (student_name , grade , age. Sort the table first by grade in descending order and then sort it by age in ascending order. Explain the behaviour of the query on the table.(FROM CURRENT REVIEWS) *Q2* Suppose you have students table as(studentID, Name , address , class).write PL\SQL block to check if the total no of studnts is even.if so then display message as 'Even no of students' .If the total no of stu