What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
2 7649what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
2095Post New Database Management Questions
Discuss transparent DBMS?
Mention the differences between the clustered and non-clustered index
What do you understand by data independence? What are its two types?
Mention the differences between unique key and primary key
How to know the Architecture of the Database
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 database modules?
What is inner join in database?
What entity means?
What is 2-tier architecture?
Is file system a database?
What are the five steps of data modeling?
What is foreign key in dbms?
Why do we use databases?
Compare non-clustered and clustered index