Sail E0 Webinar

MCQs

Total Questions : 126 | Page 6 of 13 pages
Question 51. Most companies keep at least two versions of any database they are using.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 52. SUM, AVG, MIN, and MAX can only be used with numeric columns.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 53. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 54. The result of every SQL query is a table.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 55. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 56. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 57. ORDER BY can be combined with the SELECT statements.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 58. Indexes may be created or dropped at any time.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 59. The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 60. Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False

Latest Videos

Latest Test Papers