Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 :

SQ1 : Select *

    From R Full Join S

    On R.B = S.B;

SQ2 : Select *

    From R Inner Join S

    On R.B = S.B;

The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by :

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is :

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name)

Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX = ‘M’ group by DEPT_Name having avg (Marks)>SELECT avg (Marks) from STUDENT. It Returns the Name of the Department for which :

An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is :

Match the following :

Codes :

Given query:

select s.rollno, s.name

from student s

where EXISTS (select c.courseid from course c Where c.deptno=5 and

EXISTS (select e.* from enrollemnt e

where e.courseid = c.courseid and

e.rollno = s.rollno));

Which one of the following statements is correct with respect to the given query?

Which of the following queries would retrieve the dept id and name of all the departments that are such that the total of the credits of all the offered courses by the department is strictly greater than 40?

Which of the following queries would compute, for each department, the total credits of all the courses offered by the department?

Given query: select s.rollno from students where s.sex = ALL (select f.sex from professor f where f.empid = s.advisor)

Consider the following statements about the given query that retrieves the set of all students whose gender is same as the gender of their advisor:

S1. It has a correlated subquery

S2. It has an uncorrelated subquery

S3. If we replace ALL by ANY in the above query, its result will be different

S4. If we replace ALL by ANY in the above query, its result will be same.

Identify all the statement that are TRUE:

Match the following -

Which of the following is NOT a Structured Query Language Data type?

Consider a table Employee(EmpID, TeamID), where the column EmpID (ID of an employee) is the primary key. The column TeamID denotes the team ID of the team of which the employee is a member. TeamID is a NOT NULL column.

We want to display the size of the team (denoted as TeamSize) in which each employee is a member by using SQL. As an example, the desired output for the given Employee table is also shown in tabular form.

Which of the following is/are correct?

Employee
 

Output
 

Let Account be a relation as shown. 

                                                                                                         Account

Consider the given SQL query.

SELECT AccNo FROM Account AS A 

WHERE (SELECT COUNT(*) FROM Account AS B  

WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)  

FROM Account AS C WHERE A.Balance > C.Balance)

The number of rows returned by the SQL query is __________ . (Answer in integer)