Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Infosys Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

 2 18292

What are Clusters ?

 5 6512

what is difference between foreign key and reference key

 3 37205

what is unique key?

 14 18168

what is the difference between primary key & foreign key?

 57 107755




How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

 2 5944

structural difference between bitmap and btree index ?

 1 10456

how to retrieve daily sal from emp table in oracle 10g

 2 4630

which language is used to develop the oracle........?

 4 9815

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>>>>

 1 2675

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

 1327

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 5314

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

 1 2645

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

 382

Explain the use of Merge statement in oracle 11g

 159

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions


Un-Answered Questions

Can python be multithreaded?

80

How can I learn php fast?

113

Process of the settlement cycle?

1091

What are pages in wordpress?

25

What do you understand by the cashless economy?Does it have any pros and cons?

167




What is the importance of Blue Prism?

1

What would you do if your manager criticised your work?

174

write a script for allinterview-submit Question first we've to select Choose Category,second select Sub- Category(Which is comes in to runtime)third select Question Type.for that give some descriptive and vb script

915

what are decleratives in cobol?

1209

what is the height of tree if leaf node is at level 3. please explain

1105

Hi All, Im currently getting to grips with the Document Generator in Test Director and have a query. We use TD to link requirements to test cases and I am attempting to produce a report which lists the requirement and the test case it is linked to. I cant see a way to do this as the test case link info resides on the Coverage page and it appears the only field available to display for requirements reports within document generator as those on the 'details' tab. Any tips?

1222

What is near, far and huge pointers? How many bytes are occupied by them?

151

What are the destinations of the organic material fabricated by the producers?

13

Explain what is row_number function?

115

explain about yourself with your streangth and weakness. and also tell me why do you want to do mba?

1007