Home

DROP is a statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

You can do it
  1. In SQL, testing whether a subquery is empty is done using
  2. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  3. Which of the following is not a logical database structure?
  4. Relational Algebra is
  5. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  6. The common column is eliminated in
  7. Isolation of the transactions is ensured by
  8. The default level of consistency in SQL is
  9. If an entity can belong to only one lower level entity then the constraint is
  10. Which of the following constitutes a basic set of operations for manipulating relational data?
  11. Data independence means
  12. In an E-R diagram double lines indicate
  13. Which of the following is a reason to model data?
  14. Precedence graphs help to find a
  15. The graphical representation of a query is .
  16. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  17. Key to represent relationship between tables is called
  18. Which of the following addressing modes permits relocation without any change over in the code?
  19. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  20. Relationships among relationships can be represented in an-E-R model using
  21. Checkpoints are a part of
  22. A table can have only one
  23. _____is a full form of SQL.
  24. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  25. Relational Algebra does not have
  26. In SQL the word natural can be used with
  27. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  28. In b-tree the number of keys in each node is than the number of its children.
  29. Union operator is a :
  30. The language that requires a user to specify the data to be retrieved without specifying exactly how…