Subaiya society

 Q-1- What is difference between drop and delete command?   Drop command Delete command 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Delete command belongs to DML 2-Delete commands delete the data / body part of the table. 3-Delete support where conditions. Syntax: Delete from<table_name> where <conditions>;       Q-2- what is difference between drop and truncate commands? Drop commands Truncate commands 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Truncate commands belong to DDL. 2-Truncate command will delete both header and body of the table and re-create the header. 3-Truncate does not support where conditions.   Syntax: Truncate table<Table_name...

  what is difference between alter and update command? Alter command Update command 1-Alter command belongs to DDL. 2-Alter command is used to modify existing table header. Example- i-Adding new column. ii-Dropping Exiting column. iii-Renaming the exiting column. iv-Change the data type and size. 3-Alter command does not support where conditions. 1-Update command belong from DML. 2-Update command is used to modify the Existing table body.  Example- i-change the values. ii-Rename exiting values.   3-Update commands supports where conditions.

  What is difference between Create and insert commands?   Create command Insert commands 1-Create command belongs to DDL. 2- Create command is used to create header of the table. 3-It is also used to create data bases. 1-Insert command belongs to DML. 2-Insert command is used to create bo d y of the table. 3-  Insert command is used to insert new records in a table.  

  What are the difference between DDL and DML? DDL DML 1-DDL stands for data definition language . 2-DDL sub-language is used to work with   header of the table. 3-DDL sub language contains some commands like create,alter,truncate and drop. 1-DML stands for data manipulation language . 2-DML sub-language is used to manipulate the data base object . 3-DML sub language contain some commands like Insert, update and delete.

  What is different sub-language in SQL? ANS-   DDL  – Data Definition Language.          DML  – Data Manipulation Language.          DRL/DQL  – Data Retrieval Language/Data Query Language.         TCL  – Transaction Query Language.         DCL  – Data Control Language.         SCL  – Session Control Language.

  What is the Table? Explain about table? Ans- A  table  is an arrangement of information in row and columns containing cells that make comparing information easier.

  what is the role of SQL in DBMS? Ans-  SQL stands for Structured Query Language. It is used for  storing and managing data in relational database management system (RDMS) . It is a standard language for Relational Database System. It enables a user to create, read, update and delete relational databases and tables.

  What is DBMS and RDBMS? Ans- DBMS  stands for Database Management System, and RDBMS  is the acronym for the Relational Database Management system. In DBMS, the data is stored as a file, whereas in RDBMS, data is stored in the form of tables

  what is SQL and MYSQL? Ans- SQL stands for structured query language, SQL is a language which is used to communicate with database and  MYSQL is a server which contains one more table,  MySQL is  an Open Source, Fast and Reliable Relational Database Management System (RDBMS) software  like Oracle, Sybase, MS SQL Server etc. It was developed by Michael Widenius and AKA Monty and is alternative to many of the commercial RDBMS.

what is data, information and knowledge? Ans-    Data:-  Data is collection of row facts without proper Meaning, Each row facts having meaning but when we read combinedly then no meaning.  Information:- Information is the result of re-ordered/ Re-processed of data.  Knowledge:- knowledge is the   recall the information. When we evaluate information is called information.

What is data and data base?   Data:-  Data is collection of row facts without proper Meaning, Each row facts having meaning but when we read combinedly then no meaning. Data base:- Data base is a software which is used to store the data and manage the data.

How to introduce myself?   Good Morning/Afternoon Sir/Mam. Thank you for giving me an opportunity to introduce myself today. My Name is shivanand kumar. I'm 26 years old. I'm from east champaran which is located in the Bihar. I completed my B. Tech from Raajdhani Engineering college Bhubaneswar in stream of electrical & electronic engineering in 2019 with 71%. My technical skills are in Full stock Python in Narayana Tech house. If I talk about my hobbies I love travelling and exploring new places and listening to music. I'm a Fresher, My Strength is I'm a quick learner, self-motivated and hard-working. My short-term goal is to get a job in a reputed company where I can improve my skills and experience. My long-term goal is to get a respected position in a reputed company. We are Three members in my family including me, father, my brother and me. That's all from my side.