Infosys Interview Questions, Process, and Tips for Experienced

SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

• SQL is used for querying and manipulating data in databases.

• PL/SQL is used for writing procedural code like loops, conditions, and functions.

• SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

• PL/SQL can be used to create stored procedures, functions, and triggers i...read more

SQL is a structured query language used to communicate with databases. SQL extensions add additional functionality to the language.

• SQL is a standard language used to interact with databases

• SQL extensions like PL/SQL add procedural programming capabilities to SQL

• PL/SQL is an extension of SQL used in Oracle databases

Star schema has a single fact table and denormalized dimension tables, while snowflake schema has normalized dimension tables.

• Star schema is simpler and easier to understand, but can lead to data redundancy.

• Snowflake schema is more complex but saves storage space and allows for more flexibility in querying.

• Star schema is better suited for smaller datasets, while snowflake schema is better for larger datasets.

• Example of...read more

White box testing is testing the internal structure of the application while black box testing is testing the functionality without knowledge of the internal structure.

• White box testing is also known as clear box testing or structural testing.

• It requires knowledge of the internal workings of the application.

• Examples include unit testing and integration testing.

• Black box testing is also known as functional testing.

• It do...read more

Defect life cycle is the process of identifying, reporting, prioritizing, fixing, and verifying defects in software.

• Defect is identified by testers during testing

• Defect is reported to development team

• Development team prioritizes and fixes the defect

• Fixed defect is verified by testers

• If defect is not fixed, it goes back to development team

• If defect is fixed, it is closed

SQL query to find second highest salary.

• Use ORDER BY clause in descending order to sort the salaries

• Use LIMIT 1,1 to select the second highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1