We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ 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

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 4276

.

+ 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)

Replies to This Discussion

wese to tamam store kar akte hain 5000 data 

Good.Ab question ya hai ke kon si language relationally more than 5000 records can store.  

jahan tk related transactions ka swal hai to wo bi sb mai ho sakte hai

lakin better in Orcale and MS sql.mysql mai itne achae nae hoti

 

yes ofcourse, oracle is best one, from all the relationl databases

The discussion is that "which language is best for RDBMS " .   5  main points are required hai aur 3 to us mai he diye huye hai . Ab ya he deakhana hai ke kon si language is best for these 3 points , baki 2 us ke advantages se he mil jaye ge.

ab raha swal ke data secure kis mai hta hai ziyada

or not more than 5.....matlb 5 se ziyada nae ho sakte

ap 3 bi bta sakte ho btana hai kun ziyada behtr hai

is mai mysql nae ata lakin ab malom yai karna hai

MS sql server better hai ya Orcale

Study karte hai 2 ko phir deakhate hai kiya result aata hai. Umeed hai ache points mil jaye ge.

Oracle is an object-relational database management system ...

Large scale projects developed in Oracle

while Mysql Mostyly used in web applications

 

Most web says SQL Server is best and few says Oracle

SQL Server Most Secure Database;

Oracle Least Secure Database Since 2002

Microsoft SQL Server has a
stronger security posture than the Oracle RDBMS.

DISADVANTAGE PRESENT IN MYSQL:

MYSQL standard has diverted on the standards of implementation of Null and default values. Arithmetic operations are susceptible to integer over flow. Mode of operation of SQL is set to unusual tolerant state which developers hate.

  • MySQL does not support a very large database size as efficiently
  • MySQL does not support ROLE, COMMIT, and Stored procedures in versions less than 5.0
  • Transactions are not handled very efficiently.

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.