View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 50 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Question No: 1 of 17
Which of the following option is correct? 
Options:
  1. JOINS can be used to fetch data from multiple tables even if they do not have a common column
  2. JOINS cannot be used to fetch data from multiple tables when they do not have a common column
View Answer/Explanation:
a
Explanation:
Example1:-A CROSS JOIN or CARTESIAN JOIN does not require a common column to be present in both the tables Example2:-The following query fetches data from two tables using (Non-Equi Join) where the two tables do not have a common column Select E.Name, E.Salary, S.Grade FROM Employee e, Salgrade s WHERE E.Salary BETWEEN s.losal AND s.halis

Question No: 2 of 17
A condition is referred to as _____: 
Options:
  1. Join in SQL
  2. Join condition
  3. Both
  4. None of the mentioned
View Answer/Explanation:
c
Explanation:

Question No: 3 of 17
A_____ is a query that retrieves rows from more than one table or view: 
Options:
  1. Start
  2. End
  3. Join
  4. All of the mentioned
View Answer/Explanation:
c
Explanation:

Question No: 4 of 17
Which are the join types in join condition: 
Options:
  1. Cross join
  2. Natural join
  3. Join with USING clause
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:

Question No: 5 of 17
Which product is returned in a join query have no join condition 
Options:
  1. Equijoins
  2. Cartesian
  3. Both
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:

Question No: 6 of 17
Which is a join condition contains an equality operator: 
Options:
  1. Equijoins
  2. Cartesian
  3. Both and b
  4. None of the mentioned
View Answer/Explanation:
a
Explanation:

Question No: 7 of 17
Which join refers to join records from the write table that have no matching key in the left table are include in the result set: 
Options:
  1. Left outer join
  2. Right outer join
  3. Full outer join
  4. Half outer join
View Answer/Explanation:
b
Explanation:

Question No: 8 of 17
Which operation are allowed in a join view: 
Options:
  1. UPDATE
  2. INSERT
  3. DELETE
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:

Question No: 9 of 17
Which view that contains more than one table in the top-level FROM clause of the SELECT statement: 
Options:
  1. Join view
  2. Datable join view
  3. Updatable join view
  4. All of the mentioned
View Answer/Explanation:
c
Explanation:

Question No: 10 of 17
In which case would you use a FULL OUTER JOIN? 
Options:
  1. Both tables have NULL values.
  2. You want all unmatched data from one table.
  3. You want all matched data from both tables.
  4. You want all unmatched data from both tables.
View Answer/Explanation:
d
Explanation:

  1