Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. JOINS can be used to fetch data from multiple tables even if they do not have a common column
b. JOINS cannot be used to fetch data from multiple tables when they do not have a common column
Reveal Answer
Options:
a. Join in SQL
b. Join condition
c. Both
d. None of the mentioned
Reveal Answer
Options:
a. Cross join
b. Natural join
c. Join with USING clause
d. All of the mentioned
Reveal Answer
Options:
a. Equijoins
b. Cartesian
c. Both
d. None of the mentioned
Reveal Answer
Options:
a. Equijoins
b. Cartesian
c. Both and b
d. None of the mentioned
Reveal Answer
Options:
a. UPDATE
b. INSERT
c. DELETE
d. All of the mentioned
Reveal Answer
Options:
a. Join view
b. Datable join view
c. Updatable join view
d. All of the mentioned
Reveal Answer
Options:
a. Both tables have NULL values.
b. You want all unmatched data from one table.
c. You want all matched data from both tables.
d. You want all unmatched data from both tables.
Reveal Answer
Options:
a. Left Join
b. Self-Join
c. Natural join
d. Left Join
Reveal Answer
Options:
a. Left Join
b. Left Outer Join
c. Right Outer Join
d. Cross Join
Reveal Answer
Options:
a. Select * FROM Table1 T1 CROSS JOIN Table1 T2;
b. Select * FROM Table1 T1 ALL CROSS JOIN Table1 T2;
c. Select * FROM Table1 T1,Table1 T2;
d. Select * FROM Table1 T1 CROSS Table1 T2;
Reveal Answer
Options:
a. Select [List] from [Table A] A inner join [Table B] B on A.value=B.value
b. Select [List] from [Table A] A full outer join [Table B] B on A.value=B.value where A.value is null or B.value is null
c. Select [List] from [Table A] A right join [Table B] B on A.value=B.value where A.value is null
d. Select [List] from [Table A] A full outer join [Table B] B on A.value=B.value
Reveal Answer
Bestdotnet google plus