Quadrant Technologies Interview Questions and Answers

First Round is Assessment consists of 50 Questions and topics are aptitude, reasoning, SQL, DBMS, DS, .NET, C#, Cloud, Python..

I got selected for 2nd round which is GD I got selected for Technical round. Topics is Online Learning.

Q1. Write a program of prime and palindrome number and some basics of skills which you have mentioned and project based questions.
Add your answer

Q1. Flow of .net core applicatin execute
Ans. 
The flow of a .NET Core application is determined by the order in which code is executed, starting from the entry point.
• Entry point is typically the Main method in the Program.cs file

• Startup class is used to configure services and middleware

• Middleware pipeline determines the order in which requests are processed

• Controllers and actions handle incoming requests and generate responses

• Dependency injection is used to manage
Answered by AI
Add your answer
Q2. Dependency injection
Add your answer

Q1. Project related questions
Add your answer
Q2. Daily activities in project
Ans. 
Daily activities in project involve data collection, processing, analysis, and visualization.
• Collecting data from various sources such as databases, APIs, and files

• Cleaning and preprocessing data to ensure quality and consistency

• Analyzing data using statistical methods and machine learning algorithms

• Creating visualizations to communicate insights and findings

• Collaborating with team members to troubleshoot issues and op
Answered by AI
Add your answer
Q3. SQL rank vs dense_rank
Ans. 
SQL rank assigns unique ranks to rows, while dense_rank allows for ties in ranking.
• Rank assigns unique ranks to rows based on specified criteria

• Dense_rank allows for ties in ranking, assigning consecutive ranks without gaps

• Example: Rank - 1, 2, 3, 4, 5; Dense_rank - 1, 2, 2, 3, 4
Answered by AI
Add your answer
Q4. ADF pipeline activity
Add your answer
Q5. How to read parquet file
Ans. 
To read a parquet file, use a library like PyArrow or Apache Spark.
• Use PyArrow library in Python to read a parquet file: `import pyarrow.parquet as pq`

• Load the parquet file into a PyArrow table: `table = pq.read_table('file.parquet')`

• Use Apache Spark to read a parquet file: `spark.read.parquet('file.parquet')`
Answered by AI
Add your answer
Q6. How to write stored procedures in PL/SQL
Ans. 
PL/SQL stored procedures are written using the CREATE PROCEDURE statement with input/output parameters and SQL statements.
• Use CREATE PROCEDURE statement to define a new stored procedure

• Include input/output parameters in the procedure declaration

• Write SQL statements within the procedure body to perform desired operations

• Use variables, loops, and conditional statements as needed

• End the procedure with the END keyword
Answered by AI
Add your answer

The questions of the test includes all the languages i.e., C, Java, python, sql.