JetSynthesys Interview Questions and Answers

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Q1. What is the concept of a session in PHP?
Ans. 
A session in PHP is a way to store information (variables) to be used across multiple pages.
• Sessions are used to store user data on the server for later use

• Sessions are identified by a unique session ID, usually stored in a cookie

• Session data is stored on the server side, making it more secure than using cookies alone
Answered by AI
Add your answer
Q2. What is the difference between variables and constants in PHP?
Ans. 
Variables can be changed during the execution of a script, while constants cannot be changed once they are defined.
• Variables can be reassigned with new values, while constants cannot be changed once defined

• Constants are defined using the define() function, while variables are assigned using the $ symbol

• Constants are case-sensitive by default, while variables are case-insensitive
Answered by AI
Add your answer
Q3. What will be the output of the code below and why?
Ans. 
The code will output 'Hello World!' because the variable $x is set to true.
• The code will check if $x is true, which it is, so it will output 'Hello World!'

• The if statement will only execute if the condition is true, in this case $x is true.
Answered by AI
Add your answer

What are the differences between echo and print in PHP?

Q1. Complete Computer Science Fundamentals like Computer networks, DBMS, Operating Systems, Linux, Data Structure and Algoritgms
Add your answer
Q2. All Linux Commands
Ans. 
Linux commands are used to interact with the operating system and perform various tasks.
• ls - list directory contents

• cd - change directory

• pwd - print working directory

• mkdir - make directory

• rm - remove files or directories

• cp - copy files or directories

• mv - move files or directories

• grep - search for patterns in files

• chmod - change file permissions

• sudo - execute a command as a superuser
Answered by AI
Add your answer
Q3. OSI models, HTTPs request codes
Add your answer
Q4. Difference b/w list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer

Q1. Discussion about resume, job description and role
Add your answer

UCAT exam - 40 question - 20min

Q1. Questions were based QMS & ISMS and past experience
Add your answer

Q1. Discussed about past experience
Add your answer