SQL contains statements for (multiple answers possible)1 pointdata definition. data control. data visualization. data retrieval/manipulation.
Question
SQL contains statements for (multiple answers possible)
1 point
- data definition.
- data control.
- data visualization.
- data retrieval/manipulation.
Solution
SQL contains statements for:
-
Data Definition: This is done using Data Definition Language (DDL) statements. Examples include CREATE, ALTER, and DROP which are used to create, alter, and drop database objects respectively.
-
Data Control: This is done using Data Control Language (DCL) statements. Examples include GRANT and REVOKE which are used to give and take away permissions from database users respectively.
-
Data Retrieval/Manipulation: This is done using Data Manipulation Language (DML) statements. Examples include SELECT, INSERT, UPDATE, and DELETE which are used to select, insert, update, and delete data in a database respectively.
SQL does not contain statements for data visualization. Data visualization is typically done using other tools that can connect to a database and retrieve data from it.
Similar Questions
A database can be best described asA Useful presentation of dataB Organized collection of dataC Graphical representation of dataD None of the above
The term "SQL" stands for ________.a.Server-side query languageb.Sequential query languagec.Standard query languaged.Structured query language
What does DML stand for in SQL?1 pointData Management LanguageData Manipulation LanguageData Modification LanguageData Mining Language
__________describes the data contained in the data warehouse.Question 15Answera.Relational datab.Metadata.c.Operational datad.Informational data.
Which of the following is NOT a function of a DBMS?a) Data Retrievalb) Data Manipulationc) Data Encryptiond) Data Storage
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.