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

Using raise_application_error - user-defined exceptions, Using raise_applic...

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Parameter and keyword description - packages, Parameter and Keyword Descrip...

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

Variables and constants in pl/sql, V ariables and Constants in PL/SQL ...

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Expression in assignment statement - pl sql, Expression: This is a ran...

Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Goto statement - syntax, GOTO Statement   The GOTO statement branches ...

GOTO Statement   The GOTO statement branches categorically to a block label or statement label. The label should be exclusive within its scope and should precede a PL/SQL bloc

Left and right joins, Left and Right Joins LEFT OUTER JOIN can be used...

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Calculate days between ordering and shipping, An analyst in the quality ass...

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

Using operator value in pl sql, Using Operator VALUE: As you may expec...

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

Rownum - sql pseudocolumns, ROWNUM The ROWNUM returns a number represe...

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Using bulk collect clause- bulk bind performance improvement, Using the BUL...

Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

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