Recent questions tagged databases

4 votes
1 answer
2371
4 votes
3 answers
2373
1 votes
1 answer
2381
Spot the wrong statement.Subschema is related with external view only.Data dictionary is a tool used exclusively by the database administrator.To define a schema DDL, DML...
0 votes
2 answers
2382
3 votes
2 answers
2383
4 votes
2 answers
2388
The maximum number of keys stored in a B-tree of order $m$ and depth $d$ is$m^{d +1}-1$$\frac{m^{d+1}-1}{m-1}$$(m-1)(m^{d+1}-1)$$\frac{m^d-1}{m-1}$
1 votes
0 answers
2393
2 votes
3 answers
2394
The problem that occurs when one transaction updates a database item and the transaction fails for some reason isTemporary Select ProblemTemporary Modify ProblemDirty Rea...
2 votes
2 answers
2396
4 votes
2 answers
2398
Goals for the design of the logical scheme includeavoiding data inconsistencybeing able to construct query easilybeing able to access data efficientlyAll of the above
0 votes
1 answer
2399
A Transaction Manager is which of the following?Maintains a log of transactionsMaintains before and after database imagesMaintains appropriate concurrent controlAll of th...
1 votes
1 answer
2400