Home

_____ is a utility to capture a continuous record of server activity and provide auditing capability.

A. SQL server Profile

B. SQL server wizard.

C. SQL server service manager

D. SQL server setup

Correct Answer : C.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

You can do it yup
  1. Data items grouped together for storage purposes are called a
  2. Isolation of the transactions is ensured by
  3. The data models defined by ANSI/SPARC architecture are
  4. Which of the following is not a property of transactions?
  5. Which of the following concurrency control schemes is not based on the serializability property?
  6. Which of the following addressing modes permits relocation without any change over in the code?
  7. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  8. DBMS helps achieve
  9. In an ER model,_____ is described in the database by storing its data.
  10. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  11. _____ First proposed the process of normalization.
  12. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  13. What are the desirable properties of a decomposition
  14. Change Staff table by removing default of Assistant for position column
  15. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  16. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  17. The metadata is created by the
  18. As per equivalence rules for query transformation, selection operation distributes over
  19. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  20. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  21. _____clause is an additional filter that is applied to the result.
  22. The statement that is executed automatically by the system as a side effect of the modification of the…
  23. If a transaction T has obtained an exclusive lock on item Q, then T can
  24. DFD stands for
  25. For correct behaviour during recovery, undo and redo operation must be
  26. The normalization was first proposed by .
  27. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  28. DBMS is a collection of _____ that enables user to create and maintain a database.
  29. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  30. Grant and revoke are _____ statements.