Sail E0 Webinar

MCQs

Total Questions : 126 | Page 3 of 13 pages
Question 21. SQL query and modification commands make up a(n) ________ .
  1.    HTML
  2.    DDL
  3.    DML
  4.    XML
 Discuss Question
Answer: Option C. -> DML
Question 22. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
  1.    IN only.
  2.    LIKE only.
  3.    Both IN and NOT IN.
  4.    NOT IN only.
 Discuss Question
Answer: Option C. -> Both IN and NOT IN.
Question 23. Which of the following do you need to consider when you make a table in SQL?
  1.    Default values
  2.    All of these
  3.    Data types
  4.    Primary keys
 Discuss Question
Answer: Option B. -> All of these
Question 24. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
  1.    SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
  2.    SELECT NAME IN CUSTOMER WHERE STATE = 'V';
  3.    SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
  4.    SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
 Discuss Question
Answer: Option A. -> SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Question 25. The Microsoft Access wildcards are ____ and ____ .
  1.    underscore(_); question mark (?)
  2.    asterisk (*); percent sign (%)
  3.    percent sign (%); underscore (_)
  4.    question mark (?); asterisk (*)
 Discuss Question
Answer: Option D. -> question mark (?); asterisk (*)
Question 26. To sort the results of a query use:
  1.    None of these
  2.    SORT BY.
  3.    GROUP BY.
  4.    ORDER BY.
 Discuss Question
Answer: Option D. -> ORDER BY.
Question 27. To define what columns should be displayed in an SQL SELECT statement:
  1.    use USING to name the source table(s) and list the columns to be shown after SELECT.
  2.    use FROM to name the source table(s) and list the columns to be shown after SELECT.
  3.    use USING to name the source table(s) and list the columns to be shown after WHER
  4.    use SELECT to name the source table(s) and list the columns to be shown after USING.
 Discuss Question
Answer: Option B. -> use FROM to name the source table(s) and list the columns to be shown after SELECT.
Question 28. The SQL statement that queries or reads data from a table is ________ .
  1.    SELECT
  2.    None of these
  3.    READ
  4.    QUERY
 Discuss Question
Answer: Option A. -> SELECT
Question 29. Which one of the following sorts rows in SQL?
  1.    GROUP BY
  2.    SORT BY
  3.    ORDER BY
  4.    ALIGN BY
 Discuss Question
Answer: Option C. -> ORDER BY
Question 30. SQL can be used to:
  1.    create database structures only.
  2.    All of these
  3.    query database data only.
  4.    modify database data only.
 Discuss Question
Answer: Option B. -> All of these

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