Way 2 Freshers

You are browsing the archives of dbms faq answers.

61. What are the different phases of transaction?
Different phases are
 Analysis phase
 Redo Phase
 Undo phase
62. What do you mean by flat file database?
It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is user-friendly and provides user-interface management.
63. What is “transparent DBMS”?
It is one, which keeps its Physical Structure hidden [...]

Try the following.
1. There are seventy clerks working in a company, of which 30 are females. Also, 30 clerks are married; 24 clerks are above 25 years of age; 19 married clerks are above 25 years, of which 7 are males; 12 males are above 25 years of age; and 15 males are married. [...]

For the following, find the next term in the series
1. 6, 24, 60,120, 210
a) 336 b) 366 c) 330 d) 660
Answer : a) 336
Explanation : The series is 1.2.3, 2.3.4, 3.4.5, 4.5.6, 5.6.7, ….. ( ‘.’ means product)
2. [...]

19. If a light flashes every 6 seconds, how many times will it flash in ¾ of an hour?
20. If point P is on line segment AB, then which of the following is always true?
(1) AP = PB (2) AP > PB (3) PB > AP (4) AB > AP (5) [...]

26. In RDBMS, what is the efficient data structure used in the internal storage representation?
B+ tree. Because in B+ tree, all the data is stored only in leaf nodes, that makes searching easier. This corresponds to the records that shall be stored in leaf nodes.
27. Draw the B-tree of order 3 created by [...]