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.
Relational Algebra is
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
Protection of data from unauthorized Disclosure results in loss of _______
In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
DROP is a statement in SQL.
Manager salary details are hidden from the employee .This is
_____clause is an additional filter that is applied to the result.
Tree structures are used to store data in
The values of the attribute describes a particular
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
______is a preferred method for enforcing data integrity
A ______ module is typically designed so that it will run on a user workstation or personal computer.
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
Which one is true statement :
Wait-for graph is used for
Drop Table cannot be used to drop a table referenced by a ______ constraint.
The rule that a value of a foreign key must appear as a value of some specific table is called a
It is an abstraction through which relationships are treated as higher level entities
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
A transaction is in state after the final statement has been executed.
______is a special type of integrity constraint that relates two relations & maintains consistency across…
Change Staff table by removing default of Assistant for position column
In E-R Diagram total participation is represented by
The _____ category includes storage media that can be operated on directly by the computers central…
The common column is eliminated in
Relations produced from an E-R model will always be
Which of the following relational algebraic operations is not from set theory?
The one guideline to be followed while designing the database is
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
The clause alter table in SQL can be used to
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter