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...
The electrical wiring in a house is defective. The broker who listed the house is aware of this and intentionally deceives a potential buyer about it. The buyer purchases the home and later suffers a financial loss due to the faulty wiring. This is an example of
A) mistake of law B) fraud C) mistake of fact D) statue of fraud
Which of the following is true of studies evaluating the marketing research industry?
A) They show that the industry gets an "F" and only major reform will save the industry in the future. B) The reviews are mixed. C) Earlier reviews indicate that the industry has performed reasonably well but there is room for improvement. D) both A and B E) both B and C