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)



Download 14.28 Kb.
Date07.10.2023
Size14.28 Kb.
#62272
M1 QUIZ notes and free writing

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.

Download 14.28 Kb.

Share with your friends:




The database is protected by copyright ©ininet.org 2024
send message

    Main page