Technology Questions

ANALYZE command is used to perform various functions on index, table, or cluster, as listed below:
- It helps in dentifying migrated and chained rows of the table or cluster.
- It helps in validating the structure of the object.
- It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
- It helps in deleting statistics used by object from the data dictionary.

The following are the two types of assemblies:

          =>  Private Assembly - Refers to the assembly that is used by a single application. Private assemblies are kept in a local folder in which the client application has been installed.

          =>  Public or Shared Assembly - Refers to the assembly that is allowed to be shared by multiple applications. A shared assembly must reside in Global Assembly Cache (GAC) with a strong name assigned to it.

For example, imagine that you have created a DLL containing information about your business logic. This DLL can be used by your client application. In order to run the client application, the DLL must be included in the same folder in which the client application has been installed. This makes the assembly private to your application. Now suppose that the DLL needs to be reused in different applications. Therefore, instead of copying the DLL in every client application folder, it can be placed in the global assembly cache using the GAC tool. These assemblies are called shared assemblies.

The principle distinction amongst sessions and cookies is that sessions are put away on the server, and cookies are put away on the client's PCs in the content record position. Cookies can not hold various variables,But Session can hold numerous variables.We can set expiry for a cookie,The session just stays dynamic the length of the program is open.Users don't have admittance to the information you put away in Session,Since it is put away in the server. Session is mostly utilized for login/logout reason while cookies utilizing for client movement following.

The function declaration should be preceded by the keyword friend.The function definitions does not use either the keyword or the scope operator :: The functions that are declared with the keyword friend as friend function.Thus, a friend function is an ordinary function or a member of another class.

* HTML elements communicate with the Browser how to represent the text.

* HTML elements become HTML tags when enclosed within the angular brackets as "<>".

Visual Basic is not support Inheritance and Data binding OOPS Concept 

- Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode.

- Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file. But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command.

- Offline database we cannot rely upon but in case of online database no issues.

- Offline backup no archived mode is required but in the online backup it is must.