DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
- What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
- Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
- Drop Table cannot be used to drop a table referenced by a ______ constraint.
- The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
- Relations produced from an E-R model will always be
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- SQL server stores index information in the _____system table
- Data items grouped together for storage purposes are called a
- The ______ indexes are forced to store only record IDs in the data structure and require at least one…
- The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
- _____clause is an additional filter that is applied to the result.
- Relational Algebra does not have
- A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
- The part of a database management system which ensures that the data remains in a consistent state is
- What is data integrity?
- The clause alter table in SQL can be used to
- A ______ module is typically designed so that it will run on a user workstation or personal computer.
- ______contains information that defines valid values that are stored in a column or data type.
- A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
- Which of the following is true for network structure?
- Change Staff table by removing default of Assistant for position column
- Which of the following constitutes a basic set of operations for manipulating relational data?
- The one guideline to be followed while designing the database is
- An advantage of the database management approach is
- For correct behaviour during recovery, undo and redo operation must be
- Tree structures are used to store data in
- _____is a full form of SQL.
- Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
- If an entity can belong to only one lower level entity then the constraint is
- The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…