Securin 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. Questions were based QMS & ISMS and past experience
Add your answer

Q1. Discussed about past experience
Add your answer

Q1. Behavior, worst personality, useless manager
Add your answer
Q2. Always keeping eyes on girls one of the worst manager
Add your answer

Easy you will have enough time to solve the questions

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join our company
Add your answer

Q1. Scenario of microservice saga pattern
Add your answer
Q2. Given an integer array segregate odd and even numbers without using another array
Ans. 
Segregate odd and even numbers in an integer array without using another array
• Iterate through the array and maintain two pointers, one for odd numbers and one for even numbers

• Swap elements at the odd and even pointers until all odd numbers are on one side and even numbers on the other

• Example: Input array [3, 6, 8, 5, 4], Output array [6, 8, 4, 5, 3]
Answered by AI
Add your answer