⟩ Tables derived from the ERD?
a) Are totally unnormalised
b) Are always in 1NF
c) Can be further denormalised
d) May have multi-valued attributes
(b) Are always in 1NF
a) Are totally unnormalised
b) Are always in 1NF
c) Can be further denormalised
d) May have multi-valued attributes
(b) Are always in 1NF
When invoking this procedure, you encounter the error?
Explain UNION, MINUS, UNION ALL and INTERSECT?
How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?
What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?
Read the following code
How would the developer define this variable using referential datatypes?
The CHECK_THEATER trigger of the THEATER table has been disabled. Which command can you issue to enable this trigger?
What is correlated sub-query?
Which of the following statements is true about implicit cursors?
What is the fastest way of accessing a row in a table?