Sail E0 Webinar

MCQs

Total Questions : 63 | Page 7 of 7 pages
Question 61. . Which is NOT one of the most common types of SQL CHECK constraints?
  1.    System date
  2.    Range checks
  3.    Lists of values
  4.    Comparing one column value to another within the same table
 Discuss Question
Answer: Option A. -> System date
Question 62. . What is an advantage of placing computations in SQL views?
  1.    To save users from having to write an expression.
  2.    To ensure that the results are consistent.
  3.    To accomplish both of the above.
  4.    None of the above is correct - computations cannot be placed in a view.
 Discuss Question
Answer: Option C. -> To accomplish both of the above.
Question 63. . Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
  1.    GROUP BY.
  2.    WHERE.
  3.    ORDER BY.
  4.    FROM.
 Discuss Question
Answer: Option C. -> ORDER BY.

Latest Videos

Latest Test Papers