Sail E0 Webinar

MCQs

Total Questions : 45 | Page 3 of 5 pages
Question 21. A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. ROLLBACK WORK asks SQL to empty the log file.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. The UNION clause is used to combine the output from multiple queries together into a single result table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 26. Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 27. A function returns one value and has only output parameters.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. A correlated subquery is where the outer query depends on data from the inner query.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30.  
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 above.
 Discuss Question
Answer: Option C. -> Outer 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