DBMS & SQL

1. Which of the following is NOT a type of DBMS? TRE 4.0 DBMS Quiz Practice Set 1 2. In a relational database, what is a primary key? TRE 4.0 DBMS Quiz Practice Set 1 3. Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? TRE 4.0 DBMS Quiz Practice Set 1 4. Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? TRE 4.0 DBMS Quiz Practice Set 1 5. Which of the following is a disadvantage of using a distributed database system? TRE 4.0 DBMS Quiz Practice Set 1 6. Which data model organizes data in the form of a tree structure? TRE 4.0 DBMS Quiz Practice Set 1 7. Which key is used to establish a relationship between two relational database tables? TRE 4.0 DBMS Quiz Practice Set 1 8. Which normal form requires that all attribute values in a relation be atomic? TRE 4.0 DBMS Quiz Practice Set 1 9. Which normal form requires that all attribute values in a relation be atomic? TRE 4.0 DBMS Quiz Practice Set 1 10. What is a distributed database system? TRE 4.0 DBMS Quiz Practice Set 1 11. Which of the following is the primary purpose of a DBMS? TRE 4.0 DBMS Quiz Practice Set 1 12. What is a candidate key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 13. Which normal form eliminates transitive functional dependencies? TRE 4.0 DBMS Quiz Practice Set 1 14. Which normal form eliminates transitive functional dependencies? TRE 4.0 DBMS Quiz Practice Set 1 15. Which technique is used to maintain copies of data at multiple sites in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 16. Which of the following is an example of a Relational Database Management System? TRE 4.0 DBMS Quiz Practice Set 1 17. What is a super key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 18. Which normal form is based on the condition that every determinant must be a candidate key? TRE 4.0 DBMS Quiz Practice Set 1 19. Which normal form is based on the condition that every determinant must be a candidate key? TRE 4.0 DBMS Quiz Practice Set 1 20. What is horizontal fragmentation in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 21. In a relational database, a row is also known as: TRE 4.0 DBMS Quiz Practice Set 1 22. Which of the following statements is correct about a composite key? TRE 4.0 DBMS Quiz Practice Set 1 23. What is the main purpose of database normalization? TRE 4.0 DBMS Quiz Practice Set 1 24. What is the main purpose of database normalization? TRE 4.0 DBMS Quiz Practice Set 1 25. What is vertical fragmentation in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 26. Which key uniquely identifies each record in a database table? TRE 4.0 DBMS Quiz Practice Set 1 27. Which constraint prevents duplicate values in a database column? TRE 4.0 DBMS Quiz Practice Set 1 28. Which of the following is NOT a type of database anomaly? TRE 4.0 DBMS Quiz Practice Set 1 29. Which of the following is NOT a type of database anomaly? TRE 4.0 DBMS Quiz Practice Set 1 30. Which property ensures that a distributed transaction is completed entirely or not at all? TRE 4.0 DBMS Quiz Practice Set 1 31. Which database model allows a record to have multiple parent records? TRE 4.0 DBMS Quiz Practice Set 1 32. Which type of key can contain NULL values in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 33. Which normal form deals with multivalued dependencies? TRE 4.0 DBMS Quiz Practice Set 1 34. Which normal form deals with multivalued dependencies? TRE 4.0 DBMS Quiz Practice Set 1 35. Which protocol is commonly used to ensure atomic commitment of distributed transactions? TRE 4.0 DBMS Quiz Practice Set 1 36. What is the full form of SQL? TRE 4.0 DBMS Quiz Practice Set 1 37. What is an alternate key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 38. Which normal form is concerned with join dependencies? TRE 4.0 DBMS Quiz Practice Set 1 39. Which normal form is concerned with join dependencies? TRE 4.0 DBMS Quiz Practice Set 1 40. What is the main purpose of a distributed database transparency? TRE 4.0 DBMS Quiz Practice Set 1 41. Which property of a DBMS ensures that data remains accurate and consistent? TRE 4.0 DBMS Quiz Practice Set 1 42. Which key is formed by combining two or more foreign keys? TRE 4.0 DBMS Quiz Practice Set 1 43. What is a partial functional dependency in database normalization? TRE 4.0 DBMS Quiz Practice Set 1 44. What is a partial functional dependency in database normalization? TRE 4.0 DBMS Quiz Practice Set 1 45. Which type of distributed database has a single logical schema but multiple physical data locations? TRE 4.0 DBMS Quiz Practice Set 1 46. Which of the following is a major advantage of using a DBMS? TRE 4.0 DBMS Quiz Practice Set 1 47. Which of the following is NOT a property of a primary key? TRE 4.0 DBMS Quiz Practice Set 1 48. Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? TRE 4.0 DBMS Quiz Practice Set 1 49. Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? TRE 4.0 DBMS Quiz Practice Set 1 50. Which of the following can improve the availability of a distributed database? TRE 4.0 DBMS Quiz Practice Set 1