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 17399

What are Clusters ?

 5 5984

what is difference between foreign key and reference key

 3 36061

what is unique key?

 14 17135

what is the difference between primary key & foreign key?

 57 104771




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 5687

structural difference between bitmap and btree index ?

 1 10187

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

 2 4375

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

 4 9450

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 2482

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

 1184

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

4 5041

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 2440

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.

 237

Explain the use of Merge statement in oracle 11g

 28

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions





Un-Answered Questions

1 light year is approx equal to

1366

What are some factors to consider when trying choosing between a dry screw compressor and an oil-flooded screw compressor?

13

i want to take the fast track training on >net Frame work and work flows and share point could you tellme the good institutes for that cources

958

1) a)to prepare mortar for bricklaying how much amount of water should be added for its maximum strength and workability(to avoid cracks which results, when high quantity of water is added)?is their a formula or ratio? b) suppose we want to make 1:3 mortar,what is the best way to measure cement ,sand and water and how? c)time before which freshly prepared mortar should be used? d)proper way to mix and make mortar? e)when should curing start after laying bricks and for how long?and also how many hours per day? f)what is shear wall (please in terms of layman lol) bookish definisions are confusing.... g) and last,acc to codes what are max no. of course that should be laid in a day.

1001

What are the types of Knowledge Modules?

1




What is the difference between method parameters and method arguments. Give an example?

15

What is the difference between merge and update method?

1

What is your daily work process in tableau?

11

What is dynamic linking?

17

what is silverlight.js file? Explain with an example.

1

Applications written to provide a GUI shell for Unix and Linux are called

31

What is the difference between hashfile and sequential file?

21

What is the use of enumerate() in python?

7

What is kyc? Why is it important?

6

Name some of the current controlled (current driven) devices?

20