An outer join is used to:
Return records which have no direct match
Return records which have direct match
Return all the records
None of the above
____________ is the outer join operator.
(+)
(-)
(*)
+
____________ is used to join a table to itself.
Selfjoin
Outerjoin
innerjoin
equijoin
A null is the same as zero or a blank space.
True
False
What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;
1112
1111.93
1111.93412
1111.934
What does the MOD Function do?
It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.
Duplicate values are eliminated by which keyword
Duplicate
Distinct
Remove
Delete
The two types of subqueries are:
Single-row subquery, Double-row subquery
Double-row subquery, Multiple-row subquery
Multiple-row subquery
Single-row subquery and Multiple subquery
Single-row subquery returns:
Only one row
Two rows
Zero rows
There is no such subquery
What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);
It gives the name and marks of all the students.
It does not return anything.
It shows an error saying” INVALID SYNTAX ERROR”
It shows an error saying” Single-row subquery returns more than one row