Home

An advantage of views is

A. Data security

B. Derived columns

C. Hiding of complex queries

D. All of the above

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Alligation or Mixture MCQ Hydrogen- Water and Hydrogen Peroxide MCQ Organic Chemistry MCQ Advanced Surveying MCQ Rearrangement Set 1 MCQ Chemical Bonding and Molecular Structure MCQ Mechanical Engineering MCQ Structural Organization In Animals MCQ Angiosperms (Taxonomy and Classification) MCQ Civil Engineering MCQ Puzzle MCQ Python Programming MCQ

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..
You can do it
  1. The rule that a value of a foreign key must appear as a value of some specific table is called a
  2. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  3. Which of the following is true for network structure?
  4. What is a disjoint less constraint?
  5. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  6. In b-tree the number of keys in each node is than the number of its children.
  7. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  8. Tree structures are used to store data in
  9. DBMS helps achieve
  10. DROP is a statement in SQL.
  11. In SQL, testing whether a subquery is empty is done using
  12. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  13. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  14. Which of the following is not a recovery technique?
  15. The one guideline to be followed while designing the database is
  16. If the closure of an attribute set is the entire relation then the attribute set is a
  17. Processed data is called _____
  18. The metadata is created by the
  19. As per equivalence rules for query transformation, selection operation distributes over
  20. Immediate database modification technique uses
  21. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  22. Which one is correct statement?Logical data independence provides following without changing application…
  23. In 2NF
  24. Shadow paging has
  25. An advantage of views is
  26. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  27. Manager salary details are hidden from the employee .This is
  28. When an E-R diagram is mapped to tables, the representation is redundant for
  29. Which of the following constitutes a basic set of operations for manipulating relational data?
  30. Which of the following statement on the view concept in SQL is invalid?