Database

Senior Level Interview Questions

Interview Questions (8)

Sorted by: Recently AddedView All Categories

Provide all of the steps you would take to analyze feedback from users of an existing application, plan design changes, and complete a refactor of the application.At your firm's financial services client, a senior transaction advisory group has complained about an existing application. The group handles hundreds of high-value, current financial transaction approvals, related to many thousands of previously approved clients. Because these transactions are time-sensitive, multiple executives often monitor the same queue simultaneously to complete reviews assigned to their group. Their primary issues are not knowing when tasks are completed by other group members, abandoned tasks that have an "in progress" status, delayed task completion time, lack of transparency into assigned tasks, and an inability to reassign tasks they've accepted. Additionally, the group complains about load times for the high volume of data they manage, and irrelevant transactions and tasks showing in their dashboard. 

This question addresses delivery methodology and multiple technical design aspects (task locking, UI/UX, and query performance improvement).Delivery Methodology First, to address t...

#tasklock#query_performance

Your user interface contains three independent sections, each displaying data from different database tables. These tables have no foreign key relationships or any other relational links. The requirement is to allow users to update the data in all three sections and save the changes back to the database using Write to Records.Question 1: How would you design the process model to handle writing data from all three unrelated sections back to their respective tables?Question 2: Based on your initial design, restructure the process model to demonstrate:How an End shape would be incorporatedHow a Terminate shape would be incorporatedExplain the purpose and placement of each within the redesigned flow.

Question 1: Designing for Multiple Unrelated SectionsWhen your UI contains three independent sections (A, B, and C) that map to three different database tables with no relational l...

If there is an error occurred in a queryEntity rule, what are the possible reasons ?

When answering this in a technical interview, categorize your response to show a structured understanding of how Appian interacts with the database."Errors in an a!queryEntity() ru...

What is view and materialized view ? What is the difference?

View:A view is a virtual table based on a SQL query.It does not store data physically.Every time you query a view, the database re-runs the underlying SELECT query to fetch the lat...

Can you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?

Challenge: In one of my projects, users started entering emojis in text fields such as names, comments, and messages. Our MySQL database was using the utf8 character set, which onl...

You are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.

Assuming Tables:Department Table| dept_id | department_name || ------- | --------------- || 1 | HR || 2 | IT || 3 | Finance || 4...

What are the indexes, advantages + disadvantages?

Indexes in SQL are special database structures that speed up data retrieval by allowing quick access to records instead of scanning the entire table. They act like a lookup system ...

Your Appian interface is loading slow because the SQL view is slow. How do you improve the performance of the SQL view?

When the interface is slow due to a SQL view, my first step is to analyze what columns the view is returning. I check which columns are actually used in the interface and also veri...

#performance#view

pain07m

9mo ago

Loading questions...

Database Appian Interview Questions — Senior Level

Database

Interview Questions (8)

If there is an error occurred in a queryEntity rule, what are the possible reasons ?

What is view and materialized view ? What is the difference?

Can you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?

You are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.

What are the indexes, advantages + disadvantages?

Your Appian interface is loading slow because the SQL view is slow. How do you improve the performance of the SQL view?

Database

Interview Questions (8)

If there is an error occurred in a queryEntity rule, what are the possible reasons ?

What is view and materialized view ? What is the difference?

Can you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?

You are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.

What are the indexes, advantages + disadvantages?

Your Appian interface is loading slow because the SQL view is slow. How do you improve the performance of the SQL view?