Home
You can do it
  1. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  2. _____is a full form of SQL.
  3. For using a specific database …………… command is used.
  4. Relational Algebra is
  5. In 2NF
  6. Which of the following is not a property of transactions?
  7. In b-tree the number of keys in each node is than the number of its children.
  8. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  9. A top-to-bottom relationship among the items in a database is established by a
  10. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  11. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  12. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  13. ………………… approach reduces time and effort required for design…
  14. Which of the following ensures the atomicity of the transaction?
  15. What are the desirable properties of a decomposition
  16. The part of a database management system which ensures that the data remains in a consistent state is
  17. In E-R Diagram total participation is represented by
  18. Tree structures are used to store data in
  19. _____ command can be used to modify a column in a table
  20. Which normal form is considered adequate for normal relational database design?
  21. Which of the following is not a characteristic of a relational database model?
  22. What is data integrity?
  23. Which of the following is not a consequence of non-normalized database?
  24. What is a disjoint less constraint?
  25. Which of the following is not a recovery technique?
  26. A transaction is in state after the final statement has been executed.
  27. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  28. Union operator is a :
  29. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  30. Which of the following statement on the view concept in SQL is invalid?