Explain the three classes of SQL commands and when they would be used
What will be an ideal response?
There are three classes or types of SQL commands. Data definition language commands are used to create tables, alter and drop tables, views and indexes. These commands are used to build the structure of the database as well as some additional objects. The next type is Data Manipulation Language commands, which are used to maintain and query a database. Commands in this class include select, update, delete and insert. The last type is the data control language commands, which are used to grant and revoke privileges on tables and other objects in the database.
You might also like to view...
Which of the following is a popular program used to index and store evidence?
a. CaseCentral b. IDEA c. TANZAN d. SQL
Organizations with hierarchical cultures are described as
A. both internally and externally focused and valuing flexibility. B. internally focused and valuing flexibility. C. internally focused and valuing stability and control. D. externally focused and valuing flexibility. E. externally focused and valuing stability and control.
Causality refers to when the occurrence of X causes the occurrence of Y
Indicate whether the statement is true or false
Damon contracts to repair the turf on a soccer field for Carousel Sports Park. Damon knows that without the repair, Carousel will have to cancel an upcoming game. Damon does not perform as promised. As consequential damages, Carousel can recover
a. the cost of new turf. b. the difference between Damon's price and the actual cost of repair. c. the loss of profit from the canceled game. d. nothing.