FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes.

Stored Procedures are called by the programmer wherever it wants to fire and
the stored procedures used in the database independently.
To use stored procedure you have to make a call to that procedure.

No, Because whenever we create clustered index on a table it physically sorts the column values, so another
clustered index is not possible.

2-tier - also called client/server applications which consist of two separate applications, one server application
 (typically a database server like Oracle, MSSQL or any other standalone database) and a client application.
suppose  you want to have many different clients for front-end would be unwise to copy all the business logic
(all the rules of your application) to each client app.,. so its better to create a middle layer containing the business logic, and then let the clients talk with this middle layer. Thus the clients can relatively easily be
changed for other types of clients, without need for remembering how was the business logic put together.

3-tier architeture where one tier is the backend database engine, one is the front end client and one is just in
between them, also named the application server or business logic node.its uses mainly Load balancing and
Fault tolerance.

DTS (Data Transformation Services) comes under Integration Service.DTS Import and
export wizard lets us to import and export from external data source DTS has two major components: -> DTP Data Transformation Pipeline -> DTR Data Transformation Runtime