Display :
Did not find what you want,
Be the first to ask question on Database
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. 

Category: Database

What is data independence? How is it used to protect the database from changes? What are the two types of data independence? Mention the differences in these two types of approaches. Which of these types is more difficult to achieve? What is a view? How does a view help in achieving logical data independence?

Category: Database

What is data abstraction in database management? Which stage of database design is it used in? How does it help the database developer during the design of a database? Name the different levels of data abstraction? What is the function of each level? What is classification and how is it used to build an abstract hierarchy?

Category: Database

Hi there,

SCOM 2012 SP1 install error with SQL 2012 SP1 and before start the install I have checked everything to see if is compatible and if my PC system supports this. Now is there a solution to make the proper install ? Is there a problem with my PC or SQL ?

Thank you !

The installed version of SQL Server is not supported. Verify that the computer and installed version of SQL Server meet the minimum requirements for installation. Please see the Supported Configuration document for further information.

Category: Database

Hello experts,

This is the error that I have it when I want to launch the program. It worked just fine before the reinstall of my Windows and now I cannot solve this. Can anyone help me please to fix this error ? Why it doesn’t work now ?

Thank you !

Initialization error

Could not locate OCI.dll

OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g.home

OracleHomeDir: D:\app\aneesh.thilakan\product\11.2.0\client_1

OK

Category: Database

I want to learn how to use a database but I don't know what database platform is best to use as a first timer. I am looking for a platform that is easy to understand and easy to use for people without prior knowledge about using a database like me. Could you please help out?

Category: Database

Hello DBA’s

I got this weird error message when I try to run a query in the database. I do not understand where I went wrong. I tried to trace the root cause of this error but I cannot. It says the error is in the line, but not able to find it. Please guide me to resolve this error message. Is there any other method available to track the error? Thanks a lot. Your help is great.

Warning