Avekshaa Technologies Oracle Database Administrator Interview Questions and Answers

Q1. Storage types, structures, padding
Add your answer
Q2. Bit operations in C language
Ans. 
Bit operations in C language involve manipulating individual bits within a data structure.
• Bitwise AND (&) - sets a bit to 1 only if both input bits are 1

• Bitwise OR (|) - sets a bit to 1 if either input bit is 1

• Bitwise XOR (^) - sets a bit to 1 if the input bits are different

• Bitwise NOT (~) - inverts all bits in a number

• Left shift (<<) - shifts bits to the left by a specified number of positions

• Right shift (>>) - shifts
Answered by AI
Add your answer

Arithmetic, verbal, and verbal skills.

Please write a code for generating the Fibonacci sequence.

Q1. What are the key features and concepts of the C programming language?
Ans. 
C is a powerful and efficient programming language known for its low-level features and flexibility.
• Key features include: low-level memory access, efficient manipulation of pointers, strong support for procedural programming, and a rich library of built-in functions.

• Concepts include: data types, control structures (such as loops and conditionals), functions, arrays, and pointers.

• Example: In C, you can directly access a...read more
Answered by AI
Add your answer
Q2. What is an array
Ans. 
An array is a data structure that stores a collection of elements of the same type in a contiguous memory location.
• Arrays have a fixed size determined at the time of declaration.

• Elements in an array are accessed using an index starting from 0.

• Example: string[] names = {"Alice", "Bob", "Charlie"};
Answered by AI
Add your answer

Q1. When would you be able to join?
Ans. 
I can start within 2 weeks of receiving an offer.
• I can start within 2 weeks of receiving an offer.

• I need to give notice to my current employer.

• I may need time to relocate if necessary.
Answered by AI
Add your answer

There are Question based on data strcuture ,they cover all the topic in ds

In coding code they gave internet access to solve the problem after 30 they told us to make some changes in it and we should ready to explain the entire code

Q1. Linux commands,
Add your answer
Q2. Cloud technologies different services (iaas, paas, saas)
Ans. 
Cloud technologies offer different services like IaaS, PaaS, and SaaS for varying levels of control and management.
• IaaS (Infrastructure as a Service) provides virtualized computing resources over the internet, such as virtual servers and storage.

• PaaS (Platform as a Service) offers a platform allowing customers to develop, run, and manage applications without dealing with infrastructure.

• SaaS (Software as a Service) deli...read more
Answered by AI
Add your answer
Q3. What do you know AWS
Add your answer

There was coding test

Q1. 2 technical rounds
Add your answer
Q2. Merge sort algorithm
Ans. 
Merge sort is a divide and conquer algorithm that divides the input array into two halves, sorts them separately, and then merges them back together in sorted order.
• Divide the input array into two halves

• Recursively sort each half

• Merge the sorted halves back together
Answered by AI
Add your answer

Q1. Leetcode Easy question
Add your answer

It was a Basic Aptitude Test

We were asked to do Sorting, SQL queries (join)

Q1. Can you tell me about yourself?
Ans. 
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
• 5 years of experience in software development

• Proficient in developing web applications

• Skilled in using various technologies such as Java, JavaScript, and SQL
Answered by AI
Add your answer

Q1. Find the ratio of the radius of the inscribed and circumscribed circles of a square of side length a.
Ans. 
Ratio of radius of inscribed and circumscribed circles of a square of side length a.
• The radius of the inscribed circle is half the length of the side of the square.

• The radius of the circumscribed circle is half the diagonal of the square.

• Ratio of radius of inscribed and circumscribed circles is 1:2.
Answered by AI
Add your answer
Q2. Find the coordinates of a point p1 with the distance of it from point p2 and the coordinates p2 and p3, given that all three points are collinear.
Ans. 
To find the coordinates of point p1, use the distance formula and the collinearity of the three points.
• Use the distance formula to find the distance between p1 and p2.

• Use the slope formula to find the slope of the line passing through p2 and p3.

• Use the slope and distance to find the equation of the line passing through p2 and p3.

• Use the equation of the line and the coordinates of p2 to find the coordinates of p1.
Answered by AI
Add your answer
Q3. With the coordinates of the four points p1, p2, p3, and p4, where p1, p2, and p3 lie on a circle, find whether p4 lies inside or outside of the circle.
Ans. 
To determine if p4 lies inside or outside the circle with p1, p2, and p3 coordinates.
• Calculate the equation of the circle using p1, p2, and p3 coordinates.

• Check the distance between p4 and the center of the circle.

• If the distance is less than the radius of the circle, p4 lies inside the circle, otherwise outside.
Answered by AI
View 1 more answer