Home

Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C

A. (i) and (ii)

B. (iv) only

C. (i) and (iv)

D. (ii) and (iii)

You can do it
  1. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  2. The cost of reading and writing temporary files while evaluating a query can be reduced by
  3. DFD stands for
  4. Which of the following concurrency control schemes is not based on the serializability property?
  5. A transaction is in state after the final statement has been executed.
  6. Change Staff table by removing default of Assistant for position column
  7. An advantage of views is
  8. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  9. Which of the following statement on the view concept in SQL is invalid?
  10. A _____ is a logical unit of database processing that includes one or more data access operations that…
  11. In multiple granularity of locks SIX lock is compatible with
  12. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  13. The normal form that is not necessarily dependency preserving is
  14. In an ER model,_____ is described in the database by storing its data.
  15. As per equivalence rules for query transformation, selection operation distributes over
  16. Union operator is a :
  17. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  18. In SQL the statement select * from R, S is equivalent to
  19. What is a disjoint less constraint?
  20. The _____ category includes storage media that can be operated on directly by the computers central…
  21. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  22. The default level of consistency in SQL is
  23. Processed data is called _____
  24. A _____ is used to define overall design of the database
  25. ______is a preferred method for enforcing data integrity
  26. ____ table store information about database or about the system.
  27. E-R Modeling is achieved by using ____ diagrams
  28. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  29. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  30. The transactions like adding an employee, enrolling a student in a course are examples of _______