Cognizant L2 Engineer Interview Questions and Answers

The question is asking to select a column named 'columnname' as '1' from the employee table and provide the output if the table contains 100 records.

• The column 'columnname' does not exist in the employee table, so the query will result in an error.

• The value '1' will be selected for each record in the employee table, resulting in 100 rows with the value '1'.

• The output will be a single column with 100 rows, all containin

No, DML operations cannot be performed on UDF functions.

• UDF functions are read-only and cannot modify the data in the database.

• DML operations can only be performed on tables or views.

• UDF functions can be used in SELECT statements to retrieve data.

• Examples of UDF functions include string manipulation, date calculations, and mathematical operations.

Virtual keyword is used for method overriding while new keyword is used for hiding base class member.

• Virtual keyword is used to allow a derived class to override a method in the base class.

• New keyword is used to hide a base class member in the derived class.

• Virtual keyword is used with the base class method while new keyword is used with the derived class method.

• Virtual keyword is used for runtime polymorphism while ne

Method hiding is a technique in object-oriented programming where a subclass provides a method with the same name as a method in its superclass.

• Method hiding is also known as static polymorphism or compile-time polymorphism.

• It allows a subclass to provide its own implementation of a method without affecting the superclass's implementation.

• The method in the subclass must have the same name and signature as the method in...read more

Partial view returns HTML string while render partial view writes directly to response stream.

• Partial view returns HTML string that can be used in the main view

• Render partial view writes directly to response stream

• Partial view can be used to render reusable components

• Render partial view can be used to render a partial view without a layout

SQL query to select all columns from two tables.

• Use SELECT statement to select columns from tables.

• Use aliases to differentiate columns from different tables.

• Separate table names with comma in FROM clause.