Questions

Data Definition Language (DDL):- are the SQL statements that define the database structure.

Example:

1.  CREATE


2.  ALTER


3.  DROP


4.  TRUNCATE


5.  COMMENT


6.  RENAME

When water is cooled from 4°C to 0°C, its density decreases.

When water cools from 4°C to 0°C, ice crystals begin to form because the water is approaching its freezing point. When water freezes, the water molecules form a lattice that increases the volume. As a result, the density decreases. This is why ice will float on top of water; ice has a lower density than the water.

The scarcity definition of economics is credited to Lionel Robbins.

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.