Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. The following query belongs to which condition types?SELECT fnameFROM personWHERE dept_id= (SELECT dept_id FROM department WHERE names='s');
  1.    Equality condition
  2.    Inequality condition
  3.    Range condition
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> Equality condition


In the following query column equate to the value returned by subquery.


Question 2. What will be the output of the following query?SELECT *FROM employeeWHERE start_date BETWEEN '2007-01-01' AND '2008-01-01';
  1.    All employees details between 2007 and 2008
  2.    All employees details before 2008
  3.    All employees details from 2007 to 2008
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> All employees details between 2007 and 2008


"BETWEEN operator is used for upper “ upper limit.


Question 3. Find the error in the following query?SELECT cust_id, fed_idFROM customerWHERE cust_id = 'I'AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
  1.    Yes
  2.    No
  3.    Range too high to compare
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> No


In the following query, there will be no error in executing as 5000-00-000 AND 9999-999-000 is "string ranges.


Question 4. Is the following query belongs to the "Equality condition?SELECT product_type.name, product.nameFROM product_type INNER JOIN ProductON product_type.dept=Product.deptWHERE product_type.name='customers_accounts';
  1.    Yes
  2.    No
  3.    Depends
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Yes


In the following query there are two equality conditions "ON and "WHERE.


Question 5. Fill the blanks with suitable options?
BETWEEN ______ AND ______
  1.    Upper and lower limit
  2.    Lower and upper limit
  3.    Both a and b
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Lower and upper limit




Question 6. Which operator is used to check whether the expression is "NULL?
  1.    IS NULL
  2.    NOT NULL
  3.    ON
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> IS NULL




Question 7. Which of the following statements is/are correct?
  1.    True AND true =true
  2.    True AND false= false
  3.    False AND false= false
  4.    All of the mentioned
 Discuss Question
Answer: Option D. -> All of the mentioned




Question 8. What will be the output of the following query?SELECT emp_id, fname, lnameFROM employeeWHERE LEFT (fname, 1) ='F' OR LEFT (lname, 1) ='F';
  1.    Only those employees are selected whose first name and last name started with 'F'
  2.    Only those employees are selected whose first name started with 'F' but last name can be starts with any other letter
  3.    Only those employees are selected whose first name and last name started with any other letter except 'F'
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Only those employees are selected whose first name and last name started with 'F'




Question 9. What will be the output of the following query?SELECT fnameFROM personWHERE emp_id != 6;
  1.    Only those names whose emp_id is not equal to 6
  2.    Only those names whose emp_id is equal to 6
  3.    Both a and b
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Only those names whose emp_id is not equal to 6




Question 10. What is the meaning of "NULL in Mysql?
  1.    Not applicable
  2.    Value not yet known
  3.    Value undefined
  4.    All of the mentioned
 Discuss Question
Answer: Option D. -> All of the mentioned




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