Sail E0 Webinar

MCQs

Total Questions : 126 | Page 12 of 13 pages
Question 111. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints
  1.    5
  2.    10
  3.    9
  4.    0
 Discuss Question
Answer: Option D. -> 0
Question 112. Which of the following SQL commands can be used to add data to a database table?
  1.    ADD
  2.    UPDATE
  3.    APPEND
  4.    INSERT
 Discuss Question
Answer: Option D. -> INSERT
Question 113. If a query involves NOT, AND, OR with no parenthesis
  1.    AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
  2.    NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
  3.    NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
  4.    The order of occurrence determines the order of evaluation.
 Discuss Question
Answer: Option B. -> NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
Question 114. Which of the following join is also called as an 'inner-join'?
  1.    Non-Equijoin
  2.    None of these
  3.    Self-Join
  4.    Equijoin
 Discuss Question
Answer: Option D. -> Equijoin
Question 115. Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return
  1.    exactly 10 rows
  2.    None of these
  3.    less than 10 rows
  4.    more than 10 rows
 Discuss Question
Answer: Option A. -> exactly 10 rows
Question 116. The result of a SQL SELECT statement is a ________ .
  1.    table
  2.    form
  3.    file
  4.    report
 Discuss Question
Answer: Option A. -> table
Question 117. Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?
  1.    SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
  2.    Both A and B
  3.    None of these
  4.    SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
 Discuss Question
Answer: Option D. -> SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
Question 118. How to select all data from student table starting the name from letter 'r'?
  1.    SELECT * FROM student WHERE name LIKE '%r';
  2.    SELECT * FROM student WHERE name LIKE 'r%';
  3.    SELECT * FROM student WHERE name LIKE '%r%';
  4.    SELECT * FROM student WHERE name LIKE '_r%';
 Discuss Question
Answer: Option B. -> SELECT * FROM student WHERE name LIKE 'r%';
Question 119. Which of the following query is correct for using comparison operators in SQL?
  1.    None of these
  2.    SELECT name, course_name FROM student WHERE age>50 and WHERE age
  3.    SELECT name, course_name FROM student WHERE age>50 and
  4.    SELECT name, course_name FROM student WHERE age>50 and age
 Discuss Question
Answer: Option D. -> SELECT name, course_name FROM student WHERE age>50 and age
Question 120. Select the right statement to insert values to the student table.
  1.    INSERT student VALUES (
  2.    INSERT INTO student VALUES (
  3.    INSERT VALUES INTO student (
  4.    INSERT VALUES (
 Discuss Question
Answer: Option B. -> INSERT INTO student VALUES (

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