a) is in 1NF
b) is in 2NF
c) is in 3NF
d) is in BCNF
(a) is in 1NF since (AC)+ = { A, B, C} hence AC is the primary key. Since C B is a FD given, where neither C is a Key nor B is a prime attribute, this it is not in 3NF. Further B is not functionally dependent on key AC thus it is not in 2NF. Thus the given FDs is in 1NF.
What is difference between TRUNCATE & DELETE?
If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
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?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
