Interview Questions

Testing an executable application for portability across system platforms and environments, usually for conformation to an ABI specification.

ADO.NET is a very important feature of .NET Framework, which is used to work with data that is stored in structured data sources, such as databases and XML files. The following are some of the important features of ADO.NET:

 =>   Contains a number of classes that provide you with various methods and attributes to manage the communication between your application and data source.

 =>   Enables you to access different data sources, such as Microsoft SQL Server, and XML, as per your requirements.

 =>   Provides a rich set of features, such as connection and commands that can be used to develop robust and highly efficient data services in .NET applications.

 =>   Provides various data providers that are specific to databases produced by various vendors. For example, ADO.NET has a separate provider to access data from Oracle databases; whereas, another provider is used to access data from SQL databases.

- 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.

Data binding is an automatic synchronization of data between model and view components. ng-model directive is used in Data binding.

Static (embedded) SQL:

1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.

2.It is more swift and efficient.

3.SQL statements are compiled at compile time.

4.Parsing, validation, optimization, and generation of application plan are done at compile time.

5.It is generally used for situations where data is distributed uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.

7. It is less flexible 

Dynamic (interactive) SQL:

1.In dynamic SQL, how database will be accessed is determined at run time.

2.It is less swift and efficient.

3.SQL statements are compiled at run time.

4.Parsing, validation, optimization, and generation of application plan are done at run time.

5.It is generally used for situations where data is distributed non-uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.

7.It is more flexible.

Because these exps are paid/payable to persons. person includes Sole Proprietor, Partnership Firms, HUF, Co; etc.Personal accounts always appear in B/S until it is transfered to expenditure by debiting to P&L A/C.

Scope resolution operator allows a program to reference an identifier in the global scope that is hidden by another identifier with the same name in the local scope.