Cipher Oncology Interview Questions and Answers

The first 50 prime numbers are...

• Start with 2, the first prime number

• Check each odd number greater than 2

• Use trial division to check if a number is prime

• Stop when you have found 50 prime numbers

Sorting a file within a range

• Use a sorting algorithm like quicksort or mergesort

• Read the file and store the data in an array or list

• Sort the array or list within the given range

• Write the sorted data back to the file

I am a passionate software engineer with experience in developing web applications using various technologies.

• Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

• Proficient in backend development with Node.js, Express, and MongoDB

• Familiar with version control systems like Git and project management tools like Jira

I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

• Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React

• Strong background in computer science with knowledge in algorithms and data structures

• Passionate about learning new technologies and solving complex problems

I have worked on various projects including a web application for inventory management and a mobile app for fitness tracking.

• Developed a web application using React for inventory management

• Created a mobile app using Flutter for fitness tracking

• Implemented RESTful APIs for communication between frontend and backend systems

My area of interest is artificial intelligence and machine learning.

• I have experience in developing machine learning models for predictive analytics.

• I am interested in natural language processing and computer vision applications.

• I enjoy exploring deep learning algorithms and neural networks.

• I have worked on projects involving recommendation systems and image recognition.

C++ is a high-level programming language with features like object-oriented programming, templates, and memory management.

• C++ supports object-oriented programming concepts like encapsulation, inheritance, and polymorphism.

• Templates allow generic programming and code reusability.

• C++ provides low-level memory manipulation through pointers.

• Standard Template Library (STL) provides a collection of classes and functions for ...read more

Big Data refers to large and complex data sets that cannot be processed using traditional data processing methods.

• Big Data is characterized by the 3Vs - Volume, Velocity, and Variety.

• It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.

• Examples of Big Data include social media data, sensor data, and financial market data.

Program to reverse a string without using string function

• Iterate through the string from end to start and append each character to a new string

• Use a loop to swap the first and last characters, then move towards the middle until the entire string is reversed

• Convert the string to a character array, then swap the first and last elements until the entire array is reversed

I was responsible for designing and implementing the project's database and backend functionality.

• Designed the database schema and created the necessary tables

• Implemented the backend functionality using Java and Spring framework

• Collaborated with team members to integrate the frontend and backend components

• Tested the application and fixed any bugs or issues that arose

• Presented the project to the faculty and received pos

Keys in a database are unique identifiers used to establish relationships between tables and ensure data integrity.

• Keys are used to uniquely identify records in a database table.

• Primary keys are used to uniquely identify each record in a table.

• Foreign keys establish relationships between tables.

• Keys help enforce data integrity and maintain consistency in the database.

• Examples of keys include primary keys, foreign keys,

Issues in cloud include security, downtime, vendor lock-in, and data privacy.

• Security concerns such as data breaches and unauthorized access

• Downtime and service interruptions affecting business operations

• Vendor lock-in and limited flexibility in choosing cloud providers

• Data privacy and compliance with regulations such as GDPR and HIPAA

Developed a web application for online shopping using React and Node.js

• Implemented user authentication and authorization using JSON Web Tokens (JWT)

• Used MongoDB as the database to store user and product information

• Implemented a search feature using Elasticsearch to provide fast and accurate search results

• Integrated Stripe payment gateway for secure online transactions

The flow diagram of my final year project showcases the step-by-step process of its execution.

• The flow diagram illustrates the sequence of activities and their dependencies.

• It helps in understanding the overall structure and logic of the project.

• Each step in the diagram represents a specific task or action.

• Arrows indicate the flow of control or data between different steps.

• Decision points are represented by diamond-sha...read more

Normalisation reduces data redundancy and improves data integrity in a database.

• Prevents data duplication and inconsistencies

• Simplifies database maintenance and updates

• Improves query performance

• Enforces data integrity and consistency

• Follows best practices for database design

• Examples: breaking down a customer table into separate tables for orders, addresses, and payments

• Examples: creating a separate table for product ca...read more

I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

• Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React

• Strong background in computer science with knowledge of algorithms and data structures

• Familiar with agile development methodologies and version control systems like Git

I am a problem solver, team player, quick learner, detail-oriented, and have strong communication skills.

• Problem solver - I enjoy tackling complex problems and finding innovative solutions.

• Team player - I work well with others and value collaboration in achieving goals.

• Quick learner - I am able to pick up new technologies and concepts quickly.

• Detail-oriented - I pay attention to the smallest details to ensure high-qual...read more

