Citibank Senior Application Support Analyst Interview Questions and Answers

Graph and trees ques

Q1. What is sql and it’s subtype
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to retrieve, insert, update, and delete data

• Some subtypes of SQL include MySQL, PostgreSQL, Oracle SQL, and Microsoft SQL Server
Answered by AI
Add your answer
Q2. What is sed command and find
Ans. 
sed command is a stream editor for filtering and transforming text, while find command is used to search for files in a directory hierarchy.
• sed command is used to perform text transformations on an input stream or file

• find command is used to search for files in a directory hierarchy based on various criteria

• sed command can be used to replace text, delete lines, or perform other text manipulations

• find command can search...read more
Answered by AI
Add your answer
Q3. What is different between PK and FK
Ans. 
PK is Primary Key which uniquely identifies a record in a table, while FK is Foreign Key which establishes a relationship between two tables.
• PK ensures uniqueness of records in a table

• FK establishes a relationship between tables

• PK is used to enforce entity integrity, while FK is used to enforce referential integrity
Answered by AI
Add your answer
Q4. What is she’ll scraptiing
Ans. 
Shell scraping is the process of extracting data from websites using automated tools or scripts.
• Shell scraping involves writing scripts to automate the process of extracting data from websites

• Tools like BeautifulSoup in Python or Scrapy can be used for shell scraping

• Shell scraping is commonly used for web scraping and data mining purposes
Answered by AI
Add your answer
Q5. What is uptime command in Linux
Ans. 
The uptime command in Linux displays the current time, how long the system has been running, and the number of users currently logged in.
• Displays the current time

• Shows how long the system has been running

• Indicates the number of users currently logged in
Answered by AI
Add your answer
Q6. Why are switching the job
Add your answer

Q1. ….aaaaddddddhhjjjghhh
Add your answer

It was based on d s a

Q1. What's your fav subject
Add your answer

Mostly around multithreading and collections in Java

Q1. Design of singleton pattern , Concurrent hashmap
Ans. 
Singleton pattern ensures a class has only one instance, while ConcurrentHashMap allows multiple threads to access and modify a map concurrently.
• Singleton pattern involves creating a class with a private constructor and a static method to return the instance.

• ConcurrentHashMap is a thread-safe implementation of the Map interface, allowing multiple threads to access and modify the map concurrently.

• To implement a singleto...read more
Answered by AI
Add your answer

Q1. Design a etl system for loading structured data
Ans. 
Design an ETL system for loading structured data
• Identify data sources and destinations

• Create data extraction processes

• Transform data to match destination schema

• Load transformed data into destination
Answered by AI
Add your answer

Q1. General HR question about your strength and weakness and interests.
Add your answer

Q1. Linux Command of how to recycle Jvm
Ans. 
To recycle JVM in Linux, use the kill command with the process ID of the JVM.
• Find the process ID of the JVM using the 'ps' command

• Use the 'kill' command with the process ID to stop the JVM

• Start the JVM again using the appropriate command
Answered by AI
Add your answer
Q2. Sql Command and Weblogic
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a highly motivated and experienced Application Support Engineer with a passion for problem-solving and customer satisfaction.
• I have a Bachelor's degree in Computer Science and over 5 years of experience in application support.

• I am skilled in troubleshooting, debugging, and resolving complex technical issues.

• I have excellent communication skills and enjoy working with customers to ensure their needs are met.

• I am pr...read more
Answered by AI
Add your answer
Q2. What are your strengths?
Ans. 
My strengths include problem-solving, attention to detail, and strong communication skills.
• I am a skilled problem-solver and can quickly identify and resolve issues

• I have a keen attention to detail and can ensure accuracy in my work

• I possess strong communication skills and can effectively collaborate with team members and clients

• I am adaptable and can work well under pressure

• I am a quick learner and can easily pick up
Answered by AI
Add your answer