Interview Questions

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features:

- Tools to create classes (usually called entities) mapped to database tables

- Compatibility with LINQ's standard query operations

- The DataContext class, with features such as entity record monitoring, automatic SQL statement generation, record concurrency detection, and much more

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

Use the SORTWK01, SORTWK02,..... dd names in the step. Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required.

Purpose -
This question typically is asked by the interviewer to understand if you have the skills and experience for the job.

Approach -
The primary focus of your answer should be to match your qualifications, certifications, experience and skills with their job needs. Mention key strengths and give examples that connect with the company and the job requirements.

Pre-work -
You should do detail research on the company and job posting to effectively answer this question.

This is a very common interview question be prepared to answer it.

ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.

a.Direct interaction with customers: The retailer acts as the final link between the organisation and its customer. The retailer knows his customer better than anyone. He even suggests the customer what to purchase and allows him credit facilities to encourage frequent buying behaviour in the customer.

b.Small purchases: The customer purchases goods in small lots from the retail stores. So there are frequent visits to the retail store by the customer.

c.Instrument of marketing communication: via which information about the product is disseminated to the needy customers

DLR is a runtime environment that allows you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of services, such as expression trees, call site caching, and dynamic object interoperability to the CLR.

The System.Dynamic and System.Runtime.CompilerServices namespaces are used to hold the classes for DLR. It also provides dynamic features to statically-typed languages, such as C# and Visual Basic to enable their interoperation with dynamic languages.

If you're attempting to give an answer that is as unrevealing as possible, try something like this:

  " I have been a dedicated,loyal,hardworking employee throughout my career and nothing in my personal life-family obligations, hobbies, or volunteer work-has ever affected my performance. Nor would I ever expect it to."