⟩ Spurious tuples may occur due to?
i. Bad normalization
ii. Theta joins
iii. Updating tables from join
a) i & ii b) ii & iii
c) i & iii d) ii & iii
(a) i & iii because theta joins are joins made on keys that are not primary keys.
Question and Answer:
Home RDBMS
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
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?
The command used to open a CURSOR FOR loop is?
