We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ Link For Past Papers, Solved MCQs, Short Notes & More
Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion
How to Add New Discussion in Study Group ? Step By Step Guide Click Here.
Let suppose you are hired as a Database Administrator (DBA) for a renowned IT service provider company with a task that you are required to choose any one from the given options Microsoft SQL Server, Oracle and MySQL in order to manage data about 5000 employees and its related transactions.
Its also one of the main requirement of the company to secure data as much as possible.
Highlight with very solid points (not more than 5) which RDBMS is more appropriate from your point of view.
Note: you can take help from internet but the posted data should be in your own words
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
gud work nabila
SQL Server and Oracle is different. SQL Server will allow reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.
SQL server is a best ...................
agr SQL server sy best koi or language hoti to hamain wo learn krwi jati na k sql
Oracle is the world's most popular database primarily because it runs on every platform known, from a mainframe to a Mac. MS-SQL on the other hand, is a Windows-only offering. Both SQL Server and Oracle are relational databases, but it is their genealogy that tells about their core differences:
Oracle is the best option for storing large amount of data and from security point of view.
i am comming again with a different logic. Banday ko jo kam ata ho wo he banda behtar kar saqta hay kun k mujay sirg MS Sql Server main kam karna ata hay bhai main to us ko he prefer kron ga.
plz dont copy paste it is my decision. write about yours
I shall prefer SQL Server because I know more about it then other RDBMS.
dear question ko understand kren us lihaz se oracle is best .
Tell me the final answer? which one is best?
han ji wohi hai suitable kiun k sir nay kaha hai k main requirement of the company to secure data as much as possible...
aur Microsoft SQL Server is best for security purpose...
Oracle is still living in the old days where everything is a good ole boys club. This is the world of Linux and Unix where they started, and it's a dinosaur, man. You just can't afford to do business like that anymore. You have to open up your community and start programs to encourage your best people to help and teach.
If you take any 10 DBAs from each side and ask them to look up a solution to a problem on their platform, the SQL guys will find the answer much faster than the Oracle guys will. And that's just a fact. If you're looking on specifics on how Oracle works internally, it's almost impossible to ferret out the info, but with SQL, there are so many open resources it's just a matter of a few minutes to an answer.So the real difference between these two platforms is community. Microsoft has gone to great lengths to build a community and really support it. And Oracle is still doing business the old way.
i will go for SQL :)
< Please do not copy its my first attempt to discuss it with u all... >>>>>>>>
In my opinion Microsoft SQL Server seems suited best due to the following advantages over Oracle and MySQL
Special thanks to miss nabila's research... i vote for MS SQL server.
Oracle transaction ko support karti hai( means ke us mai data transaction ki soorat mai enter hota hai). SQL mai aasa nhai hota is liye oracle he final an ho ga to the given situation.