Technology Questions

public delegate void Del<T>(T item);

Del<int> d1 = new Del<int>(Notify);

- Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables.
- A sub query is added in the where clause of the main query.

There can be two types of subqueries:
a.) Correlated sub query :
- It can reference column in a table listed in the from list of the outer query but is not as independent as a query.
b.) Non-Correlated sub query :
- Results of this sub query are submitted to the main query or parent query.
- It is independent like a query

XML templates are XML files such as XHTML files. XML templates includes the processing directives which affect how the template is rendered, and the template expressions which are substituted dynamically by various data.

Priority: concern with application from the business point of view. It answers  How quickly we need to fix the bug? Or How soon the bug should get fixed?

Severity: concern with functionality of application. It deals with the impact of the bug on the application.

Events keywords in Reports are:

For Classical Reports,

1.Initialization

2. At line-selection 

3. Start-of-selection 

4.Top-of-page 

5. At user-command 

6.End-of-selection 

7. End-of-page 

8.At Pfn

For Interactive Reports,

9.At line-selection 

10. Top-of-page during line selection

For LDB (Logical DataBase) Reports,

10. get 

11.put 

12. get table 

The new attributes provided in HTML5 for <form> are: 

a.) autocomplete

– It specifies if a form or input field should have autocomplete as on or off. 

– If autocomplete is on, the browser is able to fill the values based on the values filled by the user earlier. 

– autocomplete works for following input types: text, search, url, tel, email, password, datepickers, range, and color. 

b.) novalidate

- This is a boolean attribute. 

- When present, it signifies that the form-data should not be validated when submitted.

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

SQL is a structured query language while PL/SQL is an extension of SQL by introducing a procedural flow. PL/SQL has blocks of statements. PL/SQL works like other procedural languages and has concepts like control statements, sequential statements, exception handling etc.