Sail E0 Webinar

MCQs

Total Questions : 126 | Page 7 of 13 pages
Question 61. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 62. Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 63. The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 64. The keyword LIKE can be used in a WHERE clause to refer to a range of values.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 65. The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 66. If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 67. What is the full form of SQL?
  1.    Simple Query Language
  2.    Structured Query List
  3.    Structured Query Language
  4.    None of these
 Discuss Question
Answer: Option C. -> Structured Query Language
Question 68. The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 69. SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 70. To establish a range of values, < and > can be used.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

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