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

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

Procedures in pl/sql, Procedures   The procedure is a subprogram which...

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .

Transaction control, Transaction Control The Oracle is transaction orie...

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Compare sql and pl/sql, Question 1 . Compare SQL and PL/SQL Question 2 ...

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

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

Oracle development , Write a stored procedure that accepts the post code in...

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

Using delete - collection method, Using DELETE This process has three ...

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

How pl/sql resolves the calls? , How Calls Are Resolved? The figure sho...

How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di

S, Question 1. Update stock levels when the order is cancelled At times, c...

Question 1. Update stock levels when the order is cancelled At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a

Why use cursor variables, Why Use Cursor Variables ? Primarily, you use...

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

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