www tech interviews com

8/8/2019 Www Tech Interviews Com

1/21

Database >> PL/SQL interview qiuestions

Search Tech Interv iews

SearchTechInterviewsPrepare for job interviews with the questions and answers asked by high-tech employers

.NET C++ Database General Hardware Jav a Networking Puzzles SAP ABAP Testing Unix/Linux VB Web dev Windows

PL/SQL interview qiuestionsBy admin | May 8, 2004

1. Which of the following statements is true about implicit cursors?A. Implicit cursors are used for SQL statements that are not named.

B. Developers should use implicit cursors with great care.C. Implicit cursors are used in cursor for loops to handle data processing.D. Implicit cursors are no longer a feature in Oracle.

2. Which of the following is not a feature of a cursor FOR loop? A. Record ty pe declaration.

B. Opening and parsing of SQL statements.C. Fetches records from cursor.D. Requires exit condition to be defined.

3. A developer would like to use referential datatype declaration on a variable.The variable name is EMPLOYEE_LASTNAME, and the corresponding table

and column is EMPLOYEE, and LNAME, respectively. How would the

developer define this variable using referential datatypes?

A. Use employee.lname%type.

B. Use employee. lname%rowtype.C. Look up datat ype for EMPLOYEE column on LASTNAME table and use that.D. Declare it to be type LONG.

4. Which three of the following are implicit cursor attributes? A. %found

B. %too_many_rowsC. %notfoundD. %rowcountE. %rowtype

5. If left out, which of the following would cause an infinite loop to occur in asimple loop?

A. LOOP

B. END LOOPC. IF-THEND. EXIT

6. Which line in the following statement will produce an error?A. cursor action_cursor is

B. select name, rate, actionC. into action_recordD. from action_table;E. There are no errors in this statement.

7. The command used to open a CURSOR FOR loop is A. open

B. fetchC. parse

D. None, cursor for loops handle cursor opening implicitly .8. What happens when rows are found using a FETCH statement

A. It causes the cursor to close

B. It causes the cur sor to openC. It loads the current row values into variablesD. It creates the variables to hold the current row values

Ads by Google

Oracle 9i Database Tuning

Tune Oracle 9i Database Performance ImmediateROI, Free Trial Download!

www.Confio.com/Oracle9i

Oracle Database UpgradeCintra - Premier Oracle Partner Offers FreeUpgrade Assessment

www.cintra.com

Interview Answer Guide

Increase y our chance of being hired With easy tofollow answer guide.

www.JobInterviewTools.com

Job Interview Question ArticlesC# Interview Questions and AnswersQTP Interview Questions and Answers

C++ Interview Questions and AnswersPHP Interview Questions and AnswersXML Interview Questions and AnswersJav aScript Interview Questions and Answers

Asp.Net Interview Questions and AnswersJ2EE Interview Questions and Answers

ABAP Interview Questions and AnswersPerl Interview Questions and AnswersJav a Interview Questions and Answers

ResourcesTechnology Question and Answer WebsiteHow to dance around the salary-expectationquestion

10 mistakes managers make during job interviewsID MakerStupid interv iew questionsHow to Answer These Tricky Interview QuestionsSeven tips for writing an online profile for LinkedIn,MySpace or Facebook

Video surveillance

