Joins"A3" 1 / 50 JOIN result size largest in? INNER FULL LEFT CROSS 2 / 50 JOIN result size smallest in? LEFT CROSS FULL INNER 3 / 50 CROSS JOIN with condition becomes? OUTER JOIN SELF JOIN NATURAL JOIN INNER JOIN 4 / 50 JOIN columns indexed होने से? Slow No effect Performance improve Error 5 / 50 JOIN + ORDER BY allowed? Only LEFT Yes Only INNER No 6 / 50 JOIN result order default? Random Indexed Grouped Sorted 7 / 50 JOIN + DISTINCT purpose? Faster Filter Duplicate remove Duplicate allow 8 / 50 JOIN ambiguous column error occurs when? Same column name Missing alias No ON clause All 9 / 50 NATURAL JOIN drawback? Auto column match No control All Slow 10 / 50 Derived table join means? Index join Subquery join Trigger join View join 11 / 50 JOIN with subquery possible? Yes Only select Error No 12 / 50 RIGHT JOIN = RIGHT OUTER JOIN? Error Yes Depends No 13 / 50 LEFT JOIN = LEFT OUTER JOIN? Sometimes Yes No Error 14 / 50 OUTER JOIN keyword optional है? Depends Yes Error No 15 / 50 JOIN condition mandatory for INNER JOIN? No Optional Depends Yes 16 / 50 JOIN returns result called? Schema Result set View Table 17 / 50 JOIN in DELETE statement possible? Error Yes Only UPDATE No 18 / 50 JOIN in UPDATE statement possible? Only SELECT Only DELETE Yes No 19 / 50 LEFT JOIN + WHERE right.col IS NULL means? All rows Matching rows Error Non-matching rows 20 / 50 OUTER JOIN + WHERE condition effect? No change Faster Error Convert to INNER JOIN 21 / 50 JOIN + HAVING allowed? Error Depends Yes No 22 / 50 JOIN + GROUP BY allowed? No Only LEFT Yes Only INNER 23 / 50 JOIN condition लिखने के दो तरीके? GROUP / HAVING SELECT / INSERT UPDATE / DELETE ON / WHERE 24 / 50 JOIN में alias क्यों use करते हैं? Security Performance Backup Short name 25 / 50 JOIN columns datatype mismatch होने पर? NULL Ignore Error Auto convert 26 / 50 Three tables join कहलाता है? Nested join Complex join Chain join Multiple join 27 / 50 Multiple JOINs possible हैं? Yes Only two tables Depends No 28 / 50 JOIN + WHERE condition किस order में execute होता है? WHERE → JOIN SELECT → JOIN GROUP BY → JOIN JOIN → WHERE 29 / 50 RIGHT JOIN में LEFT table unmatched rows? Duplicate Error NULL Removed 30 / 50 LEFT JOIN में RIGHT table unmatched rows? Removed NULL Duplicate Error 31 / 50 OUTER JOIN में unmatched rows कैसे दिखते हैं? 0 Empty Error NULL 32 / 50 JOIN condition usually किस keys पर होती है? Random View Index only Primary–Foreign key 33 / 50 JOIN performance improve होती है? Index से Constraint से View से Trigger से 34 / 50 JOIN without condition कहलाता है? EQUI JOIN SELF JOIN CROSS JOIN INNER JOIN 35 / 50 SELF JOIN में table को कैसे refer करते हैं? Duplicate name Index View Alias 36 / 50 SELF JOIN का उपयोग कब होता है? Same table relation Sorting Backup Two databases 37 / 50 NATURAL JOIN में ON clause लिखा जाता है? Sometimes No Depends Yes 38 / 50 NATURAL JOIN किस basis पर होता है? Same datatype Primary key Foreign key Same column name 39 / 50 CROSS JOIN को क्या कहते हैं? Natural join Self join Outer join Cartesian join 40 / 50 CROSS JOIN result size depends on? Max rows Min rows Sum of rows Product of rows 41 / 50 FULL OUTER JOIN unsupported in? MySQL SQL Server PostgreSQL Oracle 42 / 50 FULL OUTER JOIN returns? Left only Right only All rows Matching rows 43 / 50 RIGHT OUTER JOIN क्या return करता है? Only matching NULL onl Right all rows Left all rows 44 / 50 LEFT OUTER JOIN क्या return करता है? Right table all rows Matching only Common rows Left table all rows 45 / 50 NON-EQUI JOIN किस operator का उपयोग करता है? BETWEEN LIKE >, = = 46 / 50 EQUI JOIN किस operator का उपयोग करता है? = > < 47 / 50 JOIN condition किस clause में लिखी जाती है? WHERE GROUP BY HAVING FROM / ON 48 / 50 INNER JOIN = ? CROSS JOIN EQUI JOIN RIGHT JOIN LEFT JOIN 49 / 50 JOIN किस command के साथ उपयोग होता है? UPDATE DELETE SELECT INSERT 50 / 50 JOIN का मुख्य उद्देश्य क्या है? Multiple tables से data combine Structure change Table delete Data insert Your score isThe average score is 0% 0% Restart quiz
