How concurrency problems effect the database?
Is it good to store images in database?
What are different types of data models available? Explain with example?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
What is the difference between specialization and generalization?
If the master device is full, how do I make the master database bigger?
What is a super key?
how do you do sql tuning?
Explain buffer manager?
List some advantages of dbms.
hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)