Sail E0 Webinar

MCQs

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

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