Sail E0 Webinar

MCQs

Total Questions : 126 | Page 2 of 13 pages
Question 11. The result of a SQL SELECT statement is a(n) ________ .
  1.    table
  2.    form
  3.    file
  4.    report
 Discuss Question
Answer: Option A. -> table
Question 12. A subquery in an SQL SELECT statement is enclosed in:
  1.    braces -- {...}.
  2.    parenthesis -- (...) .
  3.    CAPITAL LETTERS.
  4.    brackets -- [...].
 Discuss Question
Answer: Option B. -> parenthesis -- (...) .
Question 13. Which of the following is the correct order of keywords for SQL SELECT statements?
  1.    SELECT,WHERE,FROM
  2.    SELECT, FROM, WHERE
  3.    WHERE, FROM,SELECT
  4.    FROM, WHERE, SELECT
 Discuss Question
Answer: Option B. -> SELECT, FROM, WHERE
Question 14. The SQL keyword(s) ________ is used with wildcards.
  1.    LIKE only
  2.    IN and NOT IN
  3.    IN only
  4.    NOT IN only
 Discuss Question
Answer: Option A. -> LIKE only
Question 15. Which of the following are the five built-in functions provided by SQL?
  1.    SUM, AVG, MIN, MAX, MULT
  2.    SUM, AVG, MULT, DIV, MIN
  3.    SUM, AVG, MIN, MAX, NAME
  4.    COUNT, SUM, AVG, MAX, MIN
 Discuss Question
Answer: Option D. -> COUNT, SUM, AVG, MAX, MIN
Question 16. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
  1.    all records meeting the full criteria are to be returned.
  2.    all records with even partial criteria met are to be returned.
  3.    None of these
  4.    all columns of the table are to be returned.
 Discuss Question
Answer: Option D. -> all columns of the table are to be returned.
Question 17. The SQL -92 wildcards are ____ and ____ .
  1.    question mark (?); asterisk (*)
  2.    underscore(_); question mark (?)
  3.    asterisk (*); percent sign (%)
  4.    percent sign (%); underscore (_)
 Discuss Question
Answer: Option D. -> percent sign (%); underscore (_)
Question 18. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
  1.    ONLY
  2.    SINGLE
  3.    UNIQUE
  4.    DISTINCT
 Discuss Question
Answer: Option D. -> DISTINCT
Question 19. The benefits of a standard relational language include which of the following?
  1.    All of these
  2.    Increased dependence on a single vendor
  3.    Applications are not needed
  4.    Reduced training costs
 Discuss Question
Answer: Option D. -> Reduced training costs
Question 20. The HAVING clause does which of the following?
  1.    Acts like a WHERE clause but is used for rows rather than columns.
  2.    Acts EXACTLY like a WHERE clause.
  3.    Acts like a WHERE clause but is used for columns rather than groups.
  4.    Acts like a WHERE clause but is used for groups rather than rows.
 Discuss Question
Answer: Option D. -> Acts like a WHERE clause but is used for groups rather than rows.

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

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
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
DSP Combined 1 Free Revision Test SAIL JO E-0