converted by Web2PDFConvert.com
http://custom.marketwatch.com/custom/iwon-com/news-story.asp?guid=3A2B59B2-946E-4EAD-BE5F-E176D8E56271http://ad.doubleclick.net/click%3Bh%3Dv8/3a5c/3/0/%2a/x%3B227513437%3B0-0%3B0%3B56423405%3B3454-728/90%3B37845684/37863532/1%3B%3B~fdr%3D232573013%3B0-0%3B0%3B51507152%3B3454-728/90%3B39334039/39351826/1%3B%3B~fdr%3D232552120%3B0-0%3B0%3B56407032%3B3454-728/90%3B39311929/39329716/1%3B%3B~sscs%3D%3fhttp://www.momentoftruth.com/?cmp=OLA_lif_MOT_Regal_Lifestylehttp://www.techinterviews.com/http://www.web2pdfconvert.com/?ref=PDFhttp://www.web2pdfconvert.com/?ref=PDFhttp://www.videosurveillance.com/http://www.careerjournal.com/myc/climbing/20060829-needleman.html?mod=RSS_Career_Journal&cjrss=frontpagehttp://www.careerbuilder.com/Custom/MSN/CareerAdvice/ViewArticle.aspx?articleid=356&pf=true&cbRecursionCnt=1&cbsid=8037040af8b74b93a8e5a7080037ffac-220467129-RR-4http://www.businessweek.com/careers/content/sep2005/ca20050921_1099_ca009.htm?campaign_id=topStories_ssi_5http://www.alphacard.com/http://articles.techrepublic.com.com/5100-10881_11-6179941.htmlhttp://custom.marketwatch.com/custom/iwon-com/news-story.asp?guid=3A2B59B2-946E-4EAD-BE5F-E176D8E56271http://qa.techinterviews.com/http://www.techinterviews.com/java-interview-questions-and-answershttp://www.techinterviews.com/perl-interview-questions-and-answershttp://www.techinterviews.com/abap-interview-questions-and-answershttp://www.techinterviews.com/j2ee-interview-questions-and-answershttp://www.techinterviews.com/aspnet-interview-questions-and-answershttp://www.techinterviews.com/javascript-interview-questions-and-answershttp://www.techinterviews.com/xml-interview-questions-and-answershttp://www.techinterviews.com/php-interview-questions-and-answershttp://www.techinterviews.com/c-plus-plus-interview-questions-and-answershttp://www.techinterviews.com/qtp-interview-questions-and-answershttp://www.techinterviews.com/c-sharp-interview-questions-and-answershttp://googleads.g.doubleclick.net/aclk?sa=l&ai=Bs9j3B_TsTNGbKJnklQfu3pyYCqGpiuQBvc21jATAjbcBoP4KEAMYBSDymfQBKAM4AFDig7HI______8BYMmuiozQpIgSoAG3kfT9A7IBFnd3dy50ZWNoaW50ZXJ2aWV3cy5jb23IAQHaAThodHRwOi8vd3d3LnRlY2hpbnRlcnZpZXdzLmNvbS9wbHNxbC1pbnRlcnZpZXctcWl1ZXN0aW9uc4ACAdACAagDAegDH-gD1wLoAz31AwAAAMQ&num=5&sig=AGiWqtxKFXCDSsUKNU0PPTyEkZe-zu3RfA&client=ca-pub-1894578950532504&adurl=http://www.jobinterviewtools.comhttp://googleads.g.doubleclick.net/aclk?sa=l&ai=Bs9j3B_TsTNGbKJnklQfu3pyYCqGpiuQBvc21jATAjbcBoP4KEAMYBSDymfQBKAM4AFDig7HI______8BYMmuiozQpIgSoAG3kfT9A7IBFnd3dy50ZWNoaW50ZXJ2aWV3cy5jb23IAQHaAThodHRwOi8vd3d3LnRlY2hpbnRlcnZpZXdzLmNvbS9wbHNxbC1pbnRlcnZpZXctcWl1ZXN0aW9uc4ACAdACAagDAegDH-gD1wLoAz31AwAAAMQ&num=5&sig=AGiWqtxKFXCDSsUKNU0PPTyEkZe-zu3RfA&client=ca-pub-1894578950532504&adurl=http://www.jobinterviewtools.comhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BmRrrB_TsTNGbKJnklQfu3pyYCor0ysYBgs7RgBTAjbcB8OCWARACGAQg8pn0ASgDOABQyvWX9ANgya6KjNCkiBKyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOoAwHoAx_oA9cC6AM99QMAAADE&num=4&sig=AGiWqtxyeRvvkYOi5WzvYIT8dI1JViY80g&client=ca-pub-1894578950532504&adurl=http://www.cintra.comhttp://googleads.g.doubleclick.net/aclk?sa=L&ai=BmRrrB_TsTNGbKJnklQfu3pyYCor0ysYBgs7RgBTAjbcB8OCWARACGAQg8pn0ASgDOABQyvWX9ANgya6KjNCkiBKyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOoAwHoAx_oA9cC6AM99QMAAADE&num=4&sig=AGiWqtxyeRvvkYOi5WzvYIT8dI1JViY80g&client=ca-pub-1894578950532504&adurl=http://www.cintra.comhttp://googleads.g.doubleclick.net/aclk?sa=l&ai=BREjTB_TsTNGbKJnklQfu3pyYCqrVu5QBpIvGvxPAjbcB4JKWARABGAMg8pn0ASgDOABQ-8bOI2DJroqM0KSIEqABwO-7_wOyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOAAgGoAwHoAx_oA9cC6AM99QMAAADE&num=3&sig=AGiWqtwepJrOe2WL6_xEftAZqmu7-nX6qQ&client=ca-pub-1894578950532504&adurl=http://www.confio.com/ppc/FreeTrial-Oracle9i.php%3Fsource%3DGoogOraChttp://googleads.g.doubleclick.net/aclk?sa=l&ai=BREjTB_TsTNGbKJnklQfu3pyYCqrVu5QBpIvGvxPAjbcB4JKWARABGAMg8pn0ASgDOABQ-8bOI2DJroqM0KSIEqABwO-7_wOyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOAAgGoAwHoAx_oA9cC6AM99QMAAADE&num=3&sig=AGiWqtwepJrOe2WL6_xEftAZqmu7-nX6qQ&client=ca-pub-1894578950532504&adurl=http://www.confio.com/ppc/FreeTrial-Oracle9i.php%3Fsource%3DGoogOraChttp://www.google.com/url?ct=abg&q=https://www.google.com/adsense/support/bin/request.py%3Fcontact%3Dabg_afc%26url%3Dhttp://www.techinterviews.com/plsql-interview-qiuestions%26hl%3Den%26client%3Dca-pub-1894578950532504%26adU%3Dwww.Confio.com/Oracle9i%26adT%3DOracle%2B9i%2BDatabase%2BTuning%26adU%3Dwww.cintra.com%26adT%3DOracle%2BDatabase%2BUpgrade%26adU%3Dwww.JobInterviewTools.com%26adT%3DInterview%2BAnswer%2BGuide%26gl%3DUS&usg=AFQjCNESFGX7wfOailnxrYaGc3A8N7E1Eghttp://ad.doubleclick.net/click%3Bh%3Dv8/3a5c/3/0/%2a/a%3B228846284%3B0-0%3B0%3B54793537%3B4307-300/250%3B38329932/38347689/1%3B%3B~okv%3D%3Bpc%3DDFP230471162%3B%3B~fdr%3D230471162%3B0-0%3B0%3B51507152%3B4307-300/250%3B38720481/38738238/1%3B%3B~sscs%3D%3fhttp://www201.americanexpress.com/sbsapp/FMACServlet?request_type=alternateChannels&lpid=301&openeep=17218http://www.techinterviews.com/author/admin/http://ad.doubleclick.net/click%3Bh%3Dv8/3a5c/3/0/%2a/x%3B227513437%3B0-0%3B0%3B56423405%3B3454-728/90%3B37845684/37863532/1%3B%3B~fdr%3D232573013%3B0-0%3B0%3B51507152%3B3454-728/90%3B39334039/39351826/1%3B%3B~fdr%3D232552120%3B0-0%3B0%3B56407032%3B3454-728/90%3B39311929/39329716/1%3B%3B~sscs%3D%3fhttp://www.momentoftruth.com/?cmp=OLA_lif_MOT_Regal_Lifestylehttp://www.techinterviews.com/interview-questions/databasehttp://www.techinterviews.com/interview-questions/windowshttp://www.techinterviews.com/interview-questions/web-devhttp://www.techinterviews.com/interview-questions/vbhttp://www.techinterviews.com/interview-questions/unixlinuxhttp://www.techinterviews.com/interview-questions/testinghttp://www.techinterviews.com/interview-questions/sap-abaphttp://www.techinterviews.com/interview-questions/puzzleshttp://www.techinterviews.com/interview-questions/networkinghttp://www.techinterviews.com/interview-questions/javahttp://www.techinterviews.com/interview-questions/hardwarehttp://www.techinterviews.com/interview-questions/generalhttp://www.techinterviews.com/interview-questions/databasehttp://www.techinterviews.com/interview-questions/chttp://www.techinterviews.com/interview-questions/nethttp://www.techinterviews.com/


