Home

Which two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

You can do it
  1. Key to represent relationship between tables is called
  2. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  3. Precedence graphs help to find a
  4. What is a disjoint less constraint?
  5. In multiple granularity of locks SIX lock is compatible with
  6. Which of the following is true for network structure?
  7. Which of the following is not a property of transactions?
  8. For using a specific database command is used.
  9. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  10. Which of the following constitutes a basic set of operations for manipulating relational data?
  11. For correct behaviour during recovery, undo and redo operation must be
  12. An advantage of views is
  13. Cascading rollback is avoided in all protocol except
  14. A _____ is a logical unit of database processing that includes one or more data access operations that…
  15. Which normal form is considered adequate for normal relational database design?
  16. DBMS helps achieve
  17. Which one is correct statement?Logical data independence provides following without changing application…
  18. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  19. If the closure of an attribute set is the entire relation then the attribute set is a
  20. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  21. Which of the following is not a recovery technique?
  22. It is an abstraction through which relationships are treated as higher level entities
  23. The _______ is a set of programs to use and / or modify this data.
  24. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  25. What is data integrity?
  26. Change Staff table by removing default of Assistant for position column
  27. In a relational schema, each tuple is divided into fields called
  28. Relations produced from an E-R model will always be
  29. In SQL the word natural can be used with
  30. The normal form that is not necessarily dependency preserving is