08.08.2025

What is the result of the following query?

SELECT studname FROM college WHERE marks > SOME (SELECT marks FROM student WHERE SECTION = 'c');

• The query gives all the studnames for which marks are greater than all the students in section c

• The query gives all the studnames for which the marks are greater than at least on student in section c

• The query gives all the studnames for which the marks are less than all the students in section c

• The query is syntactically incorrect

What is a correlated sub-query?

• a) An independent query that uses the correlation name of another independent query.
  

• b) A sub-query that uses the correlation name of an outer query

• c) A sub-query that substitutes the names of the outer query

• d) A sub-query that does not depend on its outer query’s correlation names

Observe the following query and choose the correct option

SELECT DISTINCT name FROM student WHERE ID IS NOT NULL;

• a) The query is syntactically wrong

• b) The query gives all the possible student names where a finite value exists for ID

• c) The query gives the names of the students that have a null ID and it also excludes identical names

• d) The query gives the student names where a finite value exists for ID and it excludes identical names

What will be the result of the following query?

(SELECT studentid FROM student WHERE SECTION = 'c') EXCEPT (SELECT studentid FROM student WHERE roll <10);

• a) All the values of the studentid for which section is c and roll < 10

• b) All the values of the studentid for which section is c and roll > 10

• c) All the values of the studentid for which section not c and roll < 10

• d) All the values of the studentid for which section not c and roll > 10

The join operations that do not retain mismatched tuples are called as _________ operations

• a) outer join

• b) natural join

• c) full outer join

• d) inner join

If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?

• a) They are given null values

• b) They are given a random value

• c) The user is asked to enter data

• d) The query is declared invalid by the compiler

The _______ statement causes the statements to undo all the updates performed on the transaction

• a) Undo work

• b) Rollback work

• c) Commit work

• d) Replace work

From the following table, write a SQL query to find the third-highest sale. Return sale amount.

• SELECT DISTINCT sale_amt AS SecondHighestSale FROM salemast ORDER BY sale_amt DESC LIMIT 1 OFFSET 1;

• SELECT sale_amt AS SecondHighestSale FROM salemast ORDER BY sale_amt DESC LIMIT 1 OFFSET 1;

• SELECT DISTINCT sale_amt AS SecondHighestSale FROM salemast ORDER BY sale_amt ASCE LIMIT 1 OFFSET 1;

• None of the above

What will be the output of the following query?

SELECT COUNT(*) FROM employees WHERE department = 'HR' AND salary > 50000;

• A. Returns the number of employees in HR with salary greater than 50000

• B. Returns the total number of employees in HR

• C. Returns the salary of employees in HR

• D. Returns all employee details

Which SQL statement is used to remove duplicate rows from the result set?

SELECT _____ department FROM employees;

• A. DISTINCT

• B. UNIQUE

• C. DELETE

• D. REMOVE