Technology Questions

UDP (User Datagram Protocol) is a communications protocol that offers a limited amount of service when messages are exchanged between computers in a network that uses the Internet Protocol (IP).

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

HTML 5 does not use SGML or XHTML it’s completely a new thing so you do not need to refer DTD. For HTML 5 you just need to put the below doctype code which makes the browser identify that this is a HTML 5 document.

Check EIBRESP after the call or use the HANDLE condition.

Htmlentities() converts all applicable characters to HTML entities. While htmlspecialcharacter()converts special characters to HTML entities. This means htmlentities( ) will check for non English language characters, such as French accents, the German umlaut, etc.

1)Divide by zero        – This is raised when any number is attempted to divide by zero.

2)TOO MANY ROWS   - A SELECT INTO statement returns more than one row.

3)CASE_NOT_FOUND - No choice in the WHEN clause of a case statement is selected.

4)LOGIN_DENIED      - An attempt to login with an invalid username or password.

5)PROGRAM_ERROR  - An internal PL/SQL problem.

Java uses primitive data types and hence is not a pure object oriented language.

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.