Please read this before using the solutions.
Independent resource. GTU MCA RDBMS Hub is an independent educational website. It is not an official website of Gujarat Technological University (GTU) and is not endorsed by GTU. Names such as GTU, MCA and the subject code are used only to describe the syllabus the material relates to.
Verify before you submit. Syllabi, practical lists and lab instructions change. Always compare questions and solutions with the current official syllabus PDF and follow your instructor's instructions. The questions on this site are copied from the GTU MCA RDBMS syllabus effective from 2024-25; most table data is sample data and is marked as such.
Use for learning. The solutions are meant to help you understand SQL and PL/SQL. Type and run the code yourself, change the data, and make sure you can explain every line in your viva. Submitting copied work may break your institute's academic integrity rules.
No warranty. The content is provided as is, without any warranty of correctness or fitness for a particular purpose. Expected outputs were computed from the sample data in each article; your results can differ with other data, Oracle versions or session settings.
Trademarks. Oracle, SQL*Plus and SQL Developer are trademarks of Oracle Corporation and/or its affiliates.
Independent educational resource for GTU MCA students — not an official GTU website. Disclaimer