Related Questions
What is the correct answer?
4
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
What is the correct answer?
4
In SQL, testing whether a subquery is empty is done using
What is the correct answer?
4
Dependency preservation is not guaranteed in
What is the correct answer?
4
The one guideline to be followed while designing the database is
A. A database design may be ambiguous.
B. It should avoid/reduce the redundancy.
C. Unrelated data should be in the same table so that updating the data will be easy.
D. An entity should not have attributes.
What is the correct answer?
4
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
What is the correct answer?
4
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
A. Domain Integrity Constraints
B. Referential Integrity Constraints
D. Entity Integrity Constraints
What is the correct answer?
4
The data in the database at a particular moment of time is called the _______
What is the correct answer?
4
Tree structures are used to store data in
What is the correct answer?
4
Which of the following concurrency control schemes is not based on the serializability property?
C. Time-stamp based locking
What is the correct answer?
4
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
What is the correct answer?
4
If a transaction T has obtained an exclusive lock on item Q, then T can
D. write Q but not read Q
What is the correct answer?
4
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.
What is the correct answer?
4
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
What is the correct answer?
4
The normal form that is not necessarily dependency preserving is
What is the correct answer?
4
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
A. Oval; An oval with an underlined attribute
B. Circle; A circle with bolded attribute inside it
C. Diamond; A bolded attribute
D. Square; An attribute within the square
What is the correct answer?
4
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
What is the correct answer?
4
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
What is the correct answer?
4
In a relational schema, each tuple is divided into fields called
What is the correct answer?
4
If an entity can belong to only one lower level entity then the constraint is
What is the correct answer?
4
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
C. SQL server service manager
What is the correct answer?
4
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
B. Multi-valued dependency
What is the correct answer?
4
______contains information that defines valid values that are stored in a column or data type.
What is the correct answer?
4
The values of the attribute describes a particular
What is the correct answer?
4
Isolation of the transactions is ensured by
A. Transaction management
B. Application programmer
What is the correct answer?
4
Maximum height of a B+ tree of order m with n key values is
What is the correct answer?
4
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A. It will result in a deadlock situation.
B. It will immediately be rejected.
C. It will immediately be granted.
D. It will be granted as soon as it is released by A .
What is the correct answer?
4
A ______ module is typically designed so that it will run on a user workstation or personal computer.
What is the correct answer?
4
Which of the following is true for network structure?
A. It is a physical representation of the data.
B. It allows many to many relationship.
C. It is conceptually simple.
D. It will be the dominant database of the future.
What is the correct answer?
4
____specifies a search condition for a group or an aggregate.
What is the correct answer?
4
………………… approach reduces time and effort required for design and lesser risk in database management.
A. Single global database