Capital Numbers Infotech Dot Net Developer Trainee Interview Questions and Answers

Q1. As a fresher you have to prepared with all basic q/a.
Add your answer

Q1. BASIC OF SQL SERVER LIKE JOINS, PROCEDURES, FUNCTIONS, TRIGGER, ETC. ASP.NET ADO.NET, LIFE CYCLE OF ASP.NET, OOPS CONCEPT. BASIC OF ADO.NET.
Add your answer
Q2. DIFFERENCE BETWEEN PROCEDURE AND FUNCTION.
Ans. 
Procedure is a set of SQL statements that performs a specific task, while function returns a value.
• Procedure does not return a value, while function does.

• Functions can be called from within SQL statements, while procedures cannot.

• Functions can be used in SELECT, WHERE, and HAVING clauses, while procedures cannot.

• Example: CREATE PROCEDURE sp_GetEmployeeDetails AS ... vs CREATE FUNCTION fn_GetEmployeeName() RETURNS VARCH
Answered by AI
Add your answer
Q3. WHAT IS JOIN AND ITS TYPES OF JOINS?
Ans. 
Join is used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JO...read more
Answered by AI
Add your answer
Q4. Dml,ddl,trigger, index,
Add your answer

YOU HAVE KNOW BASIC OF PROGRAMING LIKE HOW TO PRINT PALINDRAM, PRINT YOU NAME IN TRAIGALE.