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 17691

What are Clusters ?

 5 6115

what is difference between foreign key and reference key

 3 36358

what is unique key?

 14 17390

what is the difference between primary key & foreign key?

 57 105479




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 5756

structural difference between bitmap and btree index ?

 1 10272

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

 2 4444

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

 4 9546

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 2529

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

 1221

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

4 5098

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 2493

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.

 262

Explain the use of Merge statement in oracle 11g

 59

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions





Un-Answered Questions

Describe a couple of instances, big or small, where you took a different tack in achieving an objective than was the company standard?

2809

What are your key skills?

77

What are the default fields in Splunk?

22

Explain the zookeeper workflow?

1

Is jquery easier than javascript?

5




How to restrict null values in web report? : sap bobi

28

Where does Big Data come from?

74

What is pgadmin in postgresql?

2

when 20hp 3 phase motor start no load condition in star or delta connection.find current and write formula.(tariq)

944

What is the difference between memcache and memcached?

1

explain 3 years gap in your employ history?

1036

what is cyclon vibration effect in turbine

1051

How to assign static ip address in azure vms?

1

Why lambda forms in python do not have statements?

28

Do you have any idea about the latest crop insurance scheme for farmers?

76