The statement that is executed automatically by the system as a side effect of the modification of the database is
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
Data items grouped together for storage purposes are called a
Relational Algebra does not have
In b-tree the number of keys in each node is than the number of its children.
operator is used to compare a value to a list of literals values that have been specified.
Relationships among relationships can be represented in an-E-R model using
_____clause is an additional filter that is applied to the result.
______contains information that defines valid values that are stored in a column or data type.
The one guideline to be followed while designing the database is
Shadow paging has
DBMS is a collection of _____ that enables user to create and maintain a database.
Change Staff table by removing default of Assistant for position column
In SQL the word natural can be used with
Which is the best file organization when data is frequently added or deleted from a file?
______is a special type of integrity constraint that relates two relations & maintains consistency across…
The full form of GUI is _________
For using a specific database command is used.
Which of the following is not a property of transactions?
Isolation of the transactions is ensured by
If the closure of an attribute set is the entire relation then the attribute set is a
In a relational schema, each tuple is divided into fields called
Which of the following addressing modes permits relocation without any change over in the code?
Which of the following is not a characteristic of a relational database model?
A logical schema
As per equivalence rules for query transformation, selection operation distributes over
Precedence graphs help to find a
The default level of consistency in SQL is
The drawback of shadow paging technique are
If an entity can belong to only one lower level entity then the constraint is
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter