Zoho Interview Questions, Process, and Tips

The first round included 2 sections: C aptitude and general aptitude. The C aptitude section was focused entirely on output prediction, ranging from easy to medium difficulty. In the general aptitude section, few questions can be answered easily by thinking logically.

Coding test had 5 programming questions to be completed within 3 hours.

Q1. What will happen if we do not use commit in pragma procedure?
Ans. 
Without commit in pragma procedure, changes will not be permanently saved in the database.
• Changes made in the procedure will not be saved to the database permanently.

• Other sessions will not be able to see the changes until a commit is issued.

• Rollback will discard any changes made in the procedure without commit.
Answered by AI
View 1 more answer
Q2. Which is language of sql
Ans. 
SQL is the language used for managing and manipulating databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks like querying data, updating records, and creating tables

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE
Answered by AI
View 1 more answer
Q3. Is it possible to perform dml on a view? Yes
Ans. 
Yes, it is possible to perform DML (Data Manipulation Language) operations on a view in Oracle SQL.
• DML operations such as INSERT, UPDATE, and DELETE can be performed on a view in Oracle SQL.

• The view must be updatable, meaning it must meet certain criteria such as having a key-preserved table in the FROM clause.

• Changes made to the view will affect the underlying base tables.

• For example, you can insert data into a view t...read more
Answered by AI
Add your answer
Q4. Will if affect base table ? Yes
Add your answer
Q5. Types of null function 1. NVL 2. NVL2 3. NULL I F 4. COALESCE
Ans. 
Common null handling functions in Oracle SQL and PLSQL.
• NVL function replaces null values with a specified default value.

• NVL2 function returns one value if a specified expression is not null, otherwise returns another value.

• NULLIF function returns null if two expressions are equal, otherwise returns the first expression.

• COALESCE function returns the first non-null expression in a list of expressions.
Answered by AI
Add your answer

It was advanced programming round. I was asked to solve 3 problems.
1. Using insert, remove, replace operation convert one string to another
2. Construct all combinations of a balanced parenthesis based on the number provided
3. It was a matrix island problem

Overnight assignment on the product interviewed for

Case study on the competitor

Time, speed, distance and other 12 topics and C code snippets

Based on work and time ,time,profit and loss