Yes, I have a Bachelor's degree in Computer Engineering.

• Bachelor's degree in Computer Engineering

• Experience in software development

• Knowledge of engineering principles applied to software design

My day was productive and challenging, with a lot of problem-solving and collaboration.

• Completed a major coding project ahead of schedule

• Participated in a brainstorming session with team members

• Solved a tricky bug in the codebase

• Attended a virtual meeting with stakeholders

No, I do not have any relatives in Pune. I have arranged for my accommodation in a rented apartment near the office.

• No relatives in Pune

• Accommodation arranged in a rented apartment near the office

Yes, My Passion Challenge test is a coding competition for software engineers.

• My Passion Challenge test is a coding competition that evaluates the coding skills of software engineers.

• It is designed to test problem-solving abilities, algorithmic thinking, and coding proficiency.

• Participants are given a set of coding challenges to solve within a specified time limit.

• The challenges can range from simple to complex, coveri...read more

Considering pursuing a Master's degree in Computer Science to deepen knowledge and advance career.

• Considering pursuing a Master's degree in Computer Science

• To deepen knowledge and advance career

• Examples: MS in Computer Science at XYZ University, online courses in AI and Machine Learning

Queue can be implemented using two stacks by maintaining the order of elements in the stacks.

• Create two stacks, let's call them stack1 and stack2

• When an element is enqueued, push it to stack1

• When an element is dequeued, pop all elements from stack1 and push them to stack2

• Pop the top element from stack2 and return it as the dequeued element

• If stack2 is empty, repeat step 3

• To get the front element of the queue, peek the

Left join returns all records from left table and matching records from right table. Full outer join returns all records from both tables.

• Left join is used to combine two tables based on a common column.

• In left join, all records from the left table are returned along with matching records from the right table.

• If there is no match in the right table, NULL values are returned.

• Example: SELECT * FROM table1 LEFT JOIN table...read more

Magic functions are special methods in PHP that start with __. Autoloading is a way to automatically load classes.

• Magic functions are used to handle certain events in PHP, such as object creation or property access.

• Autoloading allows PHP to automatically load classes when they are needed, without requiring manual includes.

• Magic functions can be used in conjunction with autoloading to dynamically load classes or handle

Given three sorted arrays, find common elements.

• Create three pointers to traverse each array

• Compare the elements at the pointers and move the pointer of the smallest element

• If all pointers point to the same element, add it to the result and move all pointers

• Repeat until any pointer reaches the end of its array

Check if a number is a power of 2 or not.

• A power of 2 has only one bit set in its binary representation.

• Use bitwise AND operator to check if the number is a power of 2.

• If n is a power of 2, then n & (n-1) will be 0.

Event bubbling is the propagation of an event from the innermost child element to the outermost parent element.

• Events triggered on a child element will also trigger on its parent elements

• The event travels up the DOM tree until it reaches the document object

• Can be stopped using event.stopPropagation()

• Can be useful for event delegation

The .on('click',function() is a more flexible method than .click(function())

• The .on() method can handle multiple events and selectors

• The .click() method can only handle one event and one selector

• The .on() method can also handle dynamically added elements

• The .click() method cannot handle dynamically added elements

Function to check if two strings are anagram or not

• Create two character arrays from the strings

• Sort the arrays

• Compare the sorted arrays

Function to determine the order of integers in an array.

• Check first and last element to determine if increasing or decreasing

• Check for inflection point to determine if order changes

• Return order type as string

Optimize images, minify code, reduce HTTP requests, use caching, and lazy loading.

• Optimize images using compression and appropriate file formats

• Minify code to reduce file size and improve load times

• Reduce HTTP requests by combining files and using sprites

• Use caching to store frequently accessed data locally

• Implement lazy loading to defer loading of non-critical resources

Design a database schema for a movie site with user ratings and recommendations.

• Create tables for movies, users, ratings, and recommendations

• Use foreign keys to link tables

• Include columns for movie genre and user watch history

• Algorithm for recommendations can use user watch history and ratings to suggest similar movies

Function to simulate dice roll with equal probability without using random function

• Use a toss function that returns either 0 or 1 with equal probability

• Call the toss function 3 times and convert the result to a binary number

• If the binary number is greater than 0 and less than or equal to 6, return it

• If the binary number is greater than 6, repeat the process

Query to fetch duplicate email from table

• Use GROUP BY and HAVING clause to filter out duplicates

• SELECT email, COUNT(*) FROM table_name GROUP BY email HAVING COUNT(*) > 1;

• This will return all the duplicate emails in the table