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

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

You can do it
  1. _____clause is an additional filter that is applied to the result.
  2. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  3. Which normal form is considered adequate for normal relational database design?
  4. Processed data is called _____
  5. A transaction is in state after the final statement has been executed.
  6. The default level of consistency in SQL is
  7. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  8. The keyword to eliminate duplicate rows from the query result in SQL is
  9. A top-to-bottom relationship among the items in a database is established by a
  10. Which is the best file organization when data is frequently added or deleted from a file?
  11. Which of the following constitutes a basic set of operations for manipulating relational data?
  12. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  13. What is data integrity?
  14. Which of the following is not a consequence of concurrent operations?
  15. Which of the following is not a logical database structure?
  16. A data type or format is specified for each _________
  17. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  18. Manager salary details are hidden from the employee .This is
  19. _____ database is used to provide statistical information or summaries of values based on various criteria.
  20. DFD stands for
  21. Which of the following is not a characteristic of a relational database model?
  22. The cost of reading and writing temporary files while evaluating a query can be reduced by
  23. The middleware databases in which the business rules act are applicable to _______ tier architectures
  24. In SQL the word natural can be used with
  25. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  26. ______is a preferred method for enforcing data integrity
  27. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  28. Relational Algebra is
  29. An advantage of views is
  30. ____ table store information about database or about the system.