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 17594

What are Clusters ?

 5 6061

what is difference between foreign key and reference key

 3 36239

what is unique key?

 14 17287

what is the difference between primary key & foreign key?

 57 105148




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 5725

structural difference between bitmap and btree index ?

 1 10246

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

 2 4421

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

 4 9499

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 2506

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

 1206

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

4 5064

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 2464

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.

 253

Explain the use of Merge statement in oracle 11g

 46

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions





Un-Answered Questions

What is the vector group of a transformer,how can it be found out?

991

how much maximum power can be generated by 320v, 10kg-cm synchronus motor if shaft is roteted mechanically at 50 to 60 rpm?

993

my diploma certificate in my higher education college

555

What is difference between transfer rules and update rules?

30

What methods is used to commit the changes made in DataSet object?

41




defult setting in p220 micom motor proction relay for 11kv,640kw,f.l.a.-40a,1440rpm ht motor?

2527

How do you swing an applet?

27

Whether setting up of diary plants comes under CMA under Farm Sector or Non Farm Sector

689

What do the PUT and INPUT functions do?

36

What is the use of –w?

20

Which class is used for basic button group?

1

Would you forego this job if you get a better opportunity?

46

How do the pan wala calculates his profit?

1421

What is Managed (also known as client or station) mode?

585

What is the gauss`s law?

29