A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be

A. the pin code

B. the last name

C. the compound key first name and last name

D. Tr from next page

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. The part of a database management system which ensures that the data remains in a consistent state is
  2. DBMS is a collection of _____ that enables user to create and maintain a database.
  3. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  4. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  5. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  6. Which of the following is a reason to model data?
  7. ______is a preferred method for enforcing data integrity
  8. A logical schema
  9. Relational Algebra is
  10. ………………… approach reduces time and effort required for design…
  11. Which one is correct statement?Logical data independence provides following without changing application…
  12. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  13. Tree structures are used to store data in
  14. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  15. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  16. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  17. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  18. E-R Modeling is achieved by using ____ diagrams
  19. The keyword to eliminate duplicate rows from the query result in SQL is
  20. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  21. Manager salary details are hidden from the employee .This is
  22. DROP is a statement in SQL.
  23. If a transaction T has obtained an exclusive lock on item Q, then T can
  24. Change Staff table by removing default of Assistant for position column
  25. In b-tree the number of keys in each node is than the number of its children.
  26. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  27. In multiple granularity of locks SIX lock is compatible with
  28. ______contains information that defines valid values that are stored in a column or data type.
  29. Shadow paging has
  30. Which of the following concurrency control schemes is not based on the serializability property?