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
  1. ______ keyword is used to find the number of values in a column.
  2. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  3. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  4. Which of the following is not a recovery technique?
  5. Key to represent relationship between tables is called
  6. SQL server stores index information in the _____system table
  7. In SQL the statement select * from R, S is equivalent to
  8. Which of the following statement on the view concept in SQL is invalid?
  9. The normal form that is not necessarily dependency preserving is
  10. Which normal form is considered adequate for normal relational database design?
  11. The common column is eliminated in
  12. The values of the attribute describes a particular
  13. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  14. _____clause is an additional filter that is applied to the result.
  15. DBMS helps achieve
  16. Which of the following is not comparison operator?
  17. The default level of consistency in SQL is
  18. Which of the following constitutes a basic set of operations for manipulating relational data?
  19. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  20. Which of the following is not a consequence of non-normalized database?
  21. The data in the database at a particular moment of time is called the _______
  22. The full form of GUI is _________
  23. Processed data is called _____
  24. operator is used to compare a value to a list of literals values that have been specified.
  25. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  26. According to the levels of abstraction, the schema at the intermediate level is called
  27. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  28. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  29. Which of the following is not a consequence of concurrent operations?
  30. The normalization was first proposed by .