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 many types of synonyms in Oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Which is better Oracle or MS SQL? Why?
What is a dynamic performance view in oracle?
What are the differences between interval year to month and interval day to second?
How to define an explicit cursor in oracle?
What is PL/SQL ?
Can we use bind variables in oracle stored procedure?
interview questions with answer for cts
How to use "in out" parameter properly?
Can a property clause itself be based on a property clause ?