⟩ Explain BCNF (Boyce-Codd Normal Form)?
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X --> A, X must be a candidate key.
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X --> A, X must be a candidate key.
What are the wildcards used for pattern matching.?
TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ?
What is a join? Explain the different types of sql joins?
What is SQL injection?
What are the data types allowed in a table?
What is the usage of SAVEPOINTS?
What is an integrity constraint?
Where the integrity constraints are stored in data dictionary?
How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?
Difference between SUBSTR and INSTR?