Types of evolution, PL-SQL Programming

Assignment Help:

TYPES OF EVOLUTION -

Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the result that no new populations are formed, but the descendent population is not genetically identical with its predecessor.

Microevolution                            :           Evolution of subspecies or geographic races.

Macroevolution                           :           Evolution of species and genera.

Megaevolution (Simpson 1953)   :            Evolution of families, order, classes and phylum.

Quantum evolution                     :                    (a) Evolution of higher taxonomic group such as orders and classes (b) Evolutionary processes operating above species level i.e., combination of macro and mega evolutions.

Phyletic evolution                       :                    The directional changes in the average character of a population. This is caused either due to adaptation to a shifting environment or due to increasing specialization for a particualr environment or improved adaptation in a constant environment.

Convergent evolution                  :                    Acquiring similar sets of characteristics in response to the adaptation to a common or similar environment by the individuals of two or more totally unrelated or distantly related groups. As a result, the organism with completely different body organization come to possess superficial resemblance.

Divergent evolution/                    :           Development of different structures from a common ancestral form.

adaptive radiation                                            Examples of adaptive radiation occurred on the isolated continent of Australia, where the diversity of habitats and the absence of competitors sparked an adaptive radiation of marsupials (pouched mammals).

Progressive evolution                 :           Development of complex and specialized structure from simpler forms.

Retrogressive evolution              :           Development of simpler structure from complex forms.

Parallel evolution                       :                     Organisms of different classes can acquire similar characters independently and separately to avail the similar environment. Parallel evolution occurs when genetically related species adapt to similar environmental changes in similar ways.

Co-evolution                               :           In nature, species frequently interact so closely that evolutionary changes in one species may cause evolutionary adjustments in others. This evolutionary interaction between organisms is called co-evolution.


Related Discussions:- Types of evolution

Delimiters, Delimiters A delimiter is a simple or compound symbol whi...

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Using exists - collection methods, Using EXISTS The EXISTS(n) returns ...

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

Overloading method in pl/sql, Overloading: Similar to packaged subprog...

Overloading: Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters diff

Fetch statement - syntax, FETCH Statement The FETCH statement retrieve ...

FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

Calculate the total shopper spending, Many of the reports generated from th...

Many of the reports generated from the system calculate the total dollars in purchases for a shopper. Complete the following steps to create a function named TOT_PURCH_SF that acce

Block structure in pl/sql, Block Structure The PL/SQL is a block-struct...

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

Subprograms, Subprograms The PL/SQL has two types of subprograms known ...

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp

Difference between 9i & 10g, Difference between 9i & 10G When Oracle r...

Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle

Sql query for testing triggers and stored procedures , Description: Dem...

Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

Example of groupby operator - sql, Example of GROUPBY Operator Example...

Example of GROUPBY Operator Example: How many students sat each exam, using GROUP BY, NATURAL LEFT JOIN, and COALESCE SELECT CourseId, COALESCE (n, 0) AS n FROM COURS

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd