Please Help 1 In reviewing current help wanted advertising i

Please Help!!!!

1) In reviewing current help wanted advertising in the papers, online, word of mouth, and other sources, what do you feel are the most desirable RDBMSs to have experience with for a career as a DBA or database developer and what skill sets are required? Why?

2) What is PL/SQL and how can that be used in DBA and database development work?

3) What are stored procedures and triggers and how are they used in database applications?

4) What trends in Database technology seem to be most prominent? Be sure to explain the trend and reference your sources.

Solution

Find the solution below:

==========================================================================

In my openinon Oracle DataBase is the best RDBMS and it holds 50% share of entire RDBMS Market.

main features includes
1: GUI
2: PlSql programming
3: Platform independent
4: New database handling for archiving Flash Data Archive (FDA)
5: A Rapid-Development tool that allows users to develop Web apps using SQL and/or PL/SQL

Skillset Required for a DBA:

==> As a DBA you will need to interact with the operating system when it comes to installing and
configuring database environments.

==> Good knowledge about sql, database architecture

==> Understanding of recovery,routine maintenance,loadbalancing and handling failover of a database

Why to aquire the above mentioned skillset?

==> In case of any database failures and any other circumstances a DBA should be able to handle the issues

==> To make any changes(schemas,table structures) in the existing databases a DBA should know the database architecture.

=============================================================================

PL/SQL = Procedural language,Structured query language

SQL is a common language in RDBMS but PL/SQL is only for Oracle database

in sql we will execute a single query at a time, but in PL/SQL we can execute multiple queries at a time

in PL/SQL we can write a business logics along with sql queries.

we can use control statements in PL/SQL(If\\,else,while,etc...)

we can define our own functions

==========================================================================

A trigger is an action which performs automatically when ever an user performed any event.

a programmer will define an action of a trigger.

Ex: to maintain logs regarding any events we use triggers.

Ex Trigger Program:

create or replace trigger triggername

after update or insert or delete on tablename

for each row

begin

DBMS_OUTPUT.PUT_LINE(\"transaction performed\");

end triggername

=================

A Stored Procedures will store in DB in compiled format.

The PL/SQL programs will be considered as procedures but they cannot store in DB.

A function should return a value but procedure cannot return a value.

We can use the functions in procedures but we cannot use the Procedures in functions.

Ex:

create or replace

procedure procedurename

is

begin

DBMS_OUTPUT.PUT_LINE(\"Stored Procedures\");

end procedurename

=========================================================================