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 |
How to put more than 1000 values into an oracle in clause?
What is a Tablespace?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to drop a stored procedure in oracle?
What are the different types of failures that occur in Oracle database?
What are the advantages of oracle 12c?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is the meaning of recursive hints in oracle?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How do we display rows from the table without duplicates?
How do I uninstall oracle 11g?