The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
- An outstanding functionality of SQL is its support for automatic_____ to the target data.
- An advantage of views is
- ______ keyword is used to find the number of values in a column.
- In an E-R diagram double lines indicate
- Manager salary details are hidden from the employee .This is
- Which of the following is not a property of transactions?
- The set of all values that can be taken by the attribute is called as _______ of the attribute.
- A _____ is a logical unit of database processing that includes one or more data access operations that…
- If an entity can belong to only one lower level entity then the constraint is
- DBMS is a collection of _____ that enables user to create and maintain a database.
- The _____ category includes storage media that can be operated on directly by the computers central…
- The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
- The normal form that is not necessarily dependency preserving is
- Tree structures are used to store data in
- Maximum height of a B+ tree of order m with n key values is
- _____ database is used to provide statistical information or summaries of values based on various criteria.
- In SQL the statement select * from R, S is equivalent to
- ______is a preferred method for enforcing data integrity
- Which of the following is not a consequence of concurrent operations?
- Which of the following addressing modes permits relocation without any change over in the code?
- ………………… approach reduces time and effort required for design…
- Change Staff table by removing default of Assistant for position column
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
- Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
- Which of the following is a reason to model data?
- The graphical representation of a query is .
- What is a disjoint less constraint?
- Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
- The statement that is executed automatically by the system as a side effect of the modification of the…