Question 1 |
Consider the following table named Student in a relational database. The primary
key of this table is rollNum.
\begin{array}{|c|c|c|c|} \hline \\ rollNum&name&gender&marks \\ \hline 1&Naman&M&62\\ \hline 2&Aliya&F&70 \\ \hline 3&Aliya &F&80 \\ \hline 4&James&M&82\\ \hline 5&Swati&F&65\\ \hline \end{array}
The SQL query below is executed on this database.
The number of rows returned by the query is ______
\begin{array}{|c|c|c|c|} \hline \\ rollNum&name&gender&marks \\ \hline 1&Naman&M&62\\ \hline 2&Aliya&F&70 \\ \hline 3&Aliya &F&80 \\ \hline 4&James&M&82\\ \hline 5&Swati&F&65\\ \hline \end{array}
The SQL query below is executed on this database.
SELECT *
FROM Student
WHERE gender = 'F' AND
marks > 65;
The number of rows returned by the query is ______
0 | |
1 | |
2 | |
3 |
Question 1 Explanation:
Question 2 |
Consider the relational database with the following four schemas and their respective instances.

The number of rows returned by the above SQL query is ___

The number of rows returned by the above SQL query is ___
1 | |
2 | |
4 | |
8 |
Question 2 Explanation:
Question 3 |
The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to which the employee is assigned. Each employee is assigned to exactly one department.
\textsf{emp($\underline{\textsf{empId}}$, name, gender, salary, deptId)}
Consider the following SQL query:
\textsf{emp($\underline{\textsf{empId}}$, name, gender, salary, deptId)}
Consider the following SQL query:
select deptId, count(*)
from emp
where gender = "female" and salary > (select avg(salary)from emp)
group by deptId;
The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary ofemployees in the department | |
employees in the company | |
female employees in the department | |
female employees in the company |
Question 3 Explanation:
Question 4 |
The SQL query
returns the following:
SELECT columns
FROM TableA
RIGHT OUTER JOIN TableB
ON A.columnName = B.columnName
WHERE A.columnName IS NULL
returns the following:
All rows in Table B, which meets equality condition above and, none from Table A which meets the condition. | |
All rows in Table A, which meets equality condition above and none from Table B, which meets the condition. | |
All rows in Table B, which meets the equality condition | |
All rows in Table A, which meets the equality condition |
Question 4 Explanation:
NOTE: Question is excluded from the evaluation due to ambiguity.
Click here for detail solution by gateoverflow
Click here for detail solution by gateoverflow
Question 5 |
Properties of 'DELETE' and 'TRUNCATE' commands indicate that
After the execution of 'TRUNCATE' operation, COMMIT, and ROLLBACK statements cannot be performed to retrieve the lost data, while 'DELETE' allow it | |
After the execution of 'DELETE' and 'TRUNCATE' operation retrieval is easily possible for the lost data | |
After the execution of 'DELETE' operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data, while TRUNCATE do not allow it | |
After the execution of 'DELETE' and 'TRUNCATE' operation no retrieval is possible for the lost data |
Question 5 Explanation:
There are 5 questions to complete.
Ques 15; C should be the answer. Kindly check.
As per the ISRO Answer key option A and C are correct, but None of these are correct. See the detail Solution page now.
In Q-27 answer is option C
Answer Updated.