Karunya University Interview Questions and Answers

Explanation of differences between union and union all, stored procedures and functions, primary key and foreign key, and temp tables.

• Union combines and removes duplicates, while union all combines without removing duplicates.

• Stored procedures are precompiled and can return multiple result sets, while functions are not precompiled and can only return a single value.

• Primary key uniquely identifies a record, while foreign key references a primary key in another table.

• Temp table...read more

Reverse a string in Python using slicing

• Use string slicing with a step of -1 to reverse the string

• Example: 'hello'[::-1] will return 'olleh'

Java and Python are both popular programming languages, with Java being statically typed and Python being dynamically typed.

• Java is statically typed, while Python is dynamically typed

• Java requires explicit declaration of data types, while Python does not

• Java is compiled into bytecode which runs on the Java Virtual Machine, while Python is interpreted at runtime

• Java is commonly used for enterprise applications and Android development, while Python is popular for web developmen...read more

Testing is the process of evaluating a software application to ensure it meets specified requirements and functions correctly.

• Testing involves executing the software with the intent of finding bugs or errors.

• Types of testing include unit testing, integration testing, system testing, and acceptance testing.

• Testing can be manual or automated, with automated testing using tools like Selenium or JUnit.

• Regression testing ensures that new code changes do not adversely affect existi...read more

SQL joins queries are used to combine rows from two or more tables based on a related column between them.

• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables