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