Home

If a transaction T has obtained an exclusive lock on item Q, then T can

A. read Q

B. write Q

C. both read and write Q

D. write Q but not read Q

You can do it
  1. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  2. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  3. A top-to-bottom relationship among the items in a database is established by a
  4. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  5. Isolation of the transactions is ensured by
  6. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  7. Relational Algebra does not have
  8. A _____ is a logical unit of database processing that includes one or more data access operations that…
  9. Which of the following relational algebraic operations is not from set theory?
  10. 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
  11. SQL server stores index information in the _____system table
  12. Change Staff table by removing default of Assistant for position column
  13. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  14. HSAM stands for .
  15. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  16. Data independence means
  17. Which of the following is not a logical database structure?
  18. In E-R Diagram total participation is represented by
  19. In 2NF
  20. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  21. Which of the following is a reason to model data?
  22. approach reduces time and effort required for design and lesser risk in database management.
  23. In b-tree the number of keys in each node is than the number of its children.
  24. The _______ is a set of programs to use and / or modify this data.
  25. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  26. In SQL the word natural can be used with
  27. The normalization was first proposed by .
  28. ____specifies a search condition for a group or an aggregate.
  29. For using a specific database command is used.
  30. If a transaction T has obtained an exclusive lock on item Q, then T can