⟩ What is extension and intension?
Extension - It is the number of tuples present in a table at any instance. This is time dependent.
Intension - It is a constant value that gives the name, structure of table and the constraints laid on it.
Extension - It is the number of tuples present in a table at any instance. This is time dependent.
Intension - It is a constant value that gives the name, structure of table and the constraints laid on it.
Examine this function
What is the difference between Truncate and Delete interms of Referential Integrity?
What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;?
What is the parameter substitution symbol used with INSERT INTO command?
What is referential integrity constraint?
What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?
What is SQL ROWID?
Explain CONNECT BY PRIOR?
What is ON DELETE CASCADE?
For which trigger timing can you reference the NEW and OLD qualifiers?