
Virtusa Consulting Services

Virtusa Consulting Services Senior Software Engineer Interview Questions and Answers
Q1. what is the adb devices command and when we are use it
adb devices command is used to list all Android devices connected to a computer via USB debugging
Used to check the list of Android devices connected to the computer for debugging purposes
Helps in identifying the device ID and status (offline, online, unauthorized)
Commonly used in Android development for testing and debugging
Example: 'adb devices' command will display a list of connected devices with their respective status
Q2. What are dependency we added in POM.xml file for mobile automation
We added dependencies like Appium, TestNG, Selenium, and Apache POI in POM.xml for mobile automation.
Appium dependency for mobile automation testing
TestNG dependency for test execution and reporting
Selenium dependency for web automation
Apache POI dependency for reading and writing Excel files
Q3. coding question to remove duplicate , count frequencies of occurrence of characters
Remove duplicates and count frequencies of characters in an array of strings.
Iterate through each string in the array
Use a hashmap to store characters and their frequencies
Remove duplicates by checking if character already exists in hashmap
Q4. What are decorators in Python What is the use of __name == __main__ Django related questions
Decorators in Python are functions that modify the behavior of other functions or methods. __name__ == __main__ is used to check if a Python script is being run directly or imported as a module.
Decorators are used to add functionality to existing functions without modifying their code.
They are defined using the @decorator syntax before the function definition.
Example: @staticmethod decorator in Python is used to define a method that doesn't access or modify class or instance ...read more
Q5. What is mean by index
An index is a data structure that improves the speed of data retrieval operations on a database table.
Indexes are used to quickly locate data without having to search every row in a database table.
They are created on columns in a database table to speed up data retrieval operations.
Examples include primary keys, unique keys, and non-unique keys.
Q6. What is delete and truncate
Delete and truncate are SQL commands used to remove data from a table, but they differ in their functionality.
DELETE is a DML command used to remove specific rows from a table based on a condition
TRUNCATE is a DDL command used to remove all rows from a table, resetting auto-increment values
DELETE can be rolled back, while TRUNCATE cannot be rolled back
DELETE triggers delete triggers, while TRUNCATE does not trigger any triggers
DELETE is slower than TRUNCATE as it logs individ...read more
Q7. What is mean by Null
Null is a value that represents the absence of a value or a placeholder.
Null is often used in programming to indicate that a variable does not have a value assigned to it.
It is different from an empty string or zero, as it specifically means 'no value'.
For example, a database field may have a null value if no data has been entered for that field.
Q8. SCD types of in ETL
Slowly Changing Dimensions (SCD) types in ETL refer to how historical data is handled when new data is loaded into a data warehouse.
Type 1: Overwrite - simply overwrite the existing data with the new data
Type 2: Add new row - keep all versions of the data in the table
Type 3: Update - create a new column to store the old value while updating the current value
Type 4: Hybrid - combination of Type 1 and Type 2 or Type 1 and Type 3
More about working at Virtusa Consulting Services

Top HR Questions asked in Virtusa Consulting Services Senior Software Engineer
Interview Process at Virtusa Consulting Services Senior Software Engineer

Top Senior Software Engineer Interview Questions from Similar Companies








Reviews
Interviews
Salaries
Users/Month

