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.

You can do it
  1. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  2. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  3. The cost of reading and writing temporary files while evaluating a query can be reduced by
  4. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  5. Which two files are used during operation of the DBMS?
  6. In SQL the statement select * from R, S is equivalent to
  7. The full form of GUI is _________
  8. The transactions like adding an employee, enrolling a student in a course are examples of _______
  9. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  10. Which of the following constitutes a basic set of operations for manipulating relational data?
  11. _____ command can be used to modify a column in a table
  12. The statement that is executed automatically by the system as a side effect of the modification of the…
  13. Immediate database modification technique uses
  14. Which of the following statement on the view concept in SQL is invalid?
  15. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  16. Checkpoints are a part of
  17. The rule that a value of a foreign key must appear as a value of some specific table is called a
  18. If a transaction T has obtained an exclusive lock on item Q, then T can
  19. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  20. _____ First proposed the process of normalization.
  21. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  22. For using a specific database command is used.
  23. A PHP Error was encountered

    Severity: Notice

    Message: iconv_strlen(): Detected an illegal character in input string

    Filename: compat/mbstring.php

    Line Number: 77

    Backtrace:

    File: /var/www/html/application/views/discuss.php
    Line: 226
    Function: character_limiter

    File: /var/www/html/application/helpers/viewloader_helper.php
    Line: 1359
    Function: view

    File: /var/www/html/application/controllers/Questions.php
    Line: 484
    Function: load_guest

    File: /var/www/html/index.php
    Line: 315
    Function: require_once

    If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship between X and Y is
  24. In SQL, testing whether a subquery is empty is done using
  25. Change Staff table by removing default of Assistant for position column
  26. If an entity can belong to only one lower level entity then the constraint is
  27. Which of the following addressing modes permits relocation without any change over in the code?
  28. Protection of data from unauthorized Disclosure results in loss of _______
  29. Which one is true statement :
  30. An advantage of the database management approach is