How would you design a database for an e-commerce website?
• Tables Needed:
o Users: Stores user info.
o Products: Stores product details.
o Orders: Stores order history.
o Payments: Stores payment transactions.
• Use indexes for fast lookups.
• Implement ACID transactions for financial data.
• Use sharding for high-traffic scaling.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by a database object? Can you list a few of them?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is backup in Oracle?
Why is oracle used?
What is oracle datasource?
How many memory layers are in the oracle shared pool?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Explain view?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
what is difference between table and view? where to use views? thanks in advance!
What are the components of Logical database structure of ORACLE database?