There are many different types of job interview questions asked by Oracle job interviewers. A few of the common questions and answers relating to SQL follow.

What is the command to see the current user name? show user;How do you change the SQL prompt name? Set sqlprompt “changed_name >”How do you display row numbers with records? Use the rownum pseudocolumn with the query: SQL> SQL> select rownum, ename from emp;What are the explicit cursor attributes? Cursor_name%FOUND, cursor_name%NOTFOUND, cursor_name%ROWCOUNT, cursor_name%ISOPENWhat are the implicit cursor attributes? SQL%FOUND, SQL%NOTFOUND, SQL%ROWCOUNT, SQL%ISOPENHow to you view installed Oracle version information? Select banner from v$version;Which date function returns a number value? Months_betweenWhat are the PL/SQL exceptions? Too_many_rows, No_Data_Found, Value_Error, Zero_Error, OthersHow do you replace a null value in a query result with text? Set NULL ‘N/A’ To reset the SQL prompt, use set NULLWhat is the minimum number of triggers that can be applied to a single table? 12

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Ask a Question

Not finding the advice and tips you need on this ERP Jobs Tip Site? Request a Tip Now!

Guru Spotlight

Jerry Mayo

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!