Sail E0 Webinar

MCQs

Total Questions : 34 | Page 2 of 4 pages
Question 11. Which of the following is not a relational operator?
  1.    &&
  2.    >=
  3.    !=
  4.    =
 Discuss Question
Answer: Option A. -> &&
Question 12. The term ___________ is used to refer a column
  1.    Row
  2.    Record
  3.    Tuple
  4.    Attribute
 Discuss Question
Answer: Option D. -> Attribute
Question 13. In a LIKE clause, you can ask for any 6 letter value by writing
  1.    LIKE ______ (that's six underscore characters)
  2.    LIKE ...... (that's six dots)
  3.    LIKE .{6}
  4.    LIKE ??????
 Discuss Question
Answer: Option A. -> LIKE ______ (that's six underscore characters)
Question 14. Which of the following is not a numeric function?
  1.    MOD
  2.    SIGN
  3.    MID
  4.    POW
 Discuss Question
Answer: Option C. -> MID
Question 15. What will be returned by the given query? SELECT INSTR("INDIA", "DI");
  1.    2
  2.    3
  3.    -2
  4.    -3
 Discuss Question
Answer: Option B. -> 3
Question 16. Which of the following are valid column names?
  1.    Marks Eng
  2.    66_Marks
  3.    Marks_Eng
  4.    #Eng_Marks
 Discuss Question
Answer: Option C. -> Marks_Eng
Question 17. Which of the following is not a text function?
  1.    TRIM()
  2.    TRUNCATE()
  3.    LEFT()
  4.    MID()
 Discuss Question
Answer: Option B. -> TRUNCATE()
Question 18. What will be returned by the given query? SELECT sign(26);
  1.    1
  2.    -1
  3.    0
  4.    none
 Discuss Question
Answer: Option A. -> 1
Question 19. What will be returned by the given query? SELECT concat("It", "was", "ok");
  1.    "It was ok"
  2.    "Itwasok"
  3.    "Itwas ok"
  4.    "Tt wasok"
 Discuss Question
Answer: Option B. -> "Itwasok"
Question 20. What will be returned by the given query? SELECT month('2020-05-11');
  1.    5
  2.    11
  3.    May
  4.    November
 Discuss Question
Answer: Option A. -> 5

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