M1 QUIZ notes and free writing
Q1:- Arithmetic Logic Unit (ALU), which performs arithmetic and logical operations
Control Unit (CU), which executes or stores the results of the ALU and performs input and output operations
Memory Unit, which includes registers and main memory (RAM) . Registers are small and fast memory units that store intermediate results or instructions
Q2:- No, "Select" is not a DDL sql statement. It is a DML SQL statement. The "SELECT" statement falls under the category of DML statements because its primary purpose is to retrieve data from database tables. It allows you to query and retrieve specific data from one or more tables, apply filters and conditions, and return the result set as a query result. While the result of a SELECT statement may involve reading the schema and metadata of the tables involved, its primary function is data retrieval, making it a DML statement.
Q3:- No, "CREATE" is not a Data Manipulation Language (DML) SQL statement; it is a Data Definition Language (DDL) statement. SQL is divided into several categories of statements, with DML and DDL being two of the most important categories. The "CREATE" statement falls under the DDL category because it is used to create database objects, such as tables, indexes, views, and more. Here are a few examples of "CREATE" statements:
CREATE TABLE: Used to create a new table in the database.
CREATE INDEX: Used to create an index on one or more columns of a table.
CREATE VIEW: Used to create a virtual table based on the result of a query.
Share with your friends: |