Skip to content
Gallery
PD173: Java Selenium
PD173 - Java Selenium Training
Unit Test 1 : HTML CSS JS
Unit Test 2 : SQL
Unit Test 3: Java OOPS
Unit Test 4: Testing
Full Day Exercise Challenge
Project and Assessment
Final Observations
Classwork Score
Share
Explore

Unit Test 2 : SQL

Date: 02.01.2025
Subjects: SQL
Full Marks: 80 (50 Marks Scenario based MCQ + 30 marks Practical)

This test is designed to evaluate your ability to analyze, troubleshoot, and enhance SQL queries in realistic, scenario-driven environments. The focus is on practical application rather than theoretical knowledge, ensuring you can handle real-world tasks such as data validation, performance analysis, and automation through triggers.

Question Style and Approach:

Scenario-Based Problems: Each question simulates a real-world scenario where SQL is applied to solve business or technical challenges. These may involve tasks like generating reports, validating data, automating processes, and ensuring system integrity.
Incomplete or Flawed Queries: Many questions will present SQL queries that work partially or have subtle issues. Your task will be to identify and correct errors, enhance the code, or adjust the logic to meet the requirements.

Expectations from Participants:

Precision and Attention to Detail:
Minor errors in SQL (e.g., misordered conditions or missing filters) can lead to inaccurate data. Read the queries carefully and break down the logic step by step.
Real-World Problem Solving:
Treat each scenario as if you are part of a database management or QA team. Think about how the query affects reporting, automation, or operational efficiency.
Code Enrichment:
Many questions will require adding new logic without breaking existing functionality. Focus on incremental improvements rather than rewriting queries from scratch.
Optimized Solutions:
While there may be multiple ways to solve a problem, the best solutions prioritize efficiency and clarity. Avoid overly complex subqueries or unnecessary joins unless required.

Question Paper:
SQL-Question Paper.pdf
485.3 kB
⁠
⁠

info
The following scoresheet accounts for participants who undertook both MCQ and Practical. The scoresheet for the rest 12 participants (who was released on 02.01.2025) are given separately below.
Unit Test 2 : SQL Scores
Name
MCQ Score
Practical Score
Total Score
Percentage
A A Logi Priya
38
25
63
78.75%
Abisheknarayanan K
40
25
65
81.25%
Akash Anjamani
33
26
59
73.75%
Areef L
48
25
73
91.25%
Christy Philo
37
24
61
76.25%
Deepika R
39
25
64
80%
Dhanalakshmi . H
35
25
60
75%
Girija S
44
25
69
86.25%
Jothika K
38
25
63
78.75%
K Manikandan
41
26
67
83.75%
Keerthana A
44
28
72
90%
Madhumitha T
41
26
67
83.75%
Mythili G
39
24
63
78.75%
Naveen M
46
25
71
88.75%
Pooja R
39
25
64
80%
Prasitha Panneer
30
24
54
67.5%
Priyadharshini
42
26
68
85%
R Nisha
40
26
66
82.5%
Rama Subramanian P
36
28
64
80%
Ramya V
40
28
68
85%
S Usha Nandhini
40
26
66
82.5%
Sabiq Ahmed J
44
27
71
88.75%
Siva Balaji R
38
27
65
81.25%
Sujeetha K
40
25
65
81.25%
Tamilarasi Amalraj
32
24
56
70%
Thalapathi Manikandan Ganesan
36
25
61
76.25%
Vignesh Gurunathan
44
25
69
86.25%
Vigneshwaran U
34
25
59
73.75%
Vinupriya Selvakumar
36
26
62
77.5%
Yugesh S
40
25
65
81.25%
There are no rows in this table
⁠
Scoresheet for MCQ Participants:
Sr
Name
Marks Scored
1
Aswin Kumar
Absent
2
Archana P
48/50 (96%)
3
D Swetha
30/50 (60%)
4
Deepak M
29/50 (58%)
5
Hema D
36/50 (72%)
6
Kaviya P
40/50 (80%)
7
Mohammed Thahir H
40/50 (80%)
8
Mugunth Narayan G R
35/50 (70%)
9
Muralidharan Ramachandran
36/50 (72%)
10
Nithishkumar Murugesan
36/50 (72%)
11
Raja R
40/50 (80%)
12
Sakthi Marimuthu
34/50 (68%)
There are no rows in this table
⁠


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.