The .sdf (SQL Database File) extension is used for storing structured data, including stock information in handheld systems. Other extensions like .fdf, .sds, or no extension are not standard database file formats used for this purpose in the context.