Diya Systems Technical Specialist Interview Questions and Answers

Asked questions like DNS, SSL, SMTP, PHP program output and to write SQL Query

Q1. Tell me about yourself
Add your answer
Q2. How you is current day-to-day work schedule look like?
Add your answer
Q3. Write a program (It could be any question)
Ans. 
Write a program to find the largest number in an array of integers.
• Create an array of integers

• Initialize a variable to store the largest number

• Loop through the array and compare each number to the current largest number

• If the current number is larger, update the largest number variable

• Return the largest number
Answered by AI
Add your answer
Q4. Write a SQL query(It could be any question)
Ans. 
Write a SQL query to find the total number of orders placed by each customer.
• Use the GROUP BY clause to group the orders by customer.

• Use the COUNT function to count the number of orders for each customer.

• Join the orders table with the customers table to get the customer names.
Answered by AI
Add your answer

Multiple Choice questions about Level 1 work. Output of programs or writing queries

Q1. About output of PHP program
Add your answer
Q2. SQL query to find entries based on last name
Ans. 
Use SELECT statement with WHERE clause and LIKE operator to find entries based on last name.
• Use SELECT statement to retrieve data from the table.

• Use WHERE clause to filter the data based on last name.

• Use LIKE operator with % wildcard to match any characters before or after the last name.

• Example: SELECT * FROM table_name WHERE last_name LIKE 'Smith%'
Answered by AI
Add your answer