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

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

You can do it
  1. In an E-R diagram double lines indicate
  2. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  3. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  4. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  5. In 2NF
  6. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  7. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  8. Which is the best file organization when data is frequently added or deleted from a file?
  9. ………………… approach reduces time and effort required for design…
  10. ______contains information that defines valid values that are stored in a column or data type.
  11. Which of the following is not a logical database structure?
  12. The data models defined by ANSI/SPARC architecture are
  13. Which one is true statement :
  14. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  15. In a relational schema, each tuple is divided into fields called
  16. The one guideline to be followed while designing the database is
  17. When an E-R diagram is mapped to tables, the representation is redundant for
  18. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  19. The keyword to eliminate duplicate rows from the query result in SQL is
  20. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  21. ______is a preferred method for enforcing data integrity
  22. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  23. Immediate database modification technique uses
  24. The collection of information stored in a database at a particular moment is called as ......
  25. _____ First proposed the process of normalization.
  26. For correct behaviour during recovery, undo and redo operation must be
  27. Which normal form is considered adequate for normal relational database design?
  28. An advantage of views is
  29. The cost of reading and writing temporary files while evaluating a query can be reduced by
  30. operator is used to compare a value to a list of literals values that have been specified.