MICROPROCESSOR AND MICROCONTROLLER

Detailed explanation-1: -Five types of SQL queries are 1) Data Definition Language (DDL) 2) Data Manipulation Language (DML) 3) Data Control Language(DCL) 4) Transaction Control Language(TCL) and, 5) Data Query Language (DQL)

Detailed explanation-2: -Data Definition Language (DDL) Statements. Data Manipulation Language (DML) Statements. Transaction Control Statements. Session Control Statements.

Detailed explanation-3: -The major applications of SQL include writing data integration scripts, setting and running analytical queries, retrieving subsets of information within a database for analytics applications and transaction processing, and adding, updating, and deleting rows and columns of data in a database.

Detailed explanation-4: -Numeric data types such as: INT, TINYINT, BIGINT, FLOAT, REAL, etc. Date and Time data types such as: DATE, TIME, DATETIME, etc. Character and String data types such as: CHAR, VARCHAR, TEXT, etc. Unicode character string data types such as: NCHAR, NVARCHAR, NTEXT, etc. More items •03-Aug-2022