⟩ Tell me what is a constraint? And its types?
☛ Constraint is a rule imposed on data.
☛ Different types of constraint:
☛ Primary key
☛ Unique
☛ Not null
☛ Foreign key
☛ Composite foreign key
☛ Check constraint
☛ Constraint is a rule imposed on data.
☛ Different types of constraint:
☛ Primary key
☛ Unique
☛ Not null
☛ Foreign key
☛ Composite foreign key
☛ Check constraint
You have just compiled a PL/SQL package but got errors, how would you view the errors?
How can you enable a trace for a session?
What is the difference between the SQL*Loader and IMPORT utilities?
What are the options available to refresh snapshots?
What is a database schema?
What is a SNAPSHOT LOG?
What is Distributed database?
What are the basic element of Base configuration of an oracle Database?
What is database clusters?
What is an Index? How it is implemented in Oracle Database?