Oracle VS. SQL Server for DBAs

From: <jkyf_at_us.sina.com>
Date: Wed, 25 Oct 2000 04:00:55 GMT
Message-ID: <8t5ltk$ehv$1@nnrp1.deja.com>

hi folks~

I am preparing Oracle DBA certification, and interested in getting a DBA job after graduate.
Following are survey questions for my thesis about DBAs' tools. And some comparison between Oracle and SQL Server. Thanks a lot

if you are interested in it, you can contact with me via email : jkyf_at_us.sina.com

best regards,
JK

---

Name:

Title:

Company:

Age:

(DBA Survey

Oracle and SQL Server Satisfaction Survey)

I. As a DBA, please weight how many percentage of work time you spend in each job. (Total should be 100%)

1. Database Administration (Managing, creating and updating users, databases, and data consistency ¡Ketc)

( )%
b. Backup and Recovery
( )%

c. Performance and Tuning
( )%
d. Network Administration (Connection between servers, clients, and clients and servers. Security and so on.) ( )%
e. Project (create and test new databases) ( )%
f. Analysis
( )%
g. Others (Please list them)
( )%
Total 100%

II. As a DBA expert, when you choose a Relational Database Management System (RDMS), what functions do you think are important? Please rank following 17 functions from 1 to 10. (1 is less and 10 is most important)

III. Based on your personal experience and understanding of SQL Server and Oracle, please rank the scale of satisfaction of these two DBMS on each of 17 function? Rank from 1 to 10 (1 is most dissatisfy and 10 is most satisfy)

Please fill all number and a. and b., if never use, then skip.

Rank:
II. III. Installation and Upgrade

1. Easy to install ( )
2. SQL Server
   ( )
   
3. Oracle
   ( )
   
4. Upgrade compatibility (The compatibility of immigrating data from different RDMS or version. Ex: moving data from Acess to SQL Server or Oracle) ( )
5. SQL Server
   ( )
   
6. Oracle
   ( )
   
7. Hardware and software requirement (ex: RAM, processor speed and Operation System.) ( )
8. SQL Server
   ( )
   
9. Oracle
   ( )
   
10. Cost ( )
11. SQL Server
    ( )
    
12. Oracle
    ( )
    

Database Administratoion

5. Managing database (Create, start and shutdown database. Create, drop and manage all the database objects, instances.) ( )

1. SQL Server
   ( )
   
2. Oracle
   ( )
   
3. Managing data (Export, import, insert delete and update data) ( )
4. SQL Server
   ( )
   
5. Oracle
   ( )
   
6. Managing Users (Creating users, setting password and authentication.) ( )
7. SQL Server
   ( )
   
8. Oracle
   ( )
   
9. National Language Support ( )
10. SQL Server
    ( )
    
11. Oracle
    ( )
    

Backup and Recovery

9. Backup and Recovey databases
( )

1. SQL Server
   ( )
   
2. Oracle
   ( )
   
3. Speed of Backup and Recovery ( )
4. SQL Server
   ( )
   
5. Oracle
   ( )
   

Performance and Tuning

1. Performance and Tuning (Including monitoring performance, tuning configuration, auto configuration ¡K etc.) ( )
2. SQL Server
   ( )
   
3. Oracle
   ( )
   

Network Administration

1. Security ( )
2. SQL Server
   ( )
   
3. Oracle
   ( )
   
4. Network Administration (Manage the connection between server and clients, and the connection among servers) ( )
5. SQL Server
   ( )
   
6. Oracle
   ( )
   

Others

1. Stability (Less error) ( )
2. SQL Server
   ( )
   
3. Oracle
   ( )
   
4. Troubleshoot ( )
5. SQL Server
   ( )
   
6. Oracle
   ( )
   
7. Tutor (help) ( )
8. SQL Server
   ( )
   
9. Oracle
   ( )
   
10. DBA skill level (Ex: Some DBMS need higher skill to manage them, some don't.) ( )
11. SQL Server
    ( )
    
12. Oracle
    ( )
    
13. Scalability ( )
14. SQL Server
    ( )
    
15. Oracle
    ( )
    

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 23:00:55 CDT