Home

Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.

A. UPDATE S CITY = KANPUR WHERE SNO=S1

B. UPDATE S SET CITY = KANPUR FOR SNO=S1

C. UPDATE S SET CITY = KANPUR WHERE SNO=S1

D. UPDATE S RENAME CITY = KANPUR WHERE SNO=S1

Related Questions

  1. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  2. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  3. Relations produced from an E-R model will always be
  4. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  5. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  6. DBMS helps achieve
  7. Data independence means
  8. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  9. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  10. Which of the following is true for network structure?
  11. Relationships among relationships can be represented in an-E-R model using
  12. In E-R Diagram total participation is represented by
  13. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  14. A relational database developer refers to a record as
  15. Which of the following is not a recovery technique?
  16. Which of the following addressing modes permits relocation without any change over in the code?
  17. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  18. Relational Algebra does not have
  19. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  20. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  21. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  22. The clause alter table in SQL can be used to
  23. Tree structures are used to store data in
  24. ____ table store information about database or about the system.
  25. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  26. The data models defined by ANSI/SPARC architecture are
  27. Union operator is a :
  28. If a transaction T has obtained an exclusive lock on item Q, then T can
  29. The full form of GUI is _________
  30. Which of the following ensures the atomicity of the transaction?

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