Which of the following is the correct syntax for a left outer join? Select column-list from T1 outer join T2 left where join-condition; Select column-list from T1 outer left T2 join where join-condition; Select column-list where left T1 = T2; Select column-list from T1 left outer join T2 ON join-condition;
mcq:
Which of the following is the correct syntax for a left outer join?
|
Select column-list from T1 outer join T2 left where join-condition; |
||
|
Select column-list from T1 outer left T2 join where join-condition; |
||
|
Select column-list where left T1 = T2; |
||
|
Select column-list from T1 left outer join T2 ON join-condition; |
2
Which of the following statements is NOT CORRECT about stored procedures?
|
They can be invoked within triggers |
||
|
They can be invoked within other procedures |
||
|
They can be shared by multiple programs |
||
|
They use the RETURN statement |
3
Which of the following statements is NOT TRUE with respect to PL/SQL cursors?
|
%ISOPEN is used to make a cursor ready for processing |
||
|
%FOUND returns true if the last FETCH returned a row when a cursor is closed |
||
|
%NOTFOUND returns true if the last FETCH did not return any row. |
||
|
%FOUND returns true if the last FETCH returned a row when a cursor is open |
4.
A relationship between entity supertype and entity subtype is known as ______
|
Partial participation relationship |
||
|
IS-A relationship |
||
|
M : N relationship |
||
|
Total participation relationship |
5.
-
4NF is used to handle______
Transitive dependency
Candidate dependency
Partial dependencies
Multivalued dependency
Step by step
Solved in 2 steps
