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 35501

What are Clusters ?

5 10655

what is difference between foreign key and reference key

3 42053

what is unique key?

14 26328

what is the difference between primary key & foreign key?

57 135036

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 8342

structural difference between bitmap and btree index ?

1 12046

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

2 6687

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

4 13120

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 4311

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

2208

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

4 8232

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 4202

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.

1288

Explain the use of Merge statement in oracle 11g

974

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

Explain Inheritance concept in the Pega (rules, class)?

531

Why div is used in html?

746

How to test data loading in data base testing?

449

What is high level language in computer?

966

What is persistence layer?

Which language is java?

918

What is ad hoc analysis?

120

Difference b/w SCSI AND IDE

2018

What is a deferred tax asset?

526

Is excel the best spreadsheet?

617

Which access specifier can be used with class ?

943

Do de-activated plugins slow down a WordPress site?

165

Hi Friends, I wish to start my career in manual Testing as I believe I am ready to face Interviews.I have good domain knowledge in banking(investment and retail) and insurance.To be in the competition I have added three years of testing experience to my CV apart from my domain experience. Can someone please advice some real time tips which can help in facing the interview. Thanks in advance

2051

How can one access the web service class method via internet?

671

How does the bre work with the co>operating system?

1022