Crowdly
Додати до Chrome
Database Systems(BCSE302L)
Шукаєте відповіді та рішення тестів для Database Systems(BCSE302L)? Перегляньте нашу велику колекцію перевірених відповідей для Database Systems(BCSE302L) в lms.vit.ac.in.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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