Dilyt Interview Questions and Answers

Second highest salary
union, union all, intersect and except or minus
case statement questions

Q1. Tell me about your self explain the visuals of power bi what is constrains what is commonds
Ans. 
I am a Junior Business Intelligence Developer with experience in Power BI visuals, constraints, and commands.
• Power BI visuals are graphical representations of data such as charts, graphs, and maps.

• Constraints in database management refer to rules that limit the type of data that can be entered into a table.

• Commands in programming are instructions given to a computer to perform a specific task.

• For example, a Power BI vi...read more
Answered by AI
Add your answer
Q2. Explain the power bi visuals
Ans. 
Power BI visuals are interactive graphical representations of data that help users analyze and understand information.
• Power BI visuals include charts, graphs, maps, tables, and custom visuals.

• Users can customize visuals by changing colors, fonts, and other properties.

• Visuals can be interactive, allowing users to drill down into data for more detailed analysis.

• Examples of Power BI visuals include bar charts, pie charts,...read more
Answered by AI
Add your answer
Q3. What is commonds
Ans. 
Commonds is likely a typo or misspelling of 'commands', which are instructions given to a computer program to perform a specific task.
• Commands are essential for interacting with computer systems and software.

• They can be entered through a command line interface or a graphical user interface.

• Examples of commands include 'cd' to change directory, 'ls' to list files, and 'mkdir' to create a new directory.
Answered by AI
Add your answer

1st round written test on basic arithmetic questions, english grammar and SQL related questions.
Answers to be marked in question paper for mcqs, and write in additional sheets about SQL queries asked. This test is of 1hr 30 mins. Phones cannot be used so prepare well in advance.

Q1. Self introduction
Add your answer
Q2. Okay with the SLA
Ans. 
SLA stands for Service Level Agreement, which outlines the level of service expected from a vendor.
• SLA defines the agreed upon level of service between a provider and a customer.

• It includes metrics like response time, uptime, and resolution time.

• SLAs are important for ensuring accountability and quality of service.

• Example: An SLA might specify that the vendor will respond to support tickets within 24 hours.
Answered by AI
Add your answer

Q1. What is the difference between DDL and DML?
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects such as tables, indexes, and views.

• DML is used to insert, update, delete, and retrieve data from database tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE...read more
Answered by AI
Add your answer
Q2. How to fetch a employee record with the second highest salary from the employees table?
Ans. 
Use SQL query with ORDER BY and LIMIT to fetch employee record with second highest salary.
• Write a SQL query to select the employee record with the second highest salary from the employees table.

• Use ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to fetch the second row after sorting.

• Example: SELECT * FROM employees ORDER BY salary DESC LIMIT 1,1;
Answered by AI
Add your answer
Q3. What was one of the trickiest incident you have faced and how did you counter it?
Ans. 
One of the trickiest incidents I faced was resolving a complex data integration issue with multiple sources.
• Identified root cause by analyzing data flow and dependencies

• Collaborated with cross-functional teams to gather insights and solutions

• Implemented a step-by-step plan to address the issue and conducted thorough testing

• Documented the process for future reference and prevention
Answered by AI
Add your answer
Q4. How SQL is divided?
Ans. 
SQL is divided into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
• Data Definition Language (DDL) - used to define the structure of database objects like tables, indexes, and views. Examples include CREATE, ALTER, DROP.

• Data Manipulation Language (DML) - used to manipulate data stored in the database. Examples include SELECT, INSERT, ...read more
Answered by AI
Add your answer
Q5. How would prepare an emplyees attendance record? Create charts and graphs regarding it.
Ans. 
To prepare an employee's attendance record, I would gather data on their attendance, create charts and graphs to visualize trends and patterns.
• Gather attendance data including dates, times, and reasons for absence or tardiness

• Create a spreadsheet or database to organize the data

• Use software like Excel or Tableau to create charts and graphs showing attendance trends

• Include metrics such as overall attendance rate, late a...read more
Answered by AI
Add your answer
Q6. Difference between SQL and MYSQL
Ans. 
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
• SQL is a standard language used to interact with databases, while MySQL is a specific database management system.

• SQL is an ANSI (American National Standards Institute) standard language, while MySQL is an open-source relational database management system.

• SQL can be used with various database ma...read more
Answered by AI
Add your answer
Q7. Define joins using examples.
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Joins are used in SQL to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: INNER JOIN retrieves rows from both tables where the join condition is met.

• Example: LEFT JOIN retrieves all rows from the left table and the matched rows ...read more
Answered by AI
Add your answer

Aptitude, basic sql queries and power bi related question

Q1. Self intro , projects and related to resume
Add your answer

Q1. Sql queries and power bi questions
Add your answer

Q1. Create a attendance report
Ans. 
Create an attendance report for tracking employee attendance
• Gather data on employee attendance including dates, times, and reasons for absence

• Organize the data into a clear and concise report format

• Include metrics such as total number of absences, average attendance rate, and trends over time
Answered by AI
Add your answer

Q1. Basic mathematics question, basic English and SQL questions
Add your answer

Q1. Resume based questions
Add your answer
Q2. Different types of commands
Ans. 
Different types of commands include data manipulation, data definition, data control, and transaction control commands.
• Data manipulation commands: SELECT, INSERT, UPDATE, DELETE

• Data definition commands: CREATE, ALTER, DROP

• Data control commands: GRANT, REVOKE

• Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT
Answered by AI
Add your answer
Q3. Difference between inner join and outer join
Add your answer
Q4. Write SQL query to get second highest salary
Ans. 
SQL query to retrieve the second highest salary from a table
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT clause to retrieve the second row
Answered by AI
Add your answer
Q5. What's the difference between numpy and pandas
Ans. 
Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.
• Numpy is used for numerical operations like linear algebra, Fourier transform, etc.

• Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.

• Numpy works with arrays, while Pandas works with dataframes.

• Numpy is more efficient for numerical computations, while Pandas is more user-fri...read more
Answered by AI
Add your answer