Crowdly
Додати до Chrome
IIT ISM Dhandbad - 2026
Шукаєте відповіді та рішення тестів для IIT ISM Dhandbad - 2026? Перегляньте нашу велику колекцію перевірених відповідей для IIT ISM Dhandbad - 2026 в xlearn.cubastion.net.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
In the given question, choose the correct water image of the below figure from amongst the given options.
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.
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) satisfyingcriteria specified 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 valueshould be 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 betweenthem.• 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.
Select the appropriate JOIN for the below SQL, given that only those Customers records should come for whom Order(s) is there.SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Customers____________ JOIN Orders ON Orders.CustomerID=Customers.CustomerID;
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
In SQL, which of the following JOIN type should be used to get list of students enrolled in at least one course?
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 should be 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
In relational database, the rows are referred to as __________ and columns are referred to as_____________
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 belowA. SELECTi. Usage: SELECT is used to retrieve information from one or more tables for tuples (records) satisfyingcriteria specified 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 betweenthem.• 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.
What will below SQL query do?SELECT * FROM ORDERS where ORDERDATE BETWEEN ‘07/04/2015’ and ‘07/09/2016’;
Find the number of dots on the face opposite the face bearing 3 dots.
The sheet of a paper shown in the below figure is folded to form a box. Choose from amongst the alternatives (a), (b), (c) and (d), the boxes that are similar to the box that will be formed.
The question consists of five figures marked P, Q, R, S and T called the Problem figures followed by four otherfigures marked 1, 2, 3, 4 called Answer figures. Select a figure from amongst the answer figures which will continue the same series as established by the five problem figures.
A matrix of certain characters is given. These characters follow a certain trend, row-wise or column-wise. Find out this trend and choose the missing character accordingly.