2/21

9. Read the following code:CREATE OR REPLACE PROCEDURE f ind_cpt

(v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)

IS

BEGIN

IF v_cost_per_ticket > 8.5 THEN

SELECT cost_per_ticket

INTO v_cost_per_ticket

FROM gross_receipt

WHERE movie_id = v_movie_id;

END IF;

END;

Which mode should be used for V_COST_PER_TICKET?

A. INB. OUTC. RETURND. IN OUT

10. Read the following code:CREATE OR REPLACE TRIGGER update_show_gross

{trigger information}

BEGIN

{additional code}

END;

The trigger code should only execute when the column, COST_PER_TICKET, is greaterthan $3.Which trigger information will you add?

A. WHEN (new.cost_per_ticket > 3.7 5)

B. WHEN (:new.cost_per_ticket > 3.7 5C. WHERE (new.cost_per_ticket > 3.75)D. WHERE (:new.cost_per_ticket > 3.75)

11. What is the maximum number of handlers processed before the PL/SQL blockis exited when an exception occurs?

A. Only one

B. All that applyC. All referencedD. None

12. For which trigger timing can you reference the NEW and OLD qualifiers?A. Statement and Row

B. Statement onlyC. Row onlyD. Oracle Forms trigger

13. Read the following code:CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER)

RETURN number IS

v_yearly_budget NUMBER;

BEGIN

SELECT yearly_budget

INTO v_yearly_budget

FROM studio

WHERE id = v_studio_id;

RETURN v_yearly_budget;

END;

Which set of statements will successfully invoke this function within

SQL*Plus?

A. VARIABLE g_y early_budget NUMBEREXECUTE g_yearly_budget := GET_BUDGET(11);

B. VARIABLE g_y early_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);

C. VARIABLE :g_y early_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);

D. VARIABLE g_y early_budget NUMBER:g_yearly _budget := GET_BUDGET(11 );

14.

Ink cartridgesLaptop computers

Affordable life insuranceInk cartridges

TutorialsAJAX TutorialsDealing with y our jobGetting a jobJavaScript tutorialsJob interview tips from Yahoo! HotJobsMySQL tutorialsRetiring from your jobRuby on Rails tutorialsSalary guide for IT jobsSelf-employmentTechInterviews guides in PDFUnderstanding pointersXML TutorialsXUL tutorials

RSS Feeds

All postsAll comments

