Aker Solutions Designer Interview Questions and Answers

SQL Server joins are used to combine rows from two or more tables based on a related column between them.

• 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 Outer Join: Returns rows when there is a match in one of t...read more

UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicates.

• UNION removes duplicates from the result set, while UNION ALL includes all rows

• UNION is slower than UNION ALL as it has to perform an additional step to remove duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FRO

Validators in ASP.NET are used to validate user input on the client side before submitting the form to the server.

• Validators can be used to check for required fields, data formats, and custom validation rules.

• Common validators in ASP.NET include RequiredFieldValidator, RegularExpressionValidator, and CustomValidator.

• Validators can be used in combination with validation controls like ValidationSummary to display error m...read more

Viewstate is a hidden field in ASP.NET used to store state information of the page and its controls.

• Viewstate is used to persist data between postbacks

• It can be disabled to reduce page size and improve performance

• Viewstate is encoded in Base64 format for security

Selectors in CSS are patterns used to select the elements you want to style on a web page.

• Selectors can target elements based on their tag name, class, ID, attributes, and more.

• Examples include: element selector (p), class selector (.example), ID selector (#example), attribute selector ([type='text']), etc.