Way 2 Freshers

You are browsing the archives of fresher dbms questions and 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 [...]

41. When is a functional dependency F said to be minimal?
 Every dependency in F has a single attribute for its right hand side.
 We cannot replace any dependency X A in F with a dependency Y A where Y is a proper subset of X and still have a set of [...]

1. What is database?
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.
2. What is DBMS?
It is a collection of programs that enables user to create and maintain a database. In other words [...]