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