Answer the given question based on the information given below:A data manipulation language (DML) statements are used for managing data in database. Syntax for few DML statements explained below.
A. SELECTi. Usage: SELECT is used to retrieve information from one or more tables for tuples (records) satisfying criteriaspecified in where clause.ii. Syntax: SELECT table1.COLUMN1, table2.COLUMN2, … FROM table1, table2 WHERE condition;e.g. SELECT city.NAME FROM city WHERE city.COUNTRY = ’INDIA’;B. INSERTi. Usage: INSERT statement is used to place a new tuple into database. Note: Primary Key column value shouldbe unique for that record.ii. Syntax: INSERT INTO table-name (column1, column2, ...) VALUES (column1_value, column2_value,column3_value, ….);C. UPDATEi. Usage: UPDATE is used to modify value of one or more attributes (columns) for existing tuple(s) of a tablesatisfying the where condition criteriaii. UPDATE table-name SET column-name = value WHERE condition;An SQL JOIN clause is used to combine rows from two or more tables, based on a relationship field between them.• INNER JOIN: Return rows when there is at least one match in BOTH tables.• LEFT JOIN: Return rows from left table, also the matched rows from right table if any.• RIGHT JOIN: Return rows from right table, also the matched rows from left table if any.• FULL JOIN: Return rows from left / right tables.
Identify the true statements from the given below group of statements.o Update SQL statement cannot be used to modify the attributes (column) of multiple tables.II) Select SQL statement be used to fetch records from multiple tablesIII) Insert SQL statement can be used to create multiple records in a table.
