What are the restrictions applicable while creating views?
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
What's difference between dbms and rdbms ?
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
How can you perform pattern matching in sql?
What are collection pools? What are the advantages?
Define entity, entity type, and entity set.
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What is a degree of relation?
In which format image is stored in database?
When would you use a database?
Mention the differences between the clustered and non-clustered index
Explain the main control blocks available in ims db?
What is write ahead logging in DBMS?
Mention how deadlock can be resolved?