_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
______ keyword is used to find the number of values in a column.
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
Which of the following is not a recovery technique?
Key to represent relationship between tables is called
SQL server stores index information in the _____system table
In SQL the statement select * from R, S is equivalent to
Which of the following statement on the view concept in SQL is invalid?
The normal form that is not necessarily dependency preserving is
Which normal form is considered adequate for normal relational database design?
The common column is eliminated in
The values of the attribute describes a particular
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
_____clause is an additional filter that is applied to the result.
DBMS helps achieve
Which of the following is not comparison operator?
The default level of consistency in SQL is
Which of the following constitutes a basic set of operations for manipulating relational data?
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
Which of the following is not a consequence of non-normalized database?
The data in the database at a particular moment of time is called the _______
The full form of GUI is _________
Processed data is called _____
operator is used to compare a value to a list of literals values that have been specified.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
According to the levels of abstraction, the schema at the intermediate level is called
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
Which of the following is not a consequence of concurrent operations?
The normalization was first proposed by .