Display :
Did not find what you want,
Be the first to ask question on Database
Category: Database

What do you mean by the term data mining? What are its disadvantages? What is it useful for? What are the various reasons it is being used for? Has it proven to be useful?

Category: Database

What does the term Big Data mean? What are the methods for data analyzing of Big Data (BD)? How is it different from the normal data?

Category: Database

What I the structure of a Data Base Management System? What are its advantages? Why is it also called as the three-tier structure?

Category: Database

Hello! What is the most easiest database management system(DBMS). I have heard some names of the famous DBMS like Oracle, MySQL, Post Gre SQL etc. So for a complete beginner which DBMS is the easiest to learn and to use effectively? Which among the following is the best DMBS in terms of its usage.

Category: Database

Hello! As we all know that data can be stored in files as well. And we can also perform different functions on the stored data in files as well like retrieve data or insert new data in files as well. But why do we need the database management systems if files can be used to store data. Does it mean that the file management system is not efficient or not complete?

Category: Database

Hello everyone! I am a student of Software Engineering and my 4th semester is about to start in a week. I have this database management system course in the next semester and this course is completely new for me. So in one week time, I want to learn as much as I can, starting from the beginning, what this course is about etc. How should I start it? Any video links, online links, books for complete beginners?

Category: Database

What is meant by scalability of a database? What is the difference between a read heavy system and a write heavy system? What is vertical scaling? How is it different from horizontal scaling .If you have a ready heavy system, which one is the preferred mode of scaling: vertical or horizontal?

Category: Database

 

What is a stateless system? What is as stateful system? What is the impact of state on scaling? What is parallelism? What is the impact of state on parallelism? Name some stateless protocols .The Server Message Block is a stateful protocol. Can you explain how? In terms of security which one is a better protocol: stateful or stateless?

Category: Database

What is a primary key? What is a secondary key? What is a foreign key? What is the difference between each of them? Where are they used? What is a join? What are the different kinds of joins? Explain how they work? Can you differentiate between GROUP BY and ORDER BY?

Category: Database

Is it possible for a database admin to steal your customer’s passwords? How can you prevent this from happening? What are the things that you can do to speed up the processing of your database and remove performance issues? Explain the different ways in which performance tuning can be achieved with respect to a database.