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

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: 4263

.

+ 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

Latest Activity

+ !ѕιмρℓє ¢н replied to + ! ❤INNOCENT❤'s discussion Akhri Salam Smjh kr
7 minutes ago
+ ! ! ! ! ! " Muskan liked + M.Tariq Malik's discussion Fall 2019 2nd Merit List of Candidates Eligible for Admission
14 minutes ago
+ ! ! ! ! ! " Muskan liked + M.Tariq Malik's discussion VIRTUAL UNIVERSITY OF PAKISTAN ORGANIZED AAOU 2019
15 minutes ago
+ ! ! ! ! ! " Muskan liked + M.Tariq Malik's discussion Fall 2019- 2nd Merit List of Candidates Eligible for Admission
15 minutes ago
+ ! ! ! ! ! " Muskan liked + Iuuoɔǝut+'s discussion عشق
15 minutes ago
+ ! ! ! ! ! " Muskan liked + M.Tariq Malik's discussion غیر پھر غیر، درگزر کر دے - کون روکے زبان اپنوں کی
15 minutes ago
+ ! ! ! ! ! " Muskan liked + ! ! RebeL's discussion Read this out Loud !!!!!!!!!
15 minutes ago
+ ! ! ! ! ! " Muskan liked + "Jɨyą's discussion okey :x
15 minutes ago
+ ! ! ! ! ! " Muskan liked + "Jɨyą's discussion okey :x
15 minutes ago
+ ! ! ! ! ! " Muskan liked ♦_"Tooba"_♦'s discussion Guzri Howi Zindagi Ko Kabhi Yaad Na Kr
15 minutes ago
+ ! ! ! ! ! " Muskan liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion 2019 Noble Prize Winners
15 minutes ago
+ ! ! ! ! ! " Muskan liked +"Certified Gangster"++'s discussion For all female friends
15 minutes ago
+ ! ! ! ! ! " Muskan liked ASIM MAQSOOD's discussion BANKING AND FINANCE
15 minutes ago
+ ! ! ! ! ! " Muskan liked + ! ! ! ! ! !Aaima Ansari ❤️'s discussion ++!!!!!!!EARTH QUACKS!!!!!!!!!!++
15 minutes ago
+ ! ! ! ! ! " Muskan liked 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
15 minutes ago
+ ! ! ! ! ! " Muskan liked + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
15 minutes ago
+ ! ! ! ! ! " Muskan liked + Iuuoɔǝut+'s discussion hijar ka tara doob chala hy ......wasi shah
15 minutes ago
+ ! ! ! ! ! " Muskan liked +¢αяєℓєѕѕ gιяℓ's discussion Lets Share yOur desktOp wAllpAper.....  (•ิ‿•ิ)
15 minutes ago
+ ! ! ! ! ! " Muskan liked +¢αяєℓєѕѕ gιяℓ's discussion Jin sey Mohabbat Ho.....
16 minutes ago
+ ! ! ! ! ! " Muskan liked + ! ❤INNOCENT❤'s discussion Akhri Salam Smjh kr
16 minutes ago

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

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