http://www.web2pdfconvert.com/?ref=PDFhttp://www.web2pdfconvert.com/?ref=PDFhttp://www.techinterviews.com/comments/feedhttp://www.techinterviews.com/feedhttp://www.techinterviews.com/xul-tutorialshttp://www.techinterviews.com/xml-tutorialshttp://www.techinterviews.com/understanding-pointershttp://www.techinterviews.com/techinterviews-guides-in-pdfhttp://www.techinterviews.com/self-employmenthttp://www.techinterviews.com/salary-guidehttp://www.techinterviews.com/ruby-on-rails-tutorialshttp://www.techinterviews.com/retiring-from-your-jobhttp://www.techinterviews.com/mysql-tutorialshttp://www.techinterviews.com/job-interview-tips-from-yahoo-hotjobshttp://www.techinterviews.com/javascript-tutorialshttp://www.techinterviews.com/getting-a-jobhttp://www.techinterviews.com/dealing-with-your-jobhttp://www.techinterviews.com/ajax-tutorialshttp://www.prink.co.uk/http://www.onedollarglobeinsurance.com/affordablelifeinsurance.htmhttp://www.toshibadirect.com/http://www.printerink.com/


3/21

CREATE OR REPLACE PROCEDURE update_theater

(v_name IN VARCHAR v_theater_id IN NUMBER) IS

BEGIN

UPDATE theater

SET name = v_name

WHERE id = v_theater_id;

END update_theater;

When invoking this procedure, you encounter the error:

ORA-000: Unique constraint(SCOTT.THEATER_NAME_UK) v iolated.

How should you modify t he function to handle this error?

A. An user defined exception must be declared and associated with the error codeand handled in the EXCEPTION section.

B. Handle the error in EXCEPTION section by referencing the error code directly .C. Handle the error in the EXCEPTION section by r eferencing the UNIQUE_ERROR

predefined exception.D. Check for success by checking the v alue of SQL%FOUND immediately after the

UPDATE statement.15. Read the following code:

CREATE OR REPLACE PROCEDURE calculate_budget IS

v_budget studio.yearly_budget%TYPE;

BEGIN

v_budget := get_budget(11);IF v_budget < 30000

THEN

set_budget(11,30000000);

END IF;

END;

You are about to add an argument to CALCULATE_BUDGET. What effect will

this have?

A. The GET_BUDGET function will be marked invalid and must be recompiledbefore the next execution.

B. The SET_BUDGET function will be marked invalid and must be recompiledbefore the next execution.

C. Only the CALCULATE_BUDGET procedure needs to be recompiled.D. All three procedures are marked invalid and must be recompiled.

16. Which procedure can be used to create a customized error message? A. RAISE_ERROR

B. SQLERRMC. RAISE_APPLICATION_ERRORD. RAISE_SERVER_ERROR

17. The CHECK_THEATER trigger of the THEATER table has been disabled.Which command can you issue to enable this trigger?

A. ALTER TRIGGER check_theater ENABLE;

B. ENABLE TRIGGER check_theater;C. ALTER TABLE check_theater ENABLE check_theater;D. ENABLE check_theater;

18. Examine this database triggerCREATE OR REPLACE TRIGGER prevent_gross_modification

{additional trigger information}

BEGIN

IF TO_CHAR(sysdate, DY) = MON

THEN

RAISE_APPLICATION_ERROR(-20000,Gross receipts cannot be deleted on Monday);

END IF;

END;

This trigger must fire before each DELETE of the GROSS_RECEIPT table. It

should fire only once for the entire DELETE statement. What additional

information must you add?

A. BEFORE DELETE ON gross_receipt

B. AFTER DELETE ON gross_receiptC. BEFORE (gross_receipt DELETE)D. FOR EACH ROW DELETED FROM gross_receipt

19. Examine this function:CREATE OR REPLACE FUNCTION set_budget

(v_studio_id IN NUMBER, v_new_budget IN NUMBER) IS

http://www.web2pdfconvert.com/?ref=PDFhttp://www.web2pdfconvert.com/?ref=PDF


4/21

BEGIN

UPDATE studio

SET yearly_budget = v_new_budget

WHERE id = v_studio_id;

IF SQL%FOUND THEN

RETURN TRUEl;

ELSE

RETURN FALSE;

END IF;

COMMIT;END;

Which code must be added to successfully compile t his function?

A. Add RETURN right before the IS key word.

B. Add RETURN number r ight before the IS keyword.C. Add RETURN boolean right after the IS keyword.D. Add RETURN boolean right before the IS keyword.

20. Under which circumstance must y ou recompile the package body aft errecompiling the package specification?

A. Altering the argument list of one of the package constructs

B. Any change made to one of the package constructs

C. Any SQL statement change made to one of the package constructsD. Removing a local v ariable from the DECLARE section of one of the package

constructs21 . Procedure and Functions are explicitly executed. This is different from a

database trigger. When is a database trigger executed?

A. When the transaction is committed

B. During the data manipulation statementC. When an Oracle supplied package references the triggerD. During a data manipulat ion statement and when the transaction is committed

22. Which Oracle supplied package can you use to output values and messagesfrom database t riggers, stored procedures and functions within SQL*Plus?

A. DBMS_DISPLAY

