ORACLE PL/SQL Interview Questions You'll Most Likely Be Asked

Price: $19.95


 Sold Out 

ORACLE PL/SQL Interview Questions You'll Most Likely Be Asked is arguably the future for enterprise information systems. Corporations, both large and small, are looking for resources who know their job in depth. ORACLE PL/SQL Interview Questions You'll Most Likely Be Asked is a perfect companion to stand a head above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build a career as a ORACLE PL/SQL Professional. If you think this book just covers important topics in brief, then you are mistaken! It covers questions those are based on project knowledge and experience gained on successful high-profile ORACLE implementers. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer.

Table of contents
1. General-Theory
2. DDL-DML
3. Exception Handling
4. Datatypes
5. Execution Control Statements
6. Cursors
7. Procedures and Functions
8. Sequence-Index
9. Joins
10. Packages and Triggers
11. Operators
12. Miscellaneous
HR Questions
Index

Includes:
(a) 261 ORACLE PL/SQL Interview Questions, Answers and Proven Strategies for getting hired as an ORACLE PL/SQL Professional
(b) Dozens of examples to respond to interview questions
(c) 77 HR Questions with Answers and Proven strategies to give specific, impressive, answers that help nail the interviews
(d) 2 Aptitude Tests included on the CD-ROM

Bisac
COM021030 COMPUTERS / Databases / Data Mining
COM021040 COMPUTERS / Databases / Data Warehousing

Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)

73: What is Delete statement in SQL?
Answer:

Delete statement in SQL is used to delete partial/all data.
Especially delete statement is useful in case of partial delete depending upon our criteria otherwise use TRUNCATE to delete whole data from table.
When delete command fires:
a) Triggers will fire (If created on that table)
b) These will not auto commit changes made so there is one chance to rollback.

74: Why should we use Truncate over Delete while deleting all rows?
Answer:

Truncate Table statement is used to delete all rows of a table. Delete from statement is also used to delete rows and it will delete all rows when used without a where clause. But they both work in different ways. Truncate cannot be rolled back while Delete from can be rolled back. Truncate does not fire any triggers while Delete from will fire the Delete trigger if defined. Truncate is much faster than Delete. Since Truncate cannot be rolled back, it does not use space to store the temporary changes made to table. So the Truncate uses lesser memory space.

132: What are the various types of RollBack Segments?
Answer:

Rollback segments are created to control and manage the transactions that are rolled back. Rollback Segments can be Private or Public. Private Rollback segments are used with single instance database and Public Rollback segments are used with shared or parallel Oracle servers. SYS is the owner of all Rollback Segments and hence only the DBA can create them. The rollback segments can have many statuses such as invalid, needs recovery, partly available, offline, or online. The rollback segment has to be brought Online for it to perform. Multiple rollback segments can be created for better management.

157: What is the difference between NO_DATA_FOUND and %NOTFOUND?
Answer:

NO_DATA_FOUND is an exception raised when the Select into statement does not fetch any record. It works only for Select statements. %NOTFOUND is a Boolean cursor attribute that is true if no records correspond to the SQL statement that defines the cursor. %NOTFOUND can be used with Update, Delete and Insert operations to check if any records were affected by the DML statement.

116: What are the Large object types supported by Oracle?
Answer:

Large Objects or LOBs supported by Oracle can belong to Internal LOBs or External LOBs such as UML Diagrams. Internal LOBs can be BLOB or Binary Large Object, CLOB or Character Large Object, NCLOB or National Character Set Large Object and BFiles which are external files that store information. BLOBs are typically used to store images, movies etc. CLOBs are used to store very large string objects. NCLOBs are used to store large strings or documents in National Character Set format. UML Diagrams or Unified Modelling Language Diagrams are used to store pictorial representations of programs. These are like flow diagrams.

Tags
Oracle Pl sql, oracle database interview, pl sql interview, oracle plsql questions, oracle interview question, plsql interview questions, oracle dba interview, vibrant publishers, job interview questions, IT job interview