1) In reviewing current help wanted advertising in the papers, online, word of m
ID: 3559159 • Letter: 1
Question
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.
Explanation / Answer
1.) One of the Key RDBMS in the present scenario is ORACLE databses. One should be familiar with SQL (Structured Query Language ) to be able to write database scripts.Database administrators must have strong organization skills to manage large databases. Well-organized data makes access easier for users and improves database performance. DBAs must understand how computers store and retrieve data, and how to build computer databases. They must also understand the technical aspects of database organization, and how database organization affects computer and network performance
2)PL/SQL stands for Procedural Language SQL.
SQL provides you to write query b ut we need something which can help us in writing database programs, the same way we write in C, C++ or JAVA. Hence we need language constructs like IF ELSE, FOR LOOP , and all and thats the reason we use PL/SQL . It provides us all the necessary constructs to write program that can accept input at runtime, and do all the works a dyanamic entity need.
3) A stored procedure is a subroutine available to applications that access a relational database system.tored procedures are similar to user-defined functions (UDFs). The major difference is that UDFs can be used like any other expression within SQL statements, whereas stored procedures must be invoked using the CALL statement.Stored procedures may return result sets, i.e. the results of a SELECT statement. Such result sets can be processed using cursors, by other stored procedures, by associating a result set locator, or by applications.SO in general term its the same as we have functions in other computer languages.
Triggers are stored programs, which are automatically executed or fired when some events occur.
Triggers can be written for the following purposes:
e.g
Generating some derived column values automatically
Enforcing referential integrity
Event logging and storing information on table access
Auditing
Synchronous replication of tables
Imposing security authorizations
Preventing invalid transactions
4) Database is a huge and never ending sector. Recently all the companies in this field are trying to push to very high level of security and high level of optimisation. Promienent and promising trends are creating pluggable databases, databases with very less response time.Oracle recently launched its databsed with pluggable feature based on a central hub database.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.