How would you design a database for an e-commerce website?
- 1 Answers
- 462 Views
- I also Faced
- E-Mail Answers
• 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 |
Can a formula column referred to columns in higher group ?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
How would you extract DDL of a table without using a GUI tool?
Explain the use of show option in imp command.
Which database is better for os platform dependency?
What happens if the imported table already exists?
Explain the use of rows option in exp command.
what r tyhe major differences between oracle 9i & 10g?
Explain an index segment?
How to retrieve the count of updated rows?
What is the recommended interval at which to run statspack snapshots, and why?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Oracle General 
