………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
None of the above
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Which two files are used during operation of the DBMS?
The default level of consistency in SQL is
For correct behaviour during recovery, undo and redo operation must be
The statement that is executed automatically by the system as a side effect of the modification of the…
Which of the following is not comparison operator?
Immediate database modification technique uses
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
An advantage of the database management approach is
____specifies a search condition for a group or an aggregate.
An outstanding functionality of SQL is its support for automatic_____ to the target data.
The drawback of shadow paging technique are
Change Staff table by removing default of Assistant for position column
In SQL the statement select * from R, S is equivalent to
DBMS helps achieve
A relational database developer refers to a record as
The normal form that is not necessarily dependency preserving is
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
The keyword to eliminate duplicate rows from the query result in SQL is
………………… approach reduces time and effort required for design…
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
______is a special type of integrity constraint that relates two relations & maintains consistency across…
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
The common column is eliminated in
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
It is an abstraction through which relationships are treated as higher level entities
The middleware databases in which the business rules act are applicable to _______ tier architectures
Which of the following is true for network structure?
In SQL, testing whether a subquery is empty is done using
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter