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

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 4258

.

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

Replies to This Discussion

  • Microsoft Office System Integration
  • SQL Server helps customers gain better business insight and make faster decisions through the product's tight integration with the familiar MicrosoftOffice System user interface. For example, add-ins such asData Mining for  Excel uses both SQL Server and Microsoft Office to provide insight intocustomer data. IDC recognizes Microsoft as thefastest growing BI tool   vendor  . Oracle has Microsoft Office Plug In, which includes subset of thefunctionalities that SQL Server provides, but charges an additional$30,000 per processor  . 

The following section will describe the steps

required to instruct HP Web Jetadmin to use a

SQL Server database that resides on a different

machine than the HP Web Jetadmin installation.

Remember that an optional license must be

installed in HP Web Jetadmin before allowing the

usage of a SQL Server database on a separate

server. See “Appendix A” for instructions on

installing the optional license. HP Web Jetadmin

10.2 SR1 and beyond is also required in order

based applications and decision support applications. We also asked about the percentage of databases

which supported mission critical applications.

Somewhat surprisingly, when size and user support revealed significant differences, the responses did not

reveal any significant differences in usage between the two database management systems. For Microsoft

SQL Server, 55.7% of databases supported transaction based applications, while 44.3% of databases were

for decision support applications. For Oracle Database, the split was 60.3% of databases supported

transaction based applications, and 39.7% of the databases were used for decision support.

The most interesting result was that Microsoft SQL Server was being used for a higher percentage of

mission critical business applications. Respondents stated that 66.1% of Microsoft SQL Server databases

supported mission critical applications, while only 63.8% of Oracle Databases were classified as mission

critical. While the difference in these percentages is rather small, we expected the opposite results.

Clearly, participants viewed the functions supported by their Microsoft SQL Server databases just as crucial

but Nabila sis transaction wala point b to important ha jesa k GDB m likha ha ,manage data of 5000 employees and its related transactions. wt u say ?

m still confuz between sql and oracle 

Hello, guys... there is no difference between records and transactions. Transactions also means records. All databases store data in form of records. Let me give you an example let's say an employee's record is a single record having fields like Name, Date of Joining, Qualifications etc. But when he gets salaray every month a record is entered to a table let's say having fields Date, Salary Month, Salary Amount etc. These records are transactions because they keep increasing of rone employee every months. I hope I made it clear. All databases are capable of having transactions.

thanx   Shakeel Khan and  Nabila ch.... and u r rit nabila sis SQL is better ...

MS SQL Server 2005

NASDAQ is the largest U.S. electronic stock market. With approximately 3,300 companies, it lists more companies and, on average, trades more shares per day than any other U.S. market. NASDAQ prides itself in being the home to category-defining companies that are leaders across all areas of business including technology, retail, communications, financial services, transportation, media, and biotechnology.

Automatic Backup

Transaction Logs

Security

Scalability

 Microsoft SQL Server is best ans

gud keep it up

RSS

Latest Activity

Ali Shah updated their profile
42 minutes ago
+++Mahoo+++ replied to +++Amara+++++'s discussion DAROOD ki FAZiLAt
48 minutes ago
+++Mahoo+++ liked +++Amara+++++'s discussion DAROOD ki FAZiLAt
49 minutes ago
+++Amara+++++ posted discussions
57 minutes ago
+++Mahoo+++ updated their profile
1 hour ago
☑ Steve liked Sharal Khan's blog post janta ho.........
1 hour ago
☑ Steve liked Sharal Khan's blog post ALLAH.........
1 hour ago
☑ Steve commented on Sharal Khan's blog post ALLAH.........
1 hour ago

Today Top Members 

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

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