Home

Which of the following statement on the view concept in SQL is invalid?

A. All views are not updateable

B. The views may be referenced in an SQL statement whenever tables are referenced.

C. The views are instantiated at the time they are referenced and not when they are defined.

D. The definition of a view should not have GROUP BY clause in it.

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

You can do it
  1. DBMS is a collection of _____ that enables user to create and maintain a database.
  2. The one guideline to be followed while designing the database is
  3. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  4. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  5. Isolation of the transactions is ensured by
  6. DFD stands for
  7. A data type or format is specified for each _________
  8. Which of the following is a reason to model data?
  9. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  10. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  11. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  12. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  13. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  14. A _____ is a logical unit of database processing that includes one or more data access operations that…
  15. Key to represent relationship between tables is called
  16. As per equivalence rules for query transformation, selection operation distributes over
  17. Which of the following addressing modes permits relocation without any change over in the code?
  18. The keyword to eliminate duplicate rows from the query result in SQL is
  19. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  20. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  21. ____ table store information about database or about the system.
  22. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  23. The middleware databases in which the business rules act are applicable to _______ tier architectures
  24. Dependency preservation is not guaranteed in
  25. _____ database is used to provide statistical information or summaries of values based on various criteria.
  26. Which of the following is not a logical database structure?
  27. Wait-for graph is used for
  28. ______is a preferred method for enforcing data integrity
  29. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  30. Shadow paging has