Keertana Finserv Interview Questions, Process, and Tips

Q1. SQL basics ,dql
Add your answer
Q2. DML, TCL,DDL,SUB QUERY,JOINTS
Add your answer
Q3. Do you know Functions
Ans. 
Functions in SQL are reusable code blocks that perform a specific task.
• Functions can be user-defined or built-in

• They can return a single value or a table of values

• Examples include SUM(), AVG(), and GETDATE()
Answered by AI
Add your answer
Q4. Do you know dcl
Ans. 
DCL stands for Data Control Language, used to control access to data stored in a database.
• DCL commands include GRANT, REVOKE, and DENY.

• GRANT is used to give specific privileges to a user or role.

• REVOKE is used to take back privileges that were granted.

• DENY is used to explicitly deny access to a resource.
Answered by AI
Add your answer
Q5. Do you knowsub query
Ans. 
A subquery is a query nested within another query to retrieve data based on the results of the outer query.
• Subqueries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• Subqueries can be correlated or non-correlated.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer

Aptitude test will be taken online

Q1. Excel round will be taken at the head office
Add your answer

Q1. Face to face interview with HR
Add your answer

It Contains set of questions which includes maths, appitude and Engilsh

Q1. Typing test conducted for 2 min for checking the speed of typing. My request is 1st test youself in typing master for 2 min of typing then go for interview
Add your answer

Q1. Candidate should have basic Excel knowledge And know the fowlling formulas like v lookup, Sumif, Countif and pivot tabel
Add your answer

Q1. Questions relating to your work experience
Add your answer

Basic Aptitude Questions

Q1. Tell me how your fit for the job
Ans. 
I am a highly experienced accountant with a proven track record of managing executive-level financial responsibilities.
• Extensive experience in financial reporting, budgeting, and forecasting

• Strong analytical skills and attention to detail

• Ability to communicate effectively with stakeholders at all levels

• Proven track record of implementing cost-saving initiatives

• Experience in leading and mentoring a team of accounting pr
Answered by AI
Add your answer
Q2. Tell about yourself
Ans. 
I am a detail-oriented executive accountant with over 10 years of experience in financial management and analysis.
• Experienced in preparing financial statements and reports

• Skilled in budgeting and forecasting

• Proficient in analyzing financial data and identifying trends

• Strong knowledge of accounting principles and regulations

• Excellent communication and interpersonal skills
Answered by AI
Add your answer