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

You can do it
  1. A transaction is in state after the final statement has been executed.
  2. SQL server stores index information in the _____system table
  3. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  4. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  5. Which of the following is not a consequence of non-normalized database?
  6. Which of the following is not a recovery technique?
  7. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  8. Change Staff table by removing default of Assistant for position column
  9. Which is the best file organization when data is frequently added or deleted from a file?
  10. Relations produced from an E-R model will always be
  11. For correct behaviour during recovery, undo and redo operation must be
  12. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  13. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  14. If the closure of an attribute set is the entire relation then the attribute set is a
  15. Which of the following statement on the view concept in SQL is invalid?
  16. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  17. Which of the following is a reason to model data?
  18. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  19. The clause alter table in SQL can be used to
  20. approach reduces time and effort required for design and lesser risk in database management.
  21. The graphical representation of a query is .
  22. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  23. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  24. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  25. In SQL, testing whether a subquery is empty is done using
  26. In an ER model,_____ is described in the database by storing its data.
  27. operator is used to compare a value to a list of literals values that have been specified.
  28. According to the levels of abstraction, the schema at the intermediate level is called
  29. Which one is true statement :
  30. The common column is eliminated in