CodeClouds Intern Interview Questions and Answers

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