| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between normal and corelated subqueries? | | 2 |
| SQL> CREATE TABLE to_table
2 (col1 NUMBER);
Table created.
SQL> CREATE OR REPLACE TRIGGER statement_trigger
2 AFTER INSERT ON to_table
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('After Insert Statement
Level');
5 END;
6 /
Trigger created.
SQL> CREATE OR REPLACE TRIGGER row_trigger
2 AFTER INSERT ON to_table
3 FOR EACH ROW
4 BEGIN
5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level');
6 END;
7 /
Trigger created.
SQL> INSERT INTO TO_TABLE VALUES(1);
After Insert Row Level
After Insert Statement Level
1 row created.
SQL> BEGIN
2 INSERT INTO TO_TABLE VALUES(2);
3 INSERT INTO TO_TABLE VALUES(3);
4 INSERT INTO TO_TABLE VALUES(4);
5 INSERT INTO TO_TABLE VALUES(5);
6 INSERT INTO TO_TABLE VALUES(6);
7 INSERT INTO TO_TABLE VALUES(7);
8 INSERT INTO TO_TABLE VALUES(8);
9 INSERT INTO TO_TABLE VALUES(9);
10 INSERT INTO TO_TABLE VALUES(0);
11 END;
12 /
WAT LL BE THE O/P???
XPLAIN IT>>>> | Infosys | 1 |
| waht is referencial integrity? | Semantic-Space | 2 |
| what is the uses of cusor | Perot-Systems | 3 |
| 26. Display the earliest shipping date in the format:
DD/MON/YYYY | Wipro | 5 |
| what is the use of composite key constraint? | | 2 |
| 17. Display the order number and average item cost for each
order. | Wipro | 1 |
| how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as only NN,but not other
alphabets, if NN is thre means i should display , otherwise
leave that blank or empty Its some urgent
requirement ,thanks in advance | | 1 |
| how will I find the first 5 highest salaried employees in
each dept in oracle. | IBM | 13 |
| What are main difference between Stored Procedure and
Functions. | CA | 3 |
| What are the factors that affect OPTIMIZER in choosing an
Optimization approach ? | | 1 |
| a query to select maxmun 3 salaries of employee table | Polaris | 10 |
| why can't we assign not null constraint as table level
constraint | CTS | 2 |
| What is a Database instance ? Explain? | | 2 |
| SQLERRM is a
a. Constraint
b. Pre Defined Exception
c. Pseduocolumn
d. Constant
e. None of Above. | Cognizent | 2 |
| What are the type of Synonyms? | | 1 |
| when do u go for hash partitioning? | | 1 |
| What are the components of Logical database structure of
ORACLE database? | | 3 |
| pls explain connect by prior with example and its real time
use | | 3 |
| What are the factors causing the reparsing of SQL statements
in SGA? | | 1 |
| |
| For more Oracle General Interview Questions Click Here |
Site Map
