Sail E0 Webinar

MCQs

Total Questions : 9
Question 1. What type of join is needed when you wish to include rows that do not have matching values?
  1.    Equi-join
  2.    Natural join
  3.    Outer join
  4.    All of the mentioned
 Discuss Question
Answer: Option C. -> Outer join


Outer joinAn outer join does not require each record in the two joined tables to have a matching record.


Question 2. Which of the join operations do not preserve non matched tuples.
  1.    Left outer join
  2.    Right outer join
  3.    Inner join
 Discuss Question
Answer: Option C. -> Inner join


Inner joinINNER JOIN: Returns all rows when there is at least one match in BOTH tables


Question 3. The____condition allows a general predicate over the relations being joined.
  1.    On
  2.    Using
  3.    Set
  4.    Where
 Discuss Question
Answer: Option A. -> On


OnOn gives the condition for the join expression.


Question 4. How many tables may be included with a join?
  1.    One
  2.    Two
  3.    Three
  4.    All of the mentioned
 Discuss Question
Answer: Option D. -> All of the mentioned


All of the mentionedJoin can combine multiple tables.


Question 5. Which are the join types in join condition:
  1.    Cross join
  2.    Natural join
  3.    Join with USING clause
  4.    All of the mentioned
 Discuss Question
Answer: Option D. -> All of the mentioned


All of the mentionedThere are totally four join types in SQL.


Question 6. How many join types in join condition:
  1.    2
  2.    3
  3.    4
  4.    5
 Discuss Question
Answer: Option D. -> 5


5Types are inner join,left outer join,right outer join,full join,cross join.


Question 7. Which join refers to join records from the right table that have no matching key in the left table are include in the result set:
  1.    Left outer join
  2.    Right outer join
  3.    Full outer join
  4.    Half outer join
 Discuss Question
Answer: Option B. -> Right outer join


Right outer joinRIGHT OUTER JOIN: Return all rows from the right table, and the matched rows from the left table.


Question 8. In SQL the statement select * from R, S is equivalent to
  1.    Select * from R natural join S
  2.    Select * from R cross join S
  3.    Select * from R union join S
  4.    Select * from R inner join S
 Discuss Question
Answer: Option B. -> Select * from R cross join S


Select * from R cross join S


Question 9. The operation which is not considered a basic operation of relational algebra is
  1.    Join
  2.    Selection
  3.    Union
  4.    Cross product
 Discuss Question
Answer: Option A. -> Join


Join


Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0