Sail E0 Webinar

MCQs

Total Questions : 126 | Page 13 of 13 pages
Question 121. Which of the following is a valid SQL type?
  1.    CHARACTER
  2.    NUMERIC
  3.    All of these
  4.    FLOAT
 Discuss Question
Answer: Option C. -> All of these
Question 122. 'AS' clause is used in SQL for
  1.    Join operation.
  2.    Selection operation.
  3.    Projection operation.
  4.    Rename operation.
 Discuss Question
Answer: Option D. -> Rename operation.
Question 123. In SQL, which command is used to change a table's storage characteristics?
  1.    ALTER TABLE
  2.    None of these
  3.    CHANGE TABLE
  4.    MODIFY TABLE
 Discuss Question
Answer: Option A. -> ALTER TABLE
Question 124. Count function in SQL returns the number of
  1.    columns.
  2.    distinct values.
  3.    values.
  4.    groups.
 Discuss Question
Answer: Option C. -> values.
Question 125. ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
  1.    EQUIJOIN
  2.    NON-EQUIJOIN
  3.    OUTER JOIN
  4.    NATURAL JOIN
 Discuss Question
Answer: Option B. -> NON-EQUIJOIN
Question 126. NULL is
  1.    the same as 0 for integer
  2.    the same as blank for character
  3.    not a value
  4.    the same as 0 for integer and blank for character
 Discuss Question
Answer: Option C. -> not a value

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

GPOE / GPA Combined 1 Free Mock Test SAIL JO E-0 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant SAIL E0 - GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set 1 Chapter 2 : Coke Ovens and Coal Chemicals SAIL E0 - GPOE/GPA 2024
Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant SAIL E0 - GPOE/GPA 2024
DSP Combined 1 Free Revision Test SAIL JO E-0