Oracle Apps PL-SQL Interview Questions – Set 8

Oracle Apps PL-SQL Interview Questions – Set 8

  1. 1. From an Employee table, how will you display the record which has a maximum salary?
  2. 2. What is the difference between the Primary and Foreign key?
  3. 3. How will you delete a particular row from a Table?
  4. 4. How will you select unique values from a list of records?
  5. 5. What is meant by Join? What are the different types of Joins available? Explain.
  6. 6. Overloading of stored procedure is possible in oracle?
  7. 7. How to create table with in the procedure or function?
  8. 8. what is overloading procedure or overloading function ?
  9. 9. what is HASH join?
  10. 10. what is SCALAR Queries?
  11. 11. what is the use of HASH, LIST partitions?
  12. 12. <<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
  13. 13. cursor types? explain with example programs?
  14. 14. what is difference b/w pravite procedures and public procedures?
  15. 15. How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
  16. 16. How to get employee name from employee table which is the fiveth highest salary of the table
  17. 17. need to split a string into seperate values. eg. col1 col2 ———- 100 – ‘a,b,c’ 200 – ‘a,x,b,d,e’ 300 – ‘c’ result: value count ————- a – 2 b – 1 c – 2 etc.
  18. 18. How many levels can subqueries be nested in a FROM clause?
  19. 19. what is meant by databases
  20. 20. what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
  21. 21. Can we have exception part in trigger ?
  22. 22. using comand prompt how can import table data and table space with example
  23. 23. how can create data base link for tow servers (scott schema) give examples plz
  24. 24. if a table is getting updated what happens if a function is called from sql query?
  25. 25. There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102… Is it possible to do so ?
  26. 26. Write a query to find five highest salaries from EMP table. (there is a column SALARY)
  27. 27. what is the difference between cursor FETCH and FOR LOOP ?
  28. 28. what will be the output: select 1 from emp union all select 2 from emp;
  29. 29. Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
  30. 30. i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
  31. 31. write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
  32. 32. What is mutating trigger?How to avoid it??
  33. 33. can we delete the trigger in a view? if yes why if not why?
  34. 34. what is the difference between implicit and explicit trigger
  35. 35. how to sort records in sql?
  36. 36. can we call a procedure from a function?
  37. 37. Talk about views
  38. 38. Difference between DBMS and RDBMS…CODD’s rules
  39. 39. Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
  40. 40. Difference between IN and EXISTS
  41. 41. What is Primary Key?
  42. 42. how u can find the n row from a table?
  43. 43. What is normalization?
  44. 44. how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column’s value of a resulted set of executed query
  45. 45. Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
  46. 46. Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
  47. 47. please explain database architecture..
  48. 48. what is single byte over head in oracle..?
  49. 49. What are wait events. Describe the wait event tables.
  50. 50. I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.
  51. 51. I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
  52. 52. why sql is used as interpreter frequently rather than a compile?
  53. 53. Describe the Index, Types of index, At what situation we have used? Which one s better than others?
  54. 54. how many tupples can insert in 1 second in sql
  55. 55. What is the default value of CHAR type?
  56. 56. I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)
  57. 57. suppose we have a table in which 200 rows. i want to find 101 row ? what the query…. and how we find 4th and 5th highest salary and 1 to 10 highest salary
  58. 58. What does “select count(1) from tab” result?
Visit Us On FacebookVisit Us On Google PlusVisit Us On TwitterVisit Us On YoutubeVisit Us On LinkedinCheck Our Feed