We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read 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
.+ 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)
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.
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.
Microsoft SQL Server is best ans