VU current papers 2026: what came in the exam

Mcqs tricky thy kxh files me se thy kxh handsout se thy 4 short question thy Inner Ek scenario tha btya tha kon sa anomaly use huwa hai 3NF ka question tha Ek mjy yad nae Long me ek question different BETWEEN and %wildcard Ek table diya tha dr patient wala usko sequence se likhna thaMcqs tricky thy kxh files me se thy kxh handsout se thy 4 short question thy Inner Ek scenario tha btya tha kon sa anomaly use… See more See less

السلام علیکم Final Term Exam CS-312 6:30 PM MCQs asaan thae conceptual thae handouts and lectures ager liye phir bohot easy Mcqs: 1. 1ST NORMAL FORM 2. 2ND NORMAL FORM 3. 3RD NORMAL FORM 4. DML (insert, update etc) 5. DDL ( create...... Etc) 6. Syntax of select 7. Anomolies mai b 2 3 thae ya zaida yad ni aa rha. 3no types uski. Bohot easy 8. Index on table ka syntax 9. Lock wala b tha smth.. 10. 2 mcqs quiz file 4 sy b aye thae aik. Ka answer {group by} tha aik ka {between} 11. IN operation in sql works like or operator.. Aisa tha mcqs (IN) answer tha Short questions : 1. Index wala tha.. Theory.. Briefly explain index. 2. How a relation can be converted into 2nd normal form ? Write charcateristics 3. Write sql code tha students sy related.. Students ka cgpa 3.5+ ho ore baki Bhul gia statement 4. Anomoly ka tha ky 2 students ny cs802 course rakha phir drop krdiya toh ab jab hum data delete kren gy toh konsi anamoly occur hogi.. Or konsa data lost hoga.. Vo b likhen.. Long questions : 1. What is short circuit key and how it can be inserted in a relationship which have multiple levels of master table in data Base with example Questions 2: It was ky write sql code retrieval of rows keliye.. Where salary greater then 40000 And User name end with either garry or chin. [lastname] (or ki jagah kuch or tha wahan bhul gia) Question no 3: Write sql code to view data from student table.. Stu_id stu_name where city is lahore.. Neechy table diya hua tha.. Sql code likhna thaالسلام علیکم Final Term Exam CS-312 6:30 PM MCQs asaan thae conceptual thae handouts and lectures ager liye phir bohot easy Mcqs… See more See less

MCQs were mixed from different chapters: Normalization, Logical Operators, GROUP BY, BETWEEN, Views, Sequences, Indexes, etc. Short Questions included Anomalies and a query using LIKE with wildcard characters. Long Questions included: Creating a View Deadlock scenario Update Anomaly with an example Rules of 3NF Overall, the paper was mixed from the whole syllabusMCQs were mixed from different chapters: Normalization, Logical Operators, GROUP BY, BETWEEN, Views, Sequences, Indexes, etc… See more See less

Assalam o alaikum warahmatulahi wabarakatuhu Final Term ppr CS-312 8:00 AM The MCQs were very easy If you have prepared the handouts well, you'll find them manageable 😌 Short questions : 1. D/W inner 2. How a relation can be converted into third normal form ? Identify different rules applied on the relation for this purpose. 3. Why calculated values are stored in database table in denormalization? 4. Consider following table Table : Student StID 1 , 2 , 3 , 4 , 5 StName Ali , Shahed , Naila , Ahmed , Qaiser CI Name MSC , BCS , MCS , MBA , BBA Gender M , M , F , F , M DELETE FROM Student where StID = 5 ; INSERT into student values ( ' 6 ' , ' Imran ' , ' MCS ' , 'M' ); You are required to provide resultant table after execution of following SQL queries. Long questions : 1. What is short circuit key and how it can be inserted in a relationship which have multiple levels of master table in data Base with example don't remember Questions 2 and 3 exactly, but one question required converting a given query into a table It was something like: Product (Product_ID, Company_ID, Name, Quantity) There was also one long question where a table was provided, and we had to write an SQL query to create a view from that table Overall, the paper was very easy, Alhamdulillah Best wishes to all of you, and please remember me in your prayersAssalam o alaikum warahmatulahi wabarakatuhu Final Term ppr CS-312 8:00 AM The MCQs were very easy If you have prepared the… See more See less

mcqs handout se thy aur Kuch quiz waly bhe thy long mn code rule btana tha konsa hai aur significanse kr na tha donu long mn ... aur short Q1.Layers of 3 tier Q2.Types of interviews and there sub typesmcqs handout se thy aur Kuch quiz waly bhe thy long mn code rule btana tha konsa hai aur significanse kr na tha donu long mn … See more See less

Today’s Paper Update 💡 Overall Paper Review: Mostly MCQs from Handouts – especially topics like Normalization, De-normalization, and Views. MSQs were easy to moderate level. ✏️ Short Questions: 🔹 Question from Views 🔹 One question on SQL Table Creation 🖋️ Long Questions: 🔹 Write an SQL Query (practical-based) 🔹 Convert a relation from 2nd Normal Form to 3rd Normal Form 🔹 Another SQL-based query question 📌 Tip: Focus on handout-based definitions, normalization steps, and basic SQL commands (especially CREATE, SELECT, JOIN, etc.)Today’s Paper Update 💡 Overall Paper Review: Mostly MCQs from Handouts – especially topics like Normalization, De-normalization… See more See less