Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 19279

What are Clusters ?

5 7050

what is difference between foreign key and reference key

3 38317

what is unique key?

14 19335

what is the difference between primary key & foreign key?

57 111719





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 6301

structural difference between bitmap and btree index ?

1 10715

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

2 4923

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

4 10276

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 2909

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

1462

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

4 5735

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 2858

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.

510

Explain the use of Merge statement in oracle 11g

279

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions


Un-Answered Questions

Explain what is an application domain?

224


Why does reading require write privileges on database file?

199


What is the difference between a synchronized method and a synchronized block?

234


Why we use intwritable instead of int? Why we use longwritable instead of long?

63


How do you store pictures in a database?

242






Does mongodb have a schema?

1


Is it hard to learn django?

47


What is the use of header() function in PHP? What the Limitation of HEADER()?

252


why do we not deduct volume of steel to find actual volume of concrete in practical???

942


What is bootstrap array in angular 2?

184


What is the importance of Global.asax in ASP.NET?

243


What is an assignment?

23


The use of electricity to decompose molten sodium chloride into its component elements is an example of?

236


Is wordpress a php framework?

192


What is Flatten and what it do in PIG?

110