Infosys Oracle General Interview Questions Answers, Infosys Placement Papers, Infosys Technical, HR Interview Questions, Infosys Aptitude Test Questions, Infosys Campus Placements Exam Questions

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 35859

What are Clusters ?

5 11188

what is difference between foreign key and reference key

3 42456

what is unique key?

14 27287

what is the difference between primary key & foreign key?

57 139140

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 8604

structural difference between bitmap and btree index ?

1 12217

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

2 7162

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

4 13438

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 4514

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

2341

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

4 8561

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 4384

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.

1398

Explain the use of Merge statement in oracle 11g

1077

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

What is an accessor method?

What is the cause of thrashing? How does the system detect thrashing? Once it detects thrashing, what can the system do to eliminate this problem?

1485

Can AI improve weather prediction models?

What does exe mean?

999

Can I write code for android using c/c++?

1002

Tell me what is organic result?

810

How do I know if my ssd has bad sectors?

1008

i applied for c licence with my one year apperents trainee and i have attaced with A grade contractor company experiance that is for 14 monts experiance this document is sufeicant for c licence? pls tell why they rejected

2338

In which field python is used?

902

How is scrum different from iterative model?

What is ‘is-a ‘ relationship in java?

1119

Which object connects aggregates and infocube?

In which language couchdb is written?

What does django collectstatic do?

532

Australian architecture should be much the same as American architecture because they both came from British influence and were founded at about the same time. I was hoping you could give me some insight on that and tell me if I should change my hypothesis.

2489