Sail E0 Webinar

MCQs

Total Questions : 64 | Page 3 of 7 pages
Question 21. A correlated subquery is processed as a nested subquery.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. A regular subquery is processed from the bottom up.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. Correlated subqueries are similar to a regular subquery.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 24. Database redesign is especially difficult if the database has no data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 25. Some organizations take the stand that no application should ever employ the true name of a table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. If a database is built correctly the first time, it will not have to be redesigned.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 30. The SQL-92 command to change a table name is RENAME TABLE.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False

Latest Videos

Latest Test Papers