Crowdly
Add to Chrome
Database Systems(BCSE302L)
Looking for Database Systems(BCSE302L) test answers and solutions? Browse our comprehensive collection of verified answers for Database Systems(BCSE302L) at lms.vit.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
If a non key attribute depends on a non key attribute, it is called ______________ dependency
Assume that a file has 16384 records. One record size is 32 bytes, its key size is 6 bytes, its block size 1024 bytes, the size of a block pointer is 10 bytes and the file is ordered on a non-key field. The file organization is unspanned. If the secondary index is built on the key field of the file, and a multi-level index scheme is used to store the secondary index, find out the number of first-level and second-level blocks in the multi-level index
Rollback of transactions is normally used to :
For the given schedule, which of the
following statements is true about the schedule S?
S : r1, r2(x), r2
, r3
, w2(x), w1
, w3(x), r1(x)
Consider the following student table
Name
|
Age
|
Dept
|
Sex
|
Raji
|
21
|
CSE
|
F
|
Ravi
|
22
|
IT
|
M
|
Hassan
|
18
|
EEE
|
M
|
Choose the correct SQL query to create a composite index on age and sex
The schedules S1: {R1(X), R2(X), W1(X), W2(X)} and S2: {R2(X), R1(X), W1(X), W2(X)} are not view equivalent because the _____________ on X is not performed by the same transaction in both the schedules.
Consider the following schedule.
Which one is not true
Consider the following B+ tree with index of order is 1, Find the minimum number of nodes inclusive of root node that must be fetched in order to satisfy the given query:
“Retrieve all records with the search key value is greater than or equal to 7 and less than 15” is ____.
Identify the correct option for the following precedence graph corresponding to a schedule