B. DBMS_OUTPUT

C. DBMS_LISTD. DBMS_DESCRIBE

23. What occurs if a procedure or function terminates with failure without beinghandled?

A. Any DML statements issued by the construct are still pending and can becommitted or rolled back.

B. Any DML statements issued by the construct are committedC. Unless a GOTO statement is used to continue processing within the BEGIN

section, the construct terminates.D. The construct rolls back any DML statement s issued and returns the unhandled

exception to the cal ling env ironment.24. Examine this code

BEGIN

theater_pck.v_total_seats_sold_overall := theater_pck.get_total_for_year;

END;

For t his code to be successful, what must be true?

A. Both the V_TOTAL_SEATS_SOLD_OVERALL variable and theGET_TOTAL_FOR_YEAR function must exist only in the body of theTHEATER_PCK package.

B. Only t he GET_TOTAL_FOR_YEAR variable must exist in the specification of theTHEATER_PCK package.

C. Only t he V_TOTAL_SEATS_SOLD_OVERALL variable must exist in thespecification of the THEATER_PCK package.

D. Both the V_TOTAL_SEATS_SOLD_OVERALL variable and theGET_TOTAL_FOR_YEAR function must exist in the specification of the

THEATER_PCK package.25. A stored function must return a value based on conditions that aredetermined at runtime. Therefore, the SELECT statement cannot be hard-

coded and must be created dynamically when the function is executed. Which

Oracle supplied package will enable this feature?

A. DBMS_DDL



5/21

C interview questions Software tester interview questions

Ads by Google

ETL Open SourceDownload

Fast, Powerful, Affordable,Easy Migration Tools. FreeDownload!

www.Talend.com/Open_Sou _

Encrypt Data/Files1 centralized encryptionprogram-- for allDBs/apps/files. See how.

Vormetric.com/Database-

Encryption

B. DBMS_DMLC. DBMS_SYND. DBMS_SQL

This entry was posted inDatabase. Bookmark t hepermalink.Post a commentor leave a

trackback: Trackback URL.

5 0 C O M M E N T S O N P L / S Q L I N

Sachin Rastogi ([email protected])Posted 5/9/2004 at 11:27 pm |Permalink

Thanks again for publishing my questions.

SudhirPosted 5/14/2004 at 10:49 am |Permalink

1.12.2

3.14.(1,3,4)5.26.37.48.29.210.(3,4)11.112.413.114.115.316.317.1

18.(1,4)19.420.321.422.223.424.325.4

please let me know how many answers are right. in this pl/sql test.

Thanks & Regards,Sudhir Rao.

UnnamedPosted 9/20/2004 at 6:27 am |Permalink

Answer to question-2 is 4

