Priority Technology Holdings
Metacube Software Interview Questions and Answers
Q1. What is the difference between Data Manipulation Language (DML) and Data Definition Language (DDL)?
DML is used to manipulate data in a database, while DDL is used to define the structure of the database.
DML is used for operations like insert, update, delete data in tables.
DDL is used for operations like creating, altering, dropping tables and defining constraints.
Examples of DML statements include INSERT, UPDATE, DELETE.
Examples of DDL statements include CREATE, ALTER, DROP.
Q2. What is the difference between the DELETE, DROP, and TRUNCATE commands in SQL?
DELETE removes specific rows from a table, DROP removes entire table, TRUNCATE removes all rows from a table.
DELETE is used to remove specific rows from a table based on a condition.
DROP is used to remove an entire table along with its structure and data.
TRUNCATE is used to remove all rows from a table but keeps the table structure intact.
DELETE is slower than TRUNCATE and DROP as it logs individual row deletions.
DROP is irreversible and deletes the table permanently, while T...read more
Q3. What are DDL commands?
DDL commands are used to define and manage the structure of a database.
DDL stands for Data Definition Language.
DDL commands are used to create, modify, and delete database objects such as tables, indexes, and views.
Examples of DDL commands include CREATE, ALTER, and DROP.
DDL commands do not manipulate the data within the database, only the structure.
Q4. Difference between Truncate and Delete statement??
Truncate is a DDL statement that removes all rows from a table, while delete is a DML statement that removes specific rows.
Truncate is faster than delete as it doesn't generate any rollback information.
Truncate cannot be rolled back, while delete can be.
Truncate resets the identity of the table, delete does not.
Truncate does not fire triggers, delete does.
Truncate is non-logged operation, delete is logged.
Q5. What is alias , like , union , joins and basic of python
Alias, like, union, joins are SQL concepts. Basics of Python include data types, loops, functions, and classes.
Alias in SQL is used to give a table or column a temporary name.
Like in SQL is used to search for a specified pattern in a column.
Union in SQL is used to combine the result sets of two or more SELECT statements.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Basics of Python include data types like int, float, str,...read more
Q6. Right view of binary tree
The right view of a binary tree shows the nodes that are visible when looking at the tree from the right side.
The right view of a binary tree can be obtained by performing a level order traversal and keeping track of the rightmost node at each level.
Nodes that are visible from the right side are the ones that are the rightmost at their respective levels.
For example, in the binary tree: 1 / \ 2 3 \ / 5 4 the right view would be [1, 3, 4].
Interview Process at Metacube Software
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month