Current Papers

Midterm Spring 2026
1,411 views
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

View Full Paper
Share
Shared by DANYAL 1 month ago
© 2026 VUCTN. All rights reserved. v1.0.0