http://www.web2pdfconvert.com/?ref=PDFhttp://www.web2pdfconvert.com/?ref=PDFhttp://www.techinterviews.com/wp-trackback.php/97http://googleads.g.doubleclick.net/aclk?sa=l&ai=B3uxpB_TsTKixCKLPlQfn07ThCbDn1c0BiNK9kBbAjbcBgNyIARACGAIg8pn0ASgCOABQt_7_hfv_____AWDJroqM0KSIEqABpK37-QOyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOAAgGoAwHoAx_oA9cC6AM99QMAAADE&num=2&sig=AGiWqty54lk824tOSRoyWPuOJJ_jGClXRA&client=ca-pub-1894578950532504&adurl=http://enterprise-encryption.vormetric.com/database-encryption.html%3F_kk%3Dencrypt%2520oracle%26_kt%3D43d92454-3ce0-40ee-a096-5e52fd2ca591http://googleads.g.doubleclick.net/aclk?sa=l&ai=B3uxpB_TsTKixCKLPlQfn07ThCbDn1c0BiNK9kBbAjbcBgNyIARACGAIg8pn0ASgCOABQt_7_hfv_____AWDJroqM0KSIEqABpK37-QOyARZ3d3cudGVjaGludGVydmlld3MuY29tyAEB2gE4aHR0cDovL3d3dy50ZWNoaW50ZXJ2aWV3cy5jb20vcGxzcWwtaW50ZXJ2aWV3LXFpdWVzdGlvbnOAAgGoAwHoAx_oA9cC6AM99QMAAADE&num=2&sig=AGiWqty54lk824tOSRoyWPuOJJ_jGClXRA&client=ca-pub-1894578950532504&adurl=http://enterprise-encryption.vormetric.com/database-encryption.html%3F_kk%3Dencrypt%2520oracle%26_kt%3D43d92454-3ce0-40ee-a096-5e52fd2ca591http://googleads.g.doubleclick.net/aclk?sa=l&ai=BNhXFB_TsTKixCKLPlQfn07ThCYCU1M8Bupzmsw3AjbcBoK2iARABGAEg8pn0ASgCOABQ5t2LwgVgya6KjNCkiBKgAYzhm_EDsgEWd3d3LnRlY2hpbnRlcnZpZXdzLmNvbcgBAdoBOGh0dHA6Ly93d3cudGVjaGludGVydmlld3MuY29tL3Bsc3FsLWludGVydmlldy1xaXVlc3Rpb25zyALgv8sFqAMB6AMf6APXAugDPfUDAAAAxA&num=1&sig=AGiWqtxPZOVfMYleVngguvP-BaiuEBMc2w&client=ca-pub-1894578950532504&adurl=http://www.talend.com/download_form.php%3Fcont%3Detl%26utm_source%3Dgoogle%26utm_medium%3Dcpc%26utm_content%3DETLOS_DL%26utm_campaign%3DG_ETL_NA_Content%26utm_term%3Dwww.techinterviews.com%26src%3DGoogleAdwordsRD_US%26kid%3Dnullhttp://googleads.g.doubleclick.net/aclk?sa=l&ai=BNhXFB_TsTKixCKLPlQfn07ThCYCU1M8Bupzmsw3AjbcBoK2iARABGAEg8pn0ASgCOABQ5t2LwgVgya6KjNCkiBKgAYzhm_EDsgEWd3d3LnRlY2hpbnRlcnZpZXdzLmNvbcgBAdoBOGh0dHA6Ly93d3cudGVjaGludGVydmlld3MuY29tL3Bsc3FsLWludGVydmlldy1xaXVlc3Rpb25zyALgv8sFqAMB6AMf6APXAugDPfUDAAAAxA&num=1&sig=AGiWqtxPZOVfMYleVngguvP-BaiuEBMc2w&client=ca-pub-1894578950532504&adurl=http://www.talend.com/download_form.php%3Fcont%3Detl%26utm_source%3Dgoogle%26utm_medium%3Dcpc%26utm_content%3DETLOS_DL%26utm_campaign%3DG_ETL_NA_Content%26utm_term%3Dwww.techinterviews.com%26src%3DGoogleAdwordsRD_US%26kid%3Dnullhttp://www.google.com/url?ct=abg&q=https://www.google.com/adsense/support/bin/request.py%3Fcontact%3Dabg_afc%26url%3Dhttp://www.techinterviews.com/plsql-interview-qiuestions%26hl%3Den%26client%3Dca-pub-1894578950532504%26adU%3Dwww.Talend.com/Open_Source_ETL%26adT%3DETL%2BOpen%2BSource%2BDownload%26adU%3DVormetric.com/Database-Encryption%26adT%3D%2BEncrypt%2BData/Files%26gl%3DUS&usg=AFQjCNHNnMGvcTxLZSvWX_lC3zMXbMBjNwhttp://www.techinterviews.com/software-tester-interview-questionshttp://www.techinterviews.com/c-interview-questionshttp://www.techinterviews.com/plsql-interview-qiuestions/trackbackhttp://www.techinterviews.com/interview-questions/database


6/21

dczPosted 9/25/2004 at 2:52 a m |Permalink

24 IS 4

Stephen JacobPosted 9/27/2004 at 9:30 pm |Permalink

The answer to the question 8 is wrong; should be 3.

Stephen JacobPosted 9/27/2004 at 9:37 pm |Permalink

Answer to number 9 should be 4.How can y ou check for the initial value, if there is no user input?

Ahamed Tharik.NPosted 10/18/2004 at 2:32 am |Permalink

The Answer to the question 8 is 3rd Choice.

Ahamed Tharik.NPosted 10/18/2004 at 2:51 am |Permalink

Question 13 all the four answers are wrong , the function executed like this

SQL> select get_budget(11 ) into :g_yearly _budget from dual;

GET_BUDGET(11)

Let me know, if y ou hav e any Suggestions.

Francisco J. BandaPosted 10/25/2004 at 3:20 pm |Permalink

The Answer to the question 5 is 4rd Choice.If you are missing the END LOOP (2), the loop do not work, procedure does notcompile.


The Answer to the question 5 is 1rd Choice.Itis imposible that both 3 and 4 are correct. We do not need location (where) weneed time (when).


The Answer to the question 5 is 3rd Choice.The 4rd (Oracle Forms trigger) is in some way correct, but oracle triggers andForms triggers are not the same. This question is about Oracle triggers (not



7/21

Forms).


Hi Ahamed Tharik.N y our answer is correct, but also answer number 2 worksto be able to see the result uses SQL>print g_yearly_budget.

Pranav VoraPosted 6/14/2005 at 1:25 am |Permalink

The answer to the question 13 should be 2.

I fully agree with Francisco J. Banda. For Francisco, y our answers are right,just match question numbers.

I tried to do and here is the revised answer list. (T means correct answer choice)

1.)1 : T2.)2 - 4 : 4 - T

3.)1 : T4.)(1,3,4) - T5.)2 - 4 : 4 - T6.)3 - T7. )4 - T8.)2 - 3 - 3 : 3 - T9.)2 - 4 : 4 - T10.)(3,4) - 111.)1 - [I dont know correct answer]12 .)4 - 3 : 3 - T13 .)1 - ? : 2 - T

Thanks.

Arti ShahPosted 9/29/2005 at 7:33 am |Permalink

1.12.43.24.1,3,55.26.2,37.18.39.410.4

