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

Short-circuit evaluation-pl/sql expressions , Short-Circuit Evaluation ...

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

Enforce security in the database system, Question: (a) In the context o...

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Example of except operator - sql, Example of EXCEPT Operator - SQL Ex...

Example of EXCEPT Operator - SQL Example, like its counterpart in the theory book, illustrates the convenience of allowing any table expression to be the source for an INSERT

Remote operations in pl sql, Remote Operations: As the illustration sh...

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Iteration schemes- iterative control, Iteration Schemes The bounds of a ...

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Functions in pl/sql, Functions   The function is a subprogram that cal...

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Updating tables in sql, Updating Tables in SQL The topic of updating b...

Updating Tables in SQL The topic of updating by describing the assignment operator, ":=" in Tutorial D. SQL uses a different syntax for assignment, using the key word SET and

Using operator deref - manipulating objects in pl sql, Using Operator DEREF...

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Using extend - collection method, Using EXTEND To enlarge the size of ...

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

What are decision support systems, (a) What are decision support systems, a...

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

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