CodeClouds Interview Questions, Process, and Tips for Freshers

General Computer Science Questions.

Q1. 2NF and 3NF difference
Ans. 
2NF eliminates partial dependencies, while 3NF eliminates transitive dependencies.
• 2NF eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the primary key.

• 3NF eliminates transitive dependencies by ensuring that non-key attributes are not dependent on other non-key attributes.

• Example: In a table with columns A, B, and C where A is the primary key, if B depends on A and C...read more
Answered by AI
Add your answer
Q2. Alternative of using loop to print 1 to 100
Ans. 
Using recursion to print numbers from 1 to 100 without a loop
• Create a recursive function that takes a number as input and prints it

• Call the function with 1 as the initial input and increment the input by 1 in each recursive call

• Stop the recursion when the input reaches 100
Answered by AI
Add your answer
Q3. Delete and Truncate Difference
Ans. 
Delete removes rows from a table while truncate removes all rows from a table.
• Delete is a DML command while truncate is a DDL command.

• Delete operation can be rolled back while truncate operation cannot be rolled back.

• Delete operation fires triggers on each row deletion while truncate operation does not fire triggers.
Answered by AI
Add your answer

Q1. Which data structure is used to reverse an array?
Ans. 
The data structure used to reverse an array is a stack.
• A stack data structure can be used to reverse an array by pushing each element onto the stack and then popping them off in reverse order.

• Example: If we have an array of strings ['apple', 'banana', 'cherry'], we can reverse it using a stack to get ['cherry', 'banana', 'apple'].
Answered by AI
Add your answer

Q1. It was mostly based on SQL and php
Add your answer

Q1. Viva technical interview
Add your answer

Q1. Another viva technical interview
Add your answer

Q1. Interview with COO
Add your answer

Basics of JS and some coding challenges related to array