11.412.113.214.415.316.217.218.119.420.321.422.223.424.425.4

vijayPosted 12/15/2005 at 7:04 am |Permalink



8/21


9/21

14.2 (In When Others clause of Exception Handler, we can trap the SQLCODEand display user friendly message.)15.316.317.118.119.420.1 (Both the package spec and the package body must be compiled only whenthe global function definition changes)21.222.223.424.425.4

Goodluck!!

Ram Pratap SinghPosted 9/23/2006 at 1:20 pm |Permalink

The Correct answers are:1: 12: 4

3: 14: 1 3 45: 46: 37: 48: 39: 410: 111: 112: 313: 214: 215: 316: 317: 1

18: 1 219 None Of Them20: 221: 222: 223: 424: 425: 4

Gab O'layomiPosted 11/1/2006 at 10:29 am |Permalink

Think all my answers are correct

1. 12. 43. 14. (1,3,5)5. 46. 37. 48. 39. 410. 111. 112. 313. 214. 1 (Im sure this is correct but may be 4 can also)15. 316. 317. 118. 119. 420. 3



10/21

21. 422. 223. 424. 425. 4

praveenPosted 11/18/2006 at 10:00 am |Permalink

can somebody explain 20th question:i feel that all the 4 answers are correctand for 2 1st question i feel that 2 and 3 are correct answers.Please support yourans by some examples,so that it can be understood by one and all.Thanks inadvance.

sachin GondalePosted 12/4/2006 at 5:29 am |Permalink

These are Correct answers:

1 - 1

2 - 43 - 14 - 1,3,45 - 46 - 37 - 48 - 39 - 410 - 111 - 112 - 313 - 214 - 115 - 316 - 3

17 - 118 - 119 - 420 - 121 - 222 - 223 - 424 - 425 - 4

Prashant SinhaPosted 1/17/2007 at 5:25 am |Permalink

1.12.43.14.1,3,45.16.37.48.39.410.111.212.313.4

16.317.118.1



11/21

Potkin NematPosted 1/25/2007 at 12:41 pm |Permalink

I get:

1) 1,2 [2 must be true - anything should be handled with great care :)]

2)1,23)14)1,3,45)46)37)48)39)110)411)112)313)414)115)316)317)118)119)420)1,2

21)422)223)424)425)4

GKPosted 1/26/2007 a t 9:57 am |Permalink

Why do most people feel that you need to delcare a record type for a cursor forloop as in q 2? I have NEVER created a record type for a cursor for loop. I thinksuch a basic question not being answered correctly is strange.

number 1 and number 4 are both correct.

Good job Potkin Namat, youre the million dollar winner because you didntlisten to the masses.

AvneeshPosted 1/28/2007 a t 6:22 am |Permalink

Well I guess the answers are :

1 -1

2- 13- 14- 1,3,45- 46- 37- 48- 39- 210- 411 - 112- 313- 214- 115- 3

16- 317 - 118- 119- 420- 121- 222- 22 -



12/21

24- 425- 4

NAGURTILAKPosted 3/15/2007 at 1:24 pm |Permalink

1)32)4

3)14)1,3,45)26)37)48)39)410)211)112)313)214)115)416)317)1

18)119)420)221)222)223)424)425)4

THIS IS TILAK OK

sdpPosted 4/9/2007 at 1:12 a m |Permalink

I think these r the right answers1)12)13)14)1,3,45)46)37)48)39)410)211)112)113)214)315)316)317)118)119)420)121)422)223)424)425)4

DivaPosted 4/17/2007 at 8:11 am |Permalink

My Answers are:-



13/21

1.1,23.14.1,3,45.46.37.48.39.410.111.112.313.215.316.317.318.119.421.222.223.425.4

skk

Posted 4/18/2007 at 6:40 am |Permalink

Tell me how many answers are right.This is my first try .1)32)43)14)3,4,55)46)37)18)49)210)411)2

12)313)114)115)316)217)218)419)320)421)222)223)424)425)4

DeviPosted 5/15/2007 at 1 :48 am |Permalink

1-12- 13- 14- 15- 46- 37- 48- 39- 210- 411 - 112- 313- 214- 115- 316- 3



14/21

17 - 118- 119- 420- 121- 222- 223- 424- 425- 4

AravindaPosted 6/12/2007 a t 3:53 am |Permalink

Hi guys,

I gave this test, and would like to know how much I score. Ofcourse, everyonehas posted what they think are the r ight answersbut, do we hav e someexpert here, who can be nice enough to compile a list of the correct answers toall questions?! Here are my answers, I am not sya ing they right, so kindly DONOT use to check. I only want to know my score.

Thanks in advance!

Arvinda.

1-12-43-14-1,2,35-46-37-48-39-410-211-112-313-4

14-115-316-317-118-119-420-221-222-223-424-425-4

johnnyPosted 6/12/2007 at 8:08 am |Permalink

Hi frnds, ths johnny.

Hres d key 4 d ??? stated > ^

1.12.13.14.1,3,45.46.3

7.48.39.410.111.112.313.2



