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. Protection of data from unauthorized Disclosure results in loss of _______
  2. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  3. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  4. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  5. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  6. DBMS helps achieve
  7. The _______ is a set of programs to use and / or modify this data.
  8. Isolation of the transactions is ensured by
  9. Immediate database modification technique uses
  10. Which of the following constitutes a basic set of operations for manipulating relational data?
  11. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  12. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  13. Cascading rollback is avoided in all protocol except
  14. When an E-R diagram is mapped to tables, the representation is redundant for
  15. An advantage of the database management approach is
  16. It is an abstraction through which relationships are treated as higher level entities
  17. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  18. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  19. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  20. ______ keyword is used to find the number of values in a column.
  21. The common column is eliminated in
  22. _____clause is an additional filter that is applied to the result.
  23. The part of a database management system which ensures that the data remains in a consistent state is
  24. _____ First proposed the process of normalization.
  25. The data in the database at a particular moment of time is called the _______
  26. In SQL the statement select * from R, S is equivalent to
  27. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  28. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  29. Which normal form is considered adequate for normal relational database design?
  30. The normalization was first proposed by .