1. Is it possible to Auto-Refresh the
Materialize View?
Yes it is possible. During declaration, you can specify the auto refresh interval of the mview.
Sol:The DBMS_MVIEW package contains three APIs for performing
refresh operations:
•DBMS_MVIEW.REFRESH
Refresh one or more materialized views.
•DBMS_MVIEW.REFRESH_ALL_MVIEWS
Refresh all materialized views.
•DBMS_MVIEW.REFRESH_DEPENDENT
Refresh all materialized views that depend on a specified master
table or materialized view or list of master tables or materialized views.
CREATE materialized VIEW yarpno_mv 2 refresh fast 3 NEXT trunc(sysdate+1) 4 AS SELECT * FROM yarpno;
2. Explain diff. types of Indexes? Which one is fasted?(IBM)
3. How to send mails multiple customers in a single select
query?(Bahwan Cyber Tech) sol : UTL_SMTP , UTL_MAIL
4. Explain about Nonralization.(Polaris)
6. What is passed by value & passed by reference? explain with
example.(Bahwan Cyber Tech)
7. What is Direct Path Loader?(IBM)
8. Diff. between Direct Path Loader vs Conventional Path
Loader?(IBM)
9. Sql loader is for upload or download or both?(LNT)
10. How to load other than csv file? (iGATE)
11. How to skip a column in sql loader?(IBM)
12. DML operations inside the exception handling path ( when
others then) is possible? Explain.(Polaris)
13. What i & g mean by in Oracle versions? (DNB-Dun &
Broadstreet)
14. what are diff. in 10g & 11g? (RAMCO)
15. what is diff. between cursor & ref cursor? (LNT)
16. what is diff. between nested table & varray?(iGATE) Greens Technology’s Contact :-9840496320
17. what is diff. between ref cursor & bulk collect?(Bahwan
Cyber Tech)
18. What is global cursor? (CTS)
19. what will happen when we use COMMIT in Trigger? (Polaris)
20. How many number of triggers possible? (LNT)
21. HOW TO SEE INVALID INDEXES?HOW TO REBUILD INVALID INDEXES USING PL/SQL BLOCK?(Polaris)
22. TELL ME ABOUT BULK_COLLECT & BULK_BIND.(Bahwan Cyber Tech)
23. WHAT IS DIFF B/W NOT EXITS & MINUS?(IBM)
24. What is the physical and logical structure of oracle?(Polaris)
25. how can u open multiple files in Unix is it possible?
26. Created procedure has 5 parameters if the same procedure is
called with 3 parameters will it work? What is the error will it give? (hexaware)
27. What is pragma EXCEPTIO_INIT_?(Polaris)
28. HOW TO COUNT NO OF RECORDS IN TABLE WITHOUT COUNT?(Bahwan Cyber Tech)
29. HOW TO RETRIVE TOP 3 SALARIES FROM EACH DEPARTMENTS?(IBM)
30. WHAT IS CONTEXT SWITHCING?(TCS)
31. WHAT IS BULKCOLLECT? AND ANY RESTRICTIONS IN BULKCOLLECT?(iGATE)
32. WHAT IS FUNCTIONAL BASED INDEX? WRITE SYNTAX?
33. CAN YOU ALTER PROCEDURE WITH IN PACKAGE?(iGATE)
34. IS IT POSSIBLE TO OPEN CURSOR WHICH IS IN PACKAGE IN ANOTHER PROCRDURE?(Polaris)
35. DIFFERENCE BETWEEN CASE AND DECODE?(iGATE)
36. CAN YOU USE SYSDATE IN CHECK CONSTRAINTS? IF NO, WHY?(hexaware)
37. TELL ME SOME IMPORTANT ORACLE 11G FEATURES?(Bahwan Cyber Tech)
38. IF TABLE DROPPED, THEN WHAT HAPPEN VIEW?(hexaware)
39. WHICH FUNCTIONS ARE NOT SUPPORTED TO INDEX?(hexaware)
40. WHAT ARE THE DATATYPES AVILABLE IN PL/SQL, NOT IN SQL?
41. DIFF B/W EXPLICT CURSOR & FOR LOOP CURSOR?(Polaris)
42. WHAT IS RAISE_APPLICATION_ERROR?EXPLAIN(IBM)
43. HOW CAN YOU CALL PROCEDURE IN SELECT STATEMENT?(hexaware)
44. HOW TO DROP PACKAGE BODY ONLY?
45. What is the disadvantage of package?(Bahwan Cyber Tech)
46. CAN USE PRAGMA_AUTONAMOUS_TRANCTIONS IN PACKAGES?
47. HOW TO DEBUGG YOUR CODE?
48. How will you move the cursor with out using arrow keys in vi
editor in UNIX?
49. What is grep in UNIX? (Polaris)
50. How you get latest processed record in unix?(Polaris)
51. Write a script for check a file if it is available or no If
available rename it(unix).
52. What is inode and explain it (unix)(Polaris)
53. Write a correlated sub query and explain how it
works.(hexaware)
54. What are different type of triggers?
55. Write a pl/sql block for trigger at the time of insertion for
inserting old and new values in auditing table?(Bahwan Cyber Tech)
56. If we have both user exception and system exception, which
will be handled first?
57. How to access table from another database?
58. If I gave a select statement, it contains null data; I gave
NO_DATA_FOUND AND OTHERS in exception block? What exception will handles and
that procedure compiled or not? It will not compiled why because no choice appear with choice
others in exception handler.
59. How u know whether a table is locked or not?(unix)(Polaris)
60. How you know what are the preveliges you have?
61.Is it possible for "two objects have the same name"?
62. Can you see dba tables?
63. What is cluster?
64. What is dual ? can we truncate it ?
65. What is the difference between truncate and delete?
66. What is the difference between drop and delete?w
67. what is explain plan? explain?(IBM)
68. what is dbms_profiler? what are the uses.explin?
69. explain the steps you worked with the performance tunning.
70. what are the stepls for table partioning? explain?
71. is it composite primary key possilbe? if yes how give example.
72. what is the diff. between plsql table & record?
73. Is it possilbe to create index automatically?if yes explain
what and how?
74. how you create views without base table?
75. what is .bad file?
76. what is the result for the query - SELECT 'A' FROM DUAL
INTERSECT SELECT NULL FROM DUAL;
77. HOW you pass parameters into package?
78. To where you use execute immediate? what is the use of it?
79. is it possible to use Continue statement is in PL/SQL loops?
80. How many primary key you can use in a table?
81. What are Difference between WHERE & HAVING?
83. What is the difference between the cursor declared in the
procedure and cursor declared in the package?