Fino Payments Bank Interview Questions, Process, and Tips

Q1. 1.backup type 2.recover type 3.recovery and no recovery mode 4.user management 5.log shipping steps 6.lsn misstatements
Add your answer
Q2. 1. replication types and jobs 2. Transitional replication how it's work and which job run and what's is important
Ans. 
Replication types and jobs, and how transactional replication works
• Replication types include snapshot, transactional, and merge

• Snapshot replication copies the entire database at a specific point in time

• Transactional replication copies changes as they occur

• Merge replication combines changes from multiple sources

• Transactional replication uses a distributor to send changes to subscribers

• Important jobs for transactional re...read more
Answered by AI
Add your answer

Q1. 1. Dr dill steps on log shipping 2. Performance tuning
Ans. 
Log shipping and performance tuning are important aspects of SQL Database Administration.
• Log shipping is a process of automating the backup of transaction log files on a primary database server and then restoring them onto a secondary server.

• Performance tuning involves identifying and resolving performance issues in a database system, such as slow queries or inefficient indexing.

• Techniques for performance tuning includ...read more
Answered by AI
Add your answer

Basic aptitude time and direction questions

Q1. Question on SQL , group by , how to remove duplicate rows , basic hr family questions
Add your answer
Q2. Type of joins inSQL
Ans. 
Different types of joins in SQL allow combining data from multiple tables based on specified conditions.
• Inner Join: Returns rows that have matching values in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns all rows when there is a match in either left ...read more
Answered by AI
Add your answer
Q3. How to remove duplicate rows from table
Ans. 
Use SQL query with DISTINCT keyword to remove duplicate rows from a table.
• Use SELECT DISTINCT * FROM table_name to retrieve unique rows.

• Use DELETE FROM table_name WHERE rowid NOT IN (SELECT MIN(rowid) FROM table_name GROUP BY column1, column2, ...); to delete duplicates.

• Use ROW_NUMBER() OVER(PARTITION BY column1, column2, ... ORDER BY column1) AS rn to assign row numbers and then delete rows with rn > 1.
Answered by AI
Add your answer

Q1. Our experience related questions and team helping
Add your answer
Q2. What is the importance of customer relationship management?
Ans. 
Customer relationship management is crucial for building loyalty, increasing customer satisfaction, and driving business growth.
• Enhances customer loyalty by building strong relationships

• Improves customer satisfaction through personalized interactions

• Drives business growth by increasing repeat purchases and referrals

• Helps in understanding customer needs and preferences

• Enables targeted marketing and communication strateg...read more
Answered by AI
Add your answer

Q1. I was asked for personal information
Add your answer
Q2. My qualification was asked
Add your answer

Q1. My work experience was asked
Add your answer
Q2. I was asked about my salary
Add your answer