Infosys Database Consultant Interview Questions and Answers

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer

Q1. OEM services-related Questions
Add your answer
Q2. What is Oracle Block Change
Ans. 
Oracle Block Change is a feature that tracks and records changes made to database blocks.
• Oracle Block Change is used for efficient data replication and synchronization.

• It helps in identifying and transferring only the changed data blocks instead of the entire database.

• Oracle GoldenGate utilizes Oracle Block Change technology for real-time data integration.

• Block Change Tracking (BCT) is a feature in Oracle Database that...read more
Answered by AI
Add your answer
Q3. In RAC database 2 nodes are there how you will re-direct users to 2nd node only?
Ans. 
To redirect users to the 2nd node in a RAC database, you can use services and connection load balancing.
• Create a service for the 2nd node in the RAC database.

• Configure connection load balancing to distribute connections evenly between the nodes.

• Update the connection string in the application to point to the service for the 2nd node.

• Test the connection to ensure users are redirected to the 2nd node.
Answered by AI
Add your answer

Q1. What is CAP theorem What is column families What function are used in cassandra what is key value pair
Ans. 
CAP theorem states that in a distributed system, it is impossible to simultaneously guarantee consistency, availability, and partition tolerance.
• CAP theorem: Consistency, Availability, Partition tolerance - pick two

• Column families: A way to organize data in NoSQL databases like Apache Cassandra

• Functions in Cassandra: read, write, delete, update

• Key value pair: Basic data structure where each key is associated with a val
Answered by AI
Add your answer
Q2. What is Cloumn families
Ans. 
Column families are a way to organize related data in a NoSQL database, grouping columns together for efficient retrieval.
• Column families are a way to group related columns together in a NoSQL database.

• They are used in databases like Apache Cassandra to organize data efficiently.

• Column families can contain a large number of columns, each with a unique name and value.

• They are stored together on disk for faster retrieval...read more
Answered by AI
Add your answer
Q3. What are the functions in cassandra
Ans. 
Cassandra functions are used for data manipulation and retrieval in Cassandra database.
• Aggregate functions like COUNT, SUM, AVG, MIN, MAX

• Date and time functions like NOW, DATEOF, UNIXTIMESTAMP

• Mathematical functions like ABS, CEIL, FLOOR, SIN, COS

• String functions like LENGTH, SUBSTRING, CONCAT, LOWER, UPPER
Answered by AI
Add your answer
Q4. Fundamentels of cassandra
Ans. 
Cassandra is a distributed NoSQL database management system designed for handling large amounts of data across multiple servers.
• Cassandra is a highly scalable and fault-tolerant database system.

• It is based on a distributed architecture, with data spread across multiple nodes.

• Cassandra uses a masterless design, where all nodes are equal and can handle read and write requests.

• It uses a partitioning strategy called consis...read more
Answered by AI
Add your answer
Q5. What is key value pair
Ans. 
Key value pair is a data structure where each key is associated with a corresponding value.
• Key value pairs are commonly used in dictionaries, hash tables, and JSON objects.

• Keys are unique identifiers that are used to access the corresponding values.

• Examples include 'name: John', 'age: 30', 'city: New York'.
Answered by AI
Add your answer

Q1. Dataguard architecture
Add your answer
Q2. Rman backup and restoration
Add your answer

Q1. Why you join inm
Ans. 
I joined inm because of the company's reputation for innovation and growth in the tech industry.
• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values
Answered by AI
Add your answer

Q1. What is database architecture?
Ans. 
Database architecture refers to the design and structure of a database system.
• Database architecture includes the organization of data, storage, retrieval, and security mechanisms.

• It involves defining the relationships between data elements and how they are stored and accessed.

• Examples of database architectures include hierarchical, network, relational, and object-oriented.

• Database architecture also includes the choice ...read more
Answered by AI
Add your answer
Q2. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete fires triggers, while truncate does not fire triggers.

• Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.

• Example: DELETE FROM table_name WHERE condi
Answered by AI
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

It was good interview everyone was friendly

Q1. Why are you switching your current job
Ans. 
Seeking new challenges and growth opportunities in a more dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking to expand my skills and knowledge in a different setting
Answered by AI
Add your answer
Q2. What is your expected CTC
Ans. 
My expected CTC is negotiable based on the job responsibilities and market standards.
• My expected CTC is based on my experience, skills, and the job requirements.

• I am open to discussing the salary range during the interview process.

• I am looking for a competitive salary package that aligns with industry standards.

• I am flexible and willing to consider other benefits in addition to the salary.
Answered by AI
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer