Technology Questions

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Too_many_rows.

No_Data_Found.

Zero_Error.

A foreign key is a reference to another table. It is used to establish relationships between tables. For example, relationship between employee and professor table. One employee can have multiple professors. The Primary key of employee becomes foreign key of professor.
Example:
create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) );

As far PHP concern it only support single Inheritance in scripting. we can also use interface to achieve multiple inheritance.

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.

Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL]

INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];

INDEX BY key_type;

Example:

TYPE studenttyp IS TABLE OF emp%ROWTYPE

INDEX BY BINARY_INTEGER;

stud_tab studenttyp;

Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL];

Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Varrays: Holds a fixed number of elements which can be changed in run time. 

They can be declared as:

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];

Example: TYPE Calendar IS VARRAY(366) OF DATE;

The Application Cache concept introduced by HTML5 means that a web application is cached, and accessible without an internet connection.

There are three advantages of Application Cache:

1.Offline browsing - users can use the application when they're offline

2.Speed - cached resources load faster

3.Reduced server load - the browser will only download updated/changed resources from the server

The flow chart gives a clear graphical representation of an implemented process. This makes the system simple to understand for all persons involved in the project. 

Monkey testing is a type of Black Box Testing used mostly at the Unit Level. In this tester enter the data in any format and check the software is not crashing. In this testing we use Smart monkey and Dumb monkey.

- Smart monkeys are used for load and stress testing, they will help in finding the bugs. They are very expensive to develop.

- Dumb monkey, they are important for basic testing. They help in finding those bugs which are having high severity. Dumb monkey are less expensive as compare to Smart monkeys.

Example: In phone number filed Symbols are entered.