Merkur Gaming India Interview Questions and Answers

Basics web development MCQ

Core knowledge on JS and code snippet

Q1. DSA on array and string and deep knowledge in JS
Add your answer

Q1. It was manager round
Add your answer

Moderate level aptitude test with QA+ gaming questions

Q1. Based on CV you will get the questions
Add your answer

Q1. Games and manual testing
Add your answer

Q1. How to read parquet and csv file in spark .
Ans. 
To read parquet and csv files in Spark, use SparkSession's read method with appropriate options.
• Create a SparkSession object

• Use the read method of SparkSession to read parquet files with .parquet() method

• Use the read method of SparkSession to read csv files with .csv() method

• Specify options like header, delimiter, inferSchema, etc. as needed

• Load the data into a DataFrame for further processing
Answered by AI
Add your answer
Q2. How to check second highest sallery.
Ans. 
To check the second highest salary, use the SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY clause to sort salaries in descending order.

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

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Answered by AI
Add your answer