………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
- 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