Ranoson Springs Database Admin Interview Questions and Answers

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer

Q1. How to sync primary and standby?
Ans. 
Primary and standby databases can be synced using Data Guard in Oracle.
• Configure Data Guard on primary and standby databases

• Enable redo transport services

• Monitor and resolve any synchronization issues

• Perform switchover or failover when necessary
Answered by AI
Add your answer
Q2. Performance tuning?
Add your answer

Q1. Why you want to change the job?
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges to enhance my skills and knowledge

• Seeking growth opportunities for career advancement

• Interested in working in a more dynamic and innovative environment
Answered by AI
Add your answer
Q2. Expected salary.
Add your answer

Aptitude , reasoning, general questions

Q1. What is spark architecture and partitions
Ans. 
Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.
• Spark architecture includes components like Driver, Executor, and Cluster Manager

• Partitions are units of data distribution for parallel processing in Spark RDDs

• Increasing the number of partitions can improve parallelism and performance

• Example: In Spark, data is divided into parti...read more
Answered by AI
Add your answer
Q2. What is rdd, trsnsformations
Ans. 
RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.
• RDD is a fault-tolerant collection of elements that can be operated on in parallel.

• Transformations are functions that produce a new RDD by applying a computation on the existing RDD.

• Examples of transformations include map, filter,
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer
Q2. Current ctc n expected ctc
Ans. 
The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.
• Be honest about your current salary and provide a realistic expectation for your future salary.

• Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.

• It is important to have a clear understanding of your worth and negotiate accordingly.
Answered by AI
Add your answer

Q1. Questions related to joins, stored procedures, query optimisation. Queries can be asked. No questions were asked from triggers and DBA related tasks.
Add your answer

Q1. Managerial round asked similar questions again. They analyse your knowledge whether you will be able to take things forward in the company of selected.
Add your answer

Q1. Tell me something about yourself
Ans. 
I am a highly skilled and experienced database programmer with a passion for creating efficient and secure database solutions.
• Over 10 years of experience in database programming

• Proficient in SQL and various database management systems

• Strong understanding of database design principles

• Developed and implemented complex database solutions for large organizations

• Expertise in optimizing database performance and troubleshooti...read more
Answered by AI
Add your answer
Q2. Tell me about your last project
Ans. 
Developed a database management system for a retail company
• Designed and implemented the database schema

• Created stored procedures and triggers for data manipulation

• Optimized query performance by indexing and query tuning
Answered by AI
Add your answer

What about company in byjus

SQl different types of questions

Q1. About oracle database functionality
Add your answer

Q1. Salary discussion
Add your answer