Home

In an E-R diagram double lines indicate

A. Total participation.

B. Multiple participation.

C. Cardinality N.

D. None of the above.

You can do it
  1. Which of the following is not a logical database structure?
  2. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  3. In E-R Diagram total participation is represented by
  4. A _____ is a logical unit of database processing that includes one or more data access operations that…
  5. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  6. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  7. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  8. In a relational schema, each tuple is divided into fields called
  9. A _____ is used to define overall design of the database
  10. DROP is a statement in SQL.
  11. ______contains information that defines valid values that are stored in a column or data type.
  12. ____ table store information about database or about the system.
  13. Change Staff table by removing default of Assistant for position column
  14. An advantage of views is
  15. Tree structures are used to store data in
  16. Which of the following relational algebraic operations is not from set theory?
  17. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  18. If a transaction T has obtained an exclusive lock on item Q, then T can
  19. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  20. In multiple granularity of locks SIX lock is compatible with
  21. The one guideline to be followed while designing the database is
  22. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  23. Cascading rollback is avoided in all protocol except
  24. Checkpoints are a part of
  25. Shadow paging has
  26. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  27. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  28. A table can have only one
  29. Which is the best file organization when data is frequently added or deleted from a file?
  30. The full form of GUI is _________