Sail E0 Webinar

MCQs

Total Questions : 39 | Page 4 of 4 pages
Question 31. Views can be used to show the results of computed columns.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 32. A trigger is a stored program that is attached to a database.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 33. A benefit of using a stored procedure is that it can be distributed to client computers.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 34. A SQL view is a virtual table that is constructed from other tables or views.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 35. A stored procedure is a program that performs some common action on database data and is stored in the database.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 36. There are three SQL data modification operations: insert, modify and delete.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 37. SQL statements can be embedded in triggers, stored procedures, and program code.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 38. A view that contains a computed column can be easily updated.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 39. Three types of triggers are: BEFORE, AFTER and EXCEPTION.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False

Latest Videos

Latest Test Papers