Sail E0 Webinar

MCQs

Total Questions : 34 | Page 3 of 4 pages
Question 21. Which of the following scripts will run successfully?
  1.    SELECT customer name FROM customers;
  2.    SELECT FROM `customers` 'customer name';
  3.    SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
  4.    SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
 Discuss Question
Answer: Option A. -> SELECT customer name FROM customers;
Question 22. What will be printed by the given query? SELECT LENGTH("WINNER");
  1.    7
  2.    6
  3.    8
  4.    9
 Discuss Question
Answer: Option B. -> 6
Question 23. What will be the output of the following query:Select round(59999
  1.    59999
  2.    59900
  3.    60000
  4.    59990
 Discuss Question
Answer: Option C. -> 60000
Question 24. What will be returned by the given query? SELECT round(153
  1.    153.6
  2.    153.66
  3.    153.67
  4.    153.7
 Discuss Question
Answer: Option C. -> 153.67
Question 25. Which function will be used to remove only the trailing spaces from a string?
  1.    ltrim()
  2.    rtrim()
  3.    trim()
  4.    all
 Discuss Question
Answer: Option B. -> rtrim()
Question 26. Which SQL function is used to find the average value of any column?
  1.    Mean()
  2.    Avg()
  3.    Average()
  4.    Sum()
 Discuss Question
Answer: Option B. -> Avg()
Question 27. Which one of the following sorts rows in SQL?
  1.    SORT BY
  2.    ALIGN BY
  3.    GROUP BY
  4.    ORDER BY
 Discuss Question
Answer: Option D. -> ORDER BY
Question 28. Which is the default order of sort in ORDER BY clause?
  1.    Ascending
  2.    Descending
 Discuss Question
Answer: Option A. -> Ascending
Question 29. Which is not an aggregate function?
  1.    SUM()
  2.    POW()
  3.    AVG()
  4.    COUNT()
 Discuss Question
Answer: Option B. -> POW()
Question 30. In MySQL, which command is used to modify the table values
  1.    Select
  2.    Alter
  3.    Modify
  4.    Update
 Discuss Question
Answer: Option D. -> Update

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