PL/SQL Interview Questions and Answers

0 votes

Q: A Table Is Classified As A Parent Table And You Want To Drop And Re-create It. How Would You Do This Without Affecting The Children Tables?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Give Two Examples Of Referential Integrity Constraints ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: What Type Of Index Should You Use On A Fact Table ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Give The Two Types Of Tables Involved In Producing A Star Schema And The Type Of Data They Hold ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Give The Reasoning Behind Using An Index ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Compare And Contrast Truncate And Delete For A Table ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Where Would You Look For Errors From The Database Engine?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+2 votes

Q: Explain The Difference Between A Data Block, An Extent And A Segment ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: How Do You Switch From An Init.ora File To A Spfile?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: You Have Just Had To Restore From Backup And Do Not Have Any Control Files. How Would You Go About Bringing Up This Database?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Explain The Difference Between A Hot Backup And A Cold Backup And The Benefits Associated With Each ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Explain what are The Types Of Triggers?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: How Can You Generate Debugging Output From Pl/sql?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: How Can You Find Within A Pl/sql Block, If A Cursor Is Open?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

0 votes

Q: Explain what are Sqlcode And Sqlerrm And Why Are They Important For Pl/sql Developers?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

0 votes

Q: In What Order Should A Open/fetch/loop Set Of Commands In A Pl/sql Block Be Implemented If You Use The %notfound Cursor Variable In The Exit When Statement? Why?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: When Is A Declare Statement Needed ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Describe The Use Of Pl/sql Tables ?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: What Packages (if Any) Has Oracle Provided For Use By Developers?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Describe The Use Of %rowtype And %type In Pl/sql?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Which Function Is Used To Find The Largest Integer Less Than Or Equal To A Specific Value?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

0 votes

Q: What Operator Tests Column For The Absence Of Data?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: What Operator Performs Pattern Matching?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: What Command Is Used To Get Back The Privileges Offered By The Grant Command?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Which Command Displays The Sql Command In The Sql Buffer, And Then Executes It?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+2 votes

Q: Explain what Is The Use Of Cascade Constraints?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Can One Read/write Files From Pl/sql?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Is There A Limit On The Size Of A Pl/sql Block?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Is There A Pl/sql Engine In Sql*plus?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

+1 vote

Q: Explain what Is Pl/sql?

asked Mar 7, 2021 in PL/SQL by SakshiSharma

Page:

« prev
1
2
3
4
5
6

...