Whats is an OLTP Database
what are the acid properties in dbms?
what are the different integrity rules present in the dbms?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What are some of the important security features of a dbms?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Mention the differences between unique key and primary key
What are views in dbms?
When is functional dependency said to be the fully functional dependency?
Could you give me an example how, where I code checkpoint and restart. I need and example
Explain environment of openedge?
What is openedge abl in terms of taking the perspective of the developer?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
Can two oracle blocks have the same address?
What is primary key in dbms?
