Cerner Corporation Interview Experience for Fresher SDE - Intern, Sep 2020
Online Coding Interview
This round was scheduled for 9am in the morning. The test environment was pretty good . I didn't face any issues on the HireVeu platform. The first test was of Aptitude and then in next section it was Technical MCQ's. The level of questions were mid to high level of difficulty.
What is DML and DDL?
Write an SQL query to print the FIRST_NAME from Worker table after replacing ‘a’ with ‘A’.
Write an SQL query to print details of the Workers whose FIRST_NAME contains ‘a’.
What is Normalization?
Tip 1 : Practice at least 5-7 Codes daily from the beginning of preparation.
Tip 2 : Be thoroughly prepared with concepts of Data Structure, Database and Operating System
Tip 3 : Always go through the Company's Job description and About the Company and prepare your answers according to that
Tip 4 : Only mention Projects that you've complete idea about.
Tip 1 : Have a few Projects on your resume and make sure you know it all about your Projects.
Tip 2 : Only mention the Skills you feel you are confident about. Never lie on your resume.