The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
What are the desirable properties of a decomposition
Tree structures are used to store data in
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
The set of all values that can be taken by the attribute is called as _______ of the attribute.
The normalization was first proposed by .
The cost of reading and writing temporary files while evaluating a query can be reduced by
In E-R Diagram total participation is represented by
Cascading rollback is avoided in all protocol except
In SQL the word natural can be used with
The middleware databases in which the business rules act are applicable to _______ tier architectures
Key to represent relationship between tables is called
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
DBMS is a collection of _____ that enables user to create and maintain a database.
A relational database developer refers to a record as
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
operator is used to compare a value to a list of literals values that have been specified.
In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
SQL server stores index information in the _____system table
The rule that a value of a foreign key must appear as a value of some specific table is called a
A _____ is used to define overall design of the database
Maximum height of a B+ tree of order m with n key values is
Which of the following is true for network structure?
The data models defined by ANSI/SPARC architecture are
Which one is correct statement?Logical data independence provides following without changing application…
The drawback of shadow paging technique are
Relational Algebra is
Which of the following relational algebraic operations is not from set theory?
Which of the following aggregate functions does not ignore nulls in its results?.
Shadow paging has
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter