SQL Plus Interview Preparation Guide
Download PDF
Add New Question

SQL Plus guideline for job interview preparation. Explore list of SQL Plus frequently asked questions(FAQs) asked in number of SQL Plus interviews. Post your comments as your suggestions, questions and answers on any SQL Plus Interview Question or answer. Ask SQL Plus Question, your question will be answered by our fellow friends.

20 SQL Plus Questions and Answers:

1 :: Please Explain Connect by Prior?

Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.

"connect by prior" is clause which is used in hierarchical queries.Example
select ename,empno,mgr,job
from emp
start with job='PRESIDENT'
connect by prior empno=mgr;
Post Your Answer

2 :: Explain ROWID?

ROWID is a pseudo column generated at the run time(during inserting value). Its a hexadecimal value which is unique identification for each record
Post Your Answer

3 :: Explain Explicit Cursor attributes?

%IS OPEN,%FOUND,%NOT FOUND,%ROW COUNT
Post Your Answer

4 :: Explain What is a database link?

Database Link is a named path through which a remote database can be accessed
Post Your Answer

5 :: Explain What is a corelated subquery?

Correlated subquery is the subquery, where the subquery has been executed for the every row processed by the parent statement.
Post Your Answer
Add New Question