Hi Visitor,
We heartily
Thanks to ANJALESH for sharing his interview experience with Q-4-Interview.
Kindly find below
the Accenture Telephonic Interview questions for pl/sql developer @ exp 1.4.
Tell me about
yourself?
SQL:
====
DO YOU KNOW ABOUT
TRIM FUNCTION?
WHAT IS LTRIM AND
RTRIM?
DO YOU KNOW ABOUT
PADDING THEN WHAT IS LPAD AND RPAD?
WHAT IS INSTR
FUNCTION
WHAT IS SUBSTR
FUNCTION
WHAT IS DIFFERENCE
BETWEEN UNION AND UNION ALL
WHAT IS
DIFFERENCE BETWEEN ROWID AND ROWNUM
WHAT IS
ROW_NUMBER() FUNCTION THEN WHAT IS THE USE OF OVER() CLAUSE.
DO YOY KNOW ABOUT
JOINS IN SQL?
WHAT IS FULL
OUTER JOIN
WHAT IS THE GROUP
BY CLAUSE?
WHAT IS THE USE OF
HAVING CLAUSE WITH GROUP BY
WHAT IS
PSEDOCOLUMNS
pl/sql
======
What is
difference between procedure and function?
How to return
value using procedure in pl/sql?
What is syntax of
pl/sql function?
What is view?
What is
Materialized View?
What is
difference between view and Materialized View?
What is package
in pl/sql ?
What is advantage
of package in pl/sql?
What is index?
What is sequence?
What is trigger
in pl/sql?
What is the use
of pl/sql trigger and how many type of trigger?
What is synonym
in pl/sql?
What is
collection in pl/sql?
How to reduce
execution time of any sql query?
Do you know about
bulk collect and forall?
For more recent
interview question of various companies follow Q-4-Interview at Facebook.
No comments:
Post a Comment