DATA BASE MANAGEMENT SYSYTEM
DATA BASE MANAGEMENT SYSYTEM dbms (QNO1). A relation with redundancy can be refined by ----------- using with smaller relations that contain the same information but without redundancy A. Decomposing it B. Updating it C. Inserting it D. Deletion it The solution is : a (QNO2). Which of the following one is not an example of integrity constraints A. Functional dependency B. Multivalued dependency C. Join dependency D. Multilevel dependency The solution is : d (QNO3). Which of the following one is not caused by redundancy problems A. Redundant storage B. Update anomalies C. Insertion anomalies D. Multivalued dependency The solution is : d (QNO4). In a FD the right side contains only attributes that also appear on the left side is Called ________ A. Functional FD B. Trival FD C. Non functional FD D. Non trival The solution is : b (QNO5). ________ is more than one place within a database can occur A. Consistency B. Redundancy C. Durability D. Isolation The...