Sail E0 Webinar

MCQs

Total Questions : 69 | Page 7 of 7 pages
Question 61. 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 62. 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.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 63. 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 64. 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 65. 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 66. SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 67. 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 68. To establish a range of values, < and > can be used.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 69. 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

Latest Videos

Latest Test Papers