database-sql-for-database-construction-and-application-processing Related Question Answers

26. Views can be used to show the results of computed columns.

27. A benefit of using a stored procedure is that it can be distributed to client computers.

28. A trigger is a stored program that is attached to a database.

29. A stored procedure is a program that performs some common action on database data and is stored in the database.

30. A SQL view is a virtual table that is constructed from other tables or views.

31. There are three SQL data modification operations: insert, modify and delete.

32. SQL statements can be embedded in triggers, stored procedures, and program code.

33. A view that contains a computed column can be easily updated.

34. Three types of triggers are: BEFORE, AFTER and EXCEPTION.

35. The SQL command to create a table is:

36. A ________ is a stored program that is attached to a table or a view.

37. The DROP TABLE statement:

38. SQL views can be used to hide:

39. The SQL statement to create a view is:

Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions Question ANSWER With Solution