Interview Questions

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection. SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end. 

SQLPASSTHROUGH mode can be set as per session or per transaction. The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server.

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".
LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

The object need to be serialized when it’s sent over a network and when it’s state is saved. Exceptions which occur during serialization are:

a. transient fields

b. when the base class is serialized then only base class fields are handled.

c. static fields are ignored because they are not part of any state.

Notices, Warnings and Fatal errors are the types of errors in PHP

Notices: 

Notices represents non-critical errors, i.e. accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all but whenever required, you can change this default behavior.

Warnings: 

Warnings are more serious errors but they do not result in script termination. i.e calling include() a file which does not exist. By default, these errors are displayed to the user.

Fatal errors: 

Fatal errors are critical errors i.e. calling a non-existent function or class. These errors cause the immediate termination of the script.