Comviva Technology Oracle Database Administrator Interview Questions and Answers

Round duration - 90 minutes
Round difficulty - Medium

Online test of 90 minutes at 5:30 pm

Q1. What are the basic concepts of Object-Oriented Programming, and how do they relate to data structures and algorithms?
Ans. 
Object-Oriented Programming concepts include encapsulation, inheritance, and polymorphism, which are used to organize and manipulate data in data structures and algorithms.
• Encapsulation: Bundling data and methods that operate on the data together in a single unit (object). Example: a class representing a car with properties like color and methods like drive().

• Inheritance: Allowing a class to inherit properties and meth...read more
Answered by AI
View 1 more answer

Round duration - 45 minutes
Round difficulty - Medium

Online coding interview of 45 minutes at 6:10PM.

Q1. 
String Compression Problem Statement
Implement a program that performs basic string compression. When a character is consecutively repeated more than once, replace the consecutive duplicates with the coun...read more
Ans. 
Implement a program to compress a string by replacing consecutive duplicates with the count of repetitions.
• Iterate through the string and keep track of consecutive characters and their counts.

• Replace consecutive duplicates with the count of repetitions.

• Handle the case where the count of repetitions is greater than 1 and less than or equal to 9.
Answered by AI
Add your answer
Q2. Can you explain queries related to insert, selection, and joins in a database management system?
Ans. 
Explanation of insert, select, and join queries in a database management system.
• Insert query is used to add new records to a table.

• Select query is used to retrieve data from a table based on specified criteria.

• Join query is used to combine rows from two or more tables based on a related column between them.

• Examples: INSERT INTO table_name (column1, column2) VALUES (value1, value2); SELECT * FROM table_name WHERE condit...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR round of 30 minutes at 6pm

Q1. Explain datawindow in powerbuilder
Ans. 
DataWindow is a GUI control in PowerBuilder used to display and manipulate data from a database.
• DataWindow can be used to retrieve data from a database, display it in a tabular format, and allow users to edit the data.

• It supports various data sources such as SQL, ODBC, and XML.

• DataWindow can also be used to create reports and graphs.

• It provides various features such as sorting, filtering, grouping, and computed columns...read more
Answered by AI
Add your answer