⟩ Explain What are the differences between database designing and database modeling?
Database modeling comprises: discovery, design, documentation, communication, DDL generation, re engineering
Database modeling comprises: discovery, design, documentation, communication, DDL generation, re engineering
Explain What is a corelated subquery?
Explain How to drop the index?
What is a join in Oracle? Explain the different types of joins?
Explain What are the data types allowed in a table?
Explain How do we replace a comma (,) with a blank in a select statement?
Explain Can a view be updated/inserted/deleted?
Explain What are the different types of SQL?
Explain some PL/SQL Exceptions?
Explain What is a Cartesian product?
Explain What is an Integrity Constraint?