Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. What is the meaning of "Temporary Tables in Mysql?
  1.    Rows returned by sub query
  2.    Permanent tables
  3.    Virtual tables
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> Rows returned by sub query


"Temporary Tables are output format of any query on Mysql.


Question 2. If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query?SELECT emp_idFROM personORDER BY emp_id;
  1.    {-3, -2, -1, 1, 2, 3}
  2.    {-1, 1, -2, 2, -3, 3}
  3.    {1, 2, 3, -1, -2, -3}
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> {-3, -2, -1, 1, 2, 3}


"ORDER BY clause sort the emp_id in the result set.


Question 3. Which clause is used with an "aggregate functions?
  1.    GROUP BY
  2.    SELECT
  3.    WHERE
  4.    Both a and c
 Discuss Question
Answer: Option A. -> GROUP BY


"GROUP BY is used with aggregate functions.


Question 4. What will be the output of the following statement "false AND Null?
  1.    false
  2.    Null
  3.    Depend
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Null




Question 5. "COUNT keyword belongs to which categories in Mysql?
  1.    Aggregate functions
  2.    Operators
  3.    Clauses
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> Aggregate functions




Question 6. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT emp_idFROM personORDER BY emp_id DESC;
  1.    {9, 7, 6, 4, 3, 1, 2}
  2.    {1, 2, 3, 4, 6, 7 , 9}
  3.    {2, 1, 3, 4, 6, 7, 9}
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> {9, 7, 6, 4, 3, 1, 2}




Question 7. Is there any error in the following query?SELECT emp_id, title, start_date, fname, fed_idFROM personORDER BY RIGHT (fed_id, 3);
  1.    Yes
  2.    No error
  3.    Depends
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> No error




Question 8. What will be the output of a query given below?SELECT person_id, Fname, lnameFROM person;
  1.    Show only columns (person_id, Fname, lname) and rows related to these columns
  2.    Show only columns (person_id, Fname, lname)
  3.    Show all rows
  4.    Show all columns except (person_id, Fname, lname)
 Discuss Question
Answer: Option A. -> Show only columns (person_id, Fname, lname) and rows related to these columns


"SELECT clause is used to show all rows and columns that are mention with the query.


Question 9. What will be the result of the query given below?SELECT emp_id,'ACTIVE' AS STATUS,emp_id * 3.14 AS emp_pi,UPPER (lname) AS last_nameFROM employee;
  1.    emp_id, ACTIVE, emp_id * 314, UPPER(lname)
  2.    emp_id, Status, emp_pi, last_name
  3.    Error
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> emp_id, Status, emp_pi, last_name


Status, emp_pi, last_name are "column aliases and Keyword "AS is optional.


Question 10. What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='HEAD TELLER' AND start_date=2008-11-24;
  1.    All columns
  2.    Only those columns which are mention with SELECT" clause
  3.    Columns mention with SELECT" clause and only those rows which contain 'HEAD TELLER' as a title" and start_date as 2008-11-24
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Only those columns which are mention with SELECT" clause


"WHERE clause is used to filter out unwanted rows and "SELECT clause is used to select columns from table.


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