15/21

14.115.316.317.118.119.420.121.222.223.424.425.4

samarendra mishraPosted 7/6/2007 at 5:29 am |Permalink

1-12- 43- 14- 1,3,45- 46- 37- 4

8- 39- 410- 111 - 112- 313- 214- 115- 316- 317 - 118- 119- 420- 221- 222- 2

23- 424- 425- 4

mahendra ranePosted 8/3/2007 at 8:46 am |Permalink

1-12- 43- 14- 1,3,45- 4

6- 37- 48- 39- 410- 111 - 112- 313- 214- 115- 316- 317 - 118- 119- 420- 221- 222- 223- 424- 425- 4



16/21

Suman BejPosted 8/14/2007 at 2:00 am |Permalink

Hi,I think the answer should be :1-12- 43- 14- 3,4,5

5- 46- 37- 48- 39- 410- 111 - 112- 313- 214- 115- 316- 317 - 118- 119- 4

20- 221- 222- 223- 424- 425- 4

swarnaPosted 8/17/2007 at 3:42 am |Permalink

In the above implicit cursor attributes are only to_many _rows

Anil kapilPosted 11/14/2007 a t 7:20 am |Permalink

1)12)43)14)2,3,45)6)37)48)39)410)211)112)313)414)315)316)317)218)119)420)21)422)223)4

24)425)4

sdp



17/21

Posted 11/28/2007 at 1 :33 am |Permalink

1)12)43)14)1,3,45)46)37)48)39)410)111)112)313)214)315)316)317)118)119)420)121)422)223)424)4

25)4

SoanliPosted 2/22/2008 at 12:46 am |Permalink

HiThese are my anss can u plz tell me my score how many r right & wrongqtn ans1 12 13 34 1,3,4

5 46 37 48 39 410 411 112 313 214 115 316 317 318 119 3

20 221 222 223 424 425 4

banvari lal mauryaPosted 3/27/2008 at 3:05 am |Permalink

hi here is my answer could you tell how many answers are correct. Thank y ou.

1. 12. 43. 14. 1 , 3 , 45. 46. 37. 4



18/21

8. 39. 410. 111. 112. 313. 214. 315. 116. 317. 118. 1

19. 320. 221. 222. 223. 124. 425. 4

Deepika S VermaPosted 4/3/2008 at 4:37 a m |Permalink

1. 1

2. 43. 14. 1,3,45. 46. 37. 48. 39. 410. 111. 1 only one for which exception is raised12. 313. 214. 1 befor updating check whether data exist and if yes then handle inexception with user defined exception else update the data.15. all the procedures / packages depend on altered procedure / package

needs to be compiled again.16. 317. 118. 119. 420. If any of the change is made either in spec or body , we need to compile bothspec and body of package and all the depending packages.21. 322. 223. 424. 425. 4

tahirPosted 4/30/2008 at 12:25 am |Permalink

1 12 23 14 1 3 45 46 57 48 39 4*10 1

11 112 313 414 1*15 316 217 1*



19/21

18 119 120 1234*21 222 223 424 425 4

ALEX.CPosted 8/13/2008 at 9:34 am |Permalink

My answers are:

1) 1;2) 2;3) 1;4) 1,3,4;5) 2;6) 3;7) 4;8) 3;9) 4;

10)2;11)4;12)3;13)1;14)1;15)1;16)3;17)3;18)1;19)2;20)1,4;21)2;22)2;23)4;24)4;

25)1.

KanvikPosted 9/20/2008 at 3:43 am |Permalink

HiiIf any expert can go through my answers and tell my result then i would bbethankful to him.

My Answers1. 1

2. 13. 24. 1,3,45. 36. 37. 48. 39. 410. 111. 212. 313. 214. 215. 316. 317. 318. 419. 420. 221. 222. 223. 4



20/21


21/21

Power ed by WordPress. Built on the Thematic Theme Framework.

Name* Email *

Post Comment

P O S T A C O M M E N T

Your email is never published nor shared. Required fields are marked *

Website

Comment

3)* 1 1 1 1 1 24)* 1,3,4 1,3,4 1,3,4 1,3,4 (1,3,5) 1,3,55)* 2 4 4 4 4 26)* 3 3 3 3 3 2,37)* 4 4 4 4 4 18) 3 3 3 3 3 39)** 4 4 2 1 4 410)** 2 1 4 4 1 411)* 1 1 1 1 1 412)* 3 3 3 3 3 113) 2 2 2 4 2 214)* 1 1 1 1 1 415)* 4 3 3 3 3 316)* 3 3 3 3 3 217) 1 1 1 1 1 218) 1 1 1 1 1 119) 4 4 4 4 4 420)* 2 2 1 1,2 3 321)* 2 2 2 4 4 422) 2 2 2 2 2 223) 4 4 4 4 4 424) 4 4 4 4 4 425) 4 4 4 4 4 4
http://www.techmedianetwork.com/advertisers.htmlhttp://themeshaper.com/thematic-for-wordpresshttp://wordpress.org/

www tech interviews com

Documents