List of top Computer Science & Information Technology Questions on Database Concepts

Consider two tables R and S with cardinalities \(m\) and \(n\) respectively. What is the maximum cardinality of the result of relational algebraic operation \(R \cup S\)?
Which file organization is preferred for only insertion operations?
Which of the following protocol is the lock based mechanism for concurrency control?
Which file organization is best suited for insertion operation only?
Which is a dynamic tree based indexing structure for database?
Which data model is required for conceptual data design?
Which is the notation for weak entity set in ER diagram?
Which of the following is a binary operator in Relational Algebra?
Which operator can make a tuple relational query as an unsafe query?
First Normal Form is based on the concept of
Which of the following is the main reason for performing schema refinement?
Which is not a desirable property for a database transaction?
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R, it will
In a particular bank, a loan can belong to only one customer and a customer can have several loans. Then the relationship from customer to loans is
Register A holds the 8-bit binary 11011001. To change the value of Register A to 01101101, the following logic microoperation has to be performed on the operand respectively.
The number of clock cycles that it takes to process 200 tasks in a six-segment pipeline is
Which of the following is related to DBMS?
In a DBMS, a candidate which is not a primary key is called
In an RDBMS, data is represented as a set of
If a relation is in BCNF, then it is in
Referential integrity refers to which one of the following?
The number of CODD rules which characterize an RDBMS is
Which of the following is not a DBMS?