Register

Recent questions tagged goclasses-da-dpp-day-289

0 0 votes
1 1 answer
59
59 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
The database contains relations $\mathrm{animals}$ and $\mathrm{visits}$, with $\mathrm{aid}$ identifying an animal.Which SQL query returns the names of animals that visi...
User Avatar
0 0 votes
1 1 answer
45
45 views
GO Classes DPP | GATE CS, DA | DBMS | Evaluation Order
Conceptually, in which order does SQL process the following three operations?$\mathrm{WHERE}\rightarrow\mathrm{HAVING}\rightarrow\mathrm{GROUP\ BY}$ $\mathrm{WHERE}\right...
User Avatar
0 0 votes
1 1 answer
52
52 views
GO Classes DPP | GATE CS, DA | DBMS | SQL
The $\mathrm{Employee}$ relation contains:$$\begin{array}{|c|c|c|c|} \hline \mathrm{EmployeeNo} & \mathrm{Name} & \mathrm{DateOfBirth} & \mathrm{Department} \\ \hline 000...
User Avatar
0 0 votes
1 1 answer
47
47 views
GO Classes DPP | GATE CS, DA | DBMS | GROUP BY & ORDER BY
The relation is:$\mathrm{Midterm}(\mathrm{ClassName},\mathrm{SubjectName},\mathrm{StudentNo},\mathrm{Name},\mathrm{Score})$.The objective is to calculate the average scor...
User Avatar
0 0 votes
1 1 answer
63
63 views
GO Classes DPP | GATE CS, DA | DBMS | WHERE vs HAVING
The relation $\mathrm{ExamResult}$ stores examination records for the previous three years:$\mathrm{ExamResult}(\mathrm{StudentNo},\mathrm{ExamDate},\mathrm{Score},\mathr...
User Avatar
To see more, click for the full list of questions or popular tags.