Kanerika Software Interview Questions and Answers

Q1. What is selenium ,how to fix frame work,how to write Navigation tools..?
Ans. 
Selenium is a tool used for automating web browsers. Framework can be fixed by identifying and resolving issues. Navigation tools can be written using Selenium commands.
• Selenium is a popular open-source tool for automating web browsers

• To fix a framework, identify and resolve issues with the code

• Navigation tools can be written using Selenium commands like 'get', 'click', 'sendKeys', etc.
Answered by AI
Add your answer
Q2. Mention the types of web locator What are the types of waits supported by web driver..?
Ans. 
Web locators include ID, name, class name, tag name, link text, and partial link text. Web driver supports implicit, explicit, and fluent waits.
• Web locators are used to identify elements on a web page

• ID and name locators are unique to an element

• Class name and tag name locators can identify multiple elements

• Link text and partial link text locators are used for links

• Implicit waits wait for a certain amount of time before...read more
Answered by AI
Add your answer
Q3. What are the selenium suit components What are the limitations of selenium testing..?
Ans. 
Selenium suite components include Selenium IDE, Selenium WebDriver, and Selenium Grid. Limitations include browser compatibility issues and difficulty in testing non-web applications.
• Selenium IDE for record and playback

• Selenium WebDriver for programmatic interaction

• Selenium Grid for distributed testing

• Browser compatibility issues

• Difficulty in testing non-web applications
Answered by AI
Add your answer
Q4. What is the major difference between driver.close() and driver.quit()?
Ans. 
driver.close() closes the current window while driver.quit() closes all windows and ends the session.
• driver.close() only closes the current window while driver.quit() closes all windows and ends the session

• driver.close() can be used when multiple windows are open and you want to close only one of them

• driver.quit() should be used at the end of the script to ensure all windows are closed and the session is ended
Answered by AI
Add your answer
Q5. How to type text in an input box using Selenium
Ans. 
To type text in an input box using Selenium, use the sendKeys() method.
• Locate the input box using a locator strategy

• Use the sendKeys() method to enter text into the input box

• Example: driver.findElement(By.id("inputBoxId")).sendKeys("Text to be entered")
Answered by AI
Add your answer

Questions were moderate but we need to manage time to clear this round

Q1. Asked to tell about me
Add your answer
Q2. Questions on OOPS concept
Add your answer
Q3. And basic To moderate SQL questions
Add your answer
Q4. Question on DSA
Add your answer

Q1. Asked me to tell about me
Add your answer
Q2. And asked about my projects
Add your answer
Q3. Asked me to tell what my expectations are from Kanerika
Add your answer

Q1. Pyspark,unity catalogue and Sql coding questions
Add your answer
Q2. Data warehousing concepts
Add your answer

Q1. Project related questions
Add your answer
Q2. Python and Sql related questions
Add your answer

70 questions in 90 minutes with 7 sections

Q1. Introduce yourself
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Second highest salary
Ans. 
To find the second highest salary in a table, you can use a SQL query with the MAX() function and a subquery.
• Use a SQL query to select the MAX() salary from the table.

• Use a subquery to select the MAX() salary that is less than the overall MAX() salary.

• Combine both queries to get the second highest salary.
Answered by AI
Add your answer
Q4. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of specific columns in a database table to their physical location on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that match a certain condition.

• Examples o...read more
Answered by AI
Add your answer

Q1. Introduce yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.
Answered by AI
Add your answer

Q1. Why you join company
Add your answer
Q2. Where you see yourself after 5 years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on cutting-edge technologies.
• Leading a team of developers on innovative projects

• Continuing to enhance my technical skills and knowledge

• Contributing to the growth and success of the company

• Possibly pursuing further education or certifications in software development
Answered by AI
Add your answer