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 23158

What are Clusters ?

5 9882

what is difference between foreign key and reference key

3 41528

what is unique key?

14 24978

what is the difference between primary key & foreign key?

57 130358

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 7966

structural difference between bitmap and btree index ?

1 11799

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

2 6371

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

4 12481

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 4012

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

2060

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

4 7788

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 3969

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.

1132

Explain the use of Merge statement in oracle 11g

842

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

Why macros are used in excel?

460

How to unlock the background?

How much gold is in a troy ounce?

785

If a calulator having 3 buttons (of any number)in 3 of them one is not working properly due to which answer is wrong always. write a script to find out which button is not working properly ?

1831

Is array faster than arraylist?

735

what are rollup and cube in t-sql? : Transact sql

888

What are the differences in between real dom and virtual dom?

337

How to check which add-ins are associated with a test in qtp?

877

Explain mvvm pattern?

147

How can I reduce the size of a powerpoint file online?

203

how to import data into R?

What is the use of "$?" Sign in shell script?

897

What does string intern() method do?

882

What is meaning of invoice?

977

what is office automation?

2103