Oracle Cerner Software Developer Interview Questions, Process, and Tips

Q1. Basic java questions
Add your answer

Q1. Java springboot
Add your answer
Q2. Db, mysql database
Add your answer
Q3. About project description
Add your answer

2 questions hacker rank/ hacker earth

Q1. OOPS concept, method overloading, method overriding difference.
Add your answer

Aptitude, logical reasoning and English proficiency

Simple topics were given to each person and asked to speak about in a few sentences.

Q1. Simple arrays and list questions, how to find the winner of chess(algo/pseudo code). Projects to be explained
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions on DBMS.

Q1. What is data integrity?
Ans. 
Data integrity is the overall accuracy, completeness, and consistency of data. Data integrity also refers to the safety of data in regard to regulatory compliance — such as GDPR compliance — and security. It is maintained by a collection of processes, rules, and standards implemented during the design phase. When the integrity of data is secure, the information stored in a database will remain complete, accurate, and r...read more
Answered Anonymously
Add your answer
Q2. What is a trigger in the context of a database management system?
Ans. 
A trigger is a stored procedure in database which automatically invokes whenever a special event in the database occurs. For example, a trigger can be invoked when a row is inserted into a specified table or when certain table columns are being updated.

Syntax:
create trigger [trigger_name] 
[before | after] 
{insert | update | delete} 
on [table_name] 
[for each row] 
[trigger_body] 

Explanation ...read more
Answered Anonymously
Add your answer
Q3. What is the difference between clustered and non-clustered indexes in a database management system?
Ans. 
1. There can be only one clustered index per table. However, you can create multiple non-clustered indexes on a single table.
2. Clustered indexes only sort tables. Therefore, they do not consume extra storage. Non-clustered indexes are stored in a separate place from the actual table claiming more storage space.
3. Clustered indexes are faster than non-clustered indexes since they don’t involve any extra lookup step.
Answered Anonymously
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DBMS.

Q1. What is the difference between UNION and UNION ALL in SQL?
Ans. 
The only difference between Union and Union All is that Union extracts the rows that are being specified in the query while Union All extracts all the rows including the duplicates (repeated values) from both the queries.
Answered Anonymously
Add your answer
Q2. What are the functions of a cursor in PL/SQL?
Ans. 
The major function of a cursor is to retrieve data, one row at a time, from a result set, unlike the SQL commands which operate on all the rows in the result set at one time. Cursors are used when the user needs to update records in a singleton fashion or in a row by row manner, in a database table.
Answered Anonymously
Add your answer
Q3. Write a SQL query to fetch the nth highest salary from a table.
Ans. 
TOP keyword can be used to find the nth highest salary. By default ORDER BY clause print rows in ascending order, since we need the highest salary at the top, we have used ORDER BY DESC, which will display salaries in descending order. Again DISTINCT is used to remove duplicates. The outer query will then pick the topmost salary, which would be your Nth highest salary.

SQL query : 
SELECT TOP 1 salary
FROM ( 
SEL...read more
Answered Anonymously
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a managerial round with typical behavioral problems.

Round duration - 60 minutes
Round difficulty - Medium

The interviewer was really cool. He realized that I mostly work on java applications so he chose to ask me stuff related to that. He didn't want me to know the answer well but just wanted me to approach to it, maybe think more. He went through my resume back and forth and asked mostly about all my projects and their logic and how could I take them to the next level.
Tips: Be confident. Its okay not to know any answer, just try giving it a shot in the approach.

Q1. What is the difference between an abstract class and an interface in Java?
Ans. 
1. Type of methods: Interface can have only abstract methods. An abstract class can have abstract and non-abstract methods. From Java 8, it can have default and static methods also.
2. Final Variables: Variables declared in a Java interface are by default final. An abstract class may contain non-final variables.
3. Type of variables: Abstract class can have final, non-final, static and non-static variables. The interface...read more
Answered Anonymously
Add your answer
Q2. What is the difference between 'final', 'finally', and 'finalize' in Java?
Ans. 
1. Definition : final is the keyword and access modifier which is used to apply restrictions on a class, method or variable. finally is the block in Java Exception Handling to execute the important code whether the exception occurs or not. finalize is the method in Java which is used to perform clean up processing just before object is garbage collected.
2. Applicable to: Final keyword is used with the classes, methods ...read more
Answered Anonymously
Add your answer
Q3. What is the difference between the private and final access modifiers in Java?
Ans. 
1. Private Access Modifier is not applicable to top-level classes. Final Access Modifier modifier is applicable to top-level classes. 
2. We cannot access private methods outside the class in Private Access Modifier. We can access the final method outside the class in Final Access Modifier .
3. We can hide the private method in Private Access Modifier. The final method cannot be hidden in Final Access Modifier.
4. Pr...read more
Answered Anonymously
Add your answer
Q4. What are the steps for establishing a JDBC connection?
Ans. 
Step 1: Import the database. 

Step 2: Loading the drivers. In order to begin with, you first need to load the driver or register it before using it in the program.
Registration is to be done once in your program. You can register a driver in one of two ways mentioned below as follows:
2-A Class.forName()
Here we load the driver’s class file into memory at the runtime. No need of using new or create objects. 
2-B D...read more
Answered Anonymously
Add your answer
Q5. What is JSON?
Ans. 
JSON stands for JavaScript Object Notation JSON is a lightweight format for storing and transporting data. It is often used when data is sent from a server to a web page
Answered Anonymously
Add your answer
Q6. What do you know about garbage collection in Java?
Ans. 
Garbage collection in Java is the process by which Java programs perform automatic memory management. Java programs compile to bytecode that can be run on a Java Virtual Machine, or JVM for short. When Java programs run on the JVM, objects are created on the heap, which is a portion of memory dedicated to the program. Eventually, some objects will no longer be needed. The garbage collector finds these unused objects an...read more
Answered Anonymously
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

I wouldn't say it went great but it was fine. I did not think I would clear it as for most of the questions the interviewer seemed disappointed and wanted more out of me.