Describe the differences between the data definition language (DDL), data manipulation language (DML), and the data query language (DQL)
What will be an ideal response?
Answer: The data definition language (DDL) builds the data dictionary, creates the database, describes logical views for each user, and specifies record or field security constraints. The data manipulation language (DML) changes database content, including data element creations, updates, insertions, and deletions. The data query language (DQL) is a high-level, English-like language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data.
You might also like to view...
The percentage of people willing and able to buy ultra luxury cars in China is much lower than
that of Britain. Yet Rolls Royce is marketing its cars in China far more intensely than in any other region. Which of the following explains this phenomenon? A) People in China are more likely to pay more for ultra luxury cars than people in developed nations. B) China and other Asian countries have a larger upscale potential than Europe. C) Market segmentation is easier in Asia as they have a large diverse population. D) Transport and shipping to Asian countries is extremely easy and costs very little.
In text mining, tokenizing is the process of
A) categorizing a block of text in a sentence. B) reducing multiple words to their base or root. C) transforming the term-by-document matrix to a manageable size. D) creating new branches or stems of recorded paragraphs.