Where do you see yourself in next 3-5 years?
Plsql Interview Questions
295 plsql interview questions shared by candidates
what are packages, functions , procedures, exception handling , dynamic SQL, Create table syntax , indexes , triggers etc
Are you able to relocate burglar
syntax of various constraint and what will be output of given query
2nd Max sal, duplicate values, analitical functions, date functions, trunc function
Is it possible to put not null constraint on null values field.
Tell me about yourself and work experience
Records type , index , query tuning
What is faster subquery or CTE What is veiw and materialized view if we delete a table what will be the result of select * from the view created on the table what are analytical functions order salary based on Rownumber,rank,denserank procedure for a palindrome write a syntax of procedure with all blocks what are indexes and its type merge statement (can we use a same table in merge) left join and inner join and right join for below Table 1 Table 2 column 1 column1 1 1 1 0 0 null null null second highest salary
1. How do you secure your table data 2. What are normal view and materialized view 3. Refresh policy in a materialized view 4. Triggers. Types of triggers 5. Row level and statement level trigger 5. How will you create a table for logging purpose 6. What is a sequence [Scenario = EMP_ID is created using sequence. Table sequence is stuck at value=12. Record with EMP_ID=15 is inserted into the table. How will you analyze the issue]
Viewing 71 - 80 interview questions