Recent questions tagged sql

2 votes
1 answer
93
Table employees has $10$ records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statementSELECT COUNT(*)FROM EMPLOYEEWHERE SALARY ALL (SELECT SALARY FROM...
1 votes
2 answers
94
Which type of Statement can execute parameterized queries?PreparedStatementParameterizedStatementParameterizedStatement and CallableStatementAll kinds of Statements
1 votes
1 answer
95
'AS' clause is used in SQL forSelection operationRename operationJoin OperationProjection Operation
22 votes
3 answers
99
Consider a relational database containing the following schemas.$$\overset{\text{Catalogue}} {\begin{array}{|c|c|c|} \hline \underline{\text{sno}} & \underline{\text{pno}...
1 votes
1 answer
103
Which of the following statements are DML statements?Update [tablename]Set [columnname]=VALUEDelete [tablename]Select * from [tablename] a and ba and da, b and cb and c
1 votes
3 answers
104
Class(name, meets_at, room, fid)Faculty(fid, fname, deptid)Find the names of faculty members who teach in every room in which some class is taught
0 votes
0 answers
108
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
0 votes
0 answers
110
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not workingThe queries are The output are
0 votes
1 answer
113
0 votes
0 answers
115
From where practice SQL query questions of GATE level , apart from previous year questions.