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 21795

What are Clusters ?

 5 8675

what is difference between foreign key and reference key

 3 40628

what is unique key?

 14 22791

what is the difference between primary key & foreign key?

 57 122207

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 7227

structural difference between bitmap and btree index ?

 1 11320

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

 2 5738

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

 4 11509

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 3463

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

 1800

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

4 6933

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 3481

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.

 856

Explain the use of Merge statement in oracle 11g

 592

Post New Infosys Oracle General Interview Questions


Infosys Oracle General Interview Questions


Un-Answered Questions

What's the difference in HTML AJAX, ASP.Net AJAX?

2025

Using which process does the blotting paper absorb ink?

478

Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.

1965

What is an image alt text?

430

What is the use of sample and subset functions in R programming language?

64




What is jdbc and explain jdbc architecture?

516

Should I give my ppc keywords for your pursuit?

442

Which is better stack or queue?

453

What do you understand by database triggers?

501

How to configure global security?

464

Is sql server difficult to learn?

518

Tell me when do you use property sets in siebel?

546

Do ejbs have to be homogeneously deployed across a cluster? Why?

551

What are the ways to a null pointer can use in c programming language?

588

based on the recruitment program and the expected resumption date

1215