Vertoz Interview Questions and Answers for Freshers

Q1. SQL Window Functions and RANK, DENSE RANK Difference
Ans. 
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
• RANK function assigns a unique rank to each distinct row within a partition.

• DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

• Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
Answered by AI
Add your answer
Q2. Hadoop Default Replication Factor
Add your answer

Q1. Gave a me a task to perform on data cleaning
Add your answer
Q2. Question regarding ETL and data pre-processing
Add your answer

Q1. What is your highest education
Add your answer
Q2. How many people in family and what they do?
Add your answer

Data was given along with questions you have to answer 2 of them

Q1. 2nd highest number from an array
Ans. 
Find the 2nd highest number in an array of strings.
• Convert the array of strings to an array of integers for comparison.

• Sort the array in descending order to easily find the 2nd highest number.

• Return the element at index 1 as the 2nd highest number.
Answered by AI
Add your answer

Q1. Yet to complete the interview
Add your answer