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 35551

What are Clusters ?

5 10726

what is difference between foreign key and reference key

3 42113

what is unique key?

14 26444

what is the difference between primary key & foreign key?

57 135628

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 8376

structural difference between bitmap and btree index ?

1 12071

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

2 6763

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

4 13171

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 4349

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

2223

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

4 8285

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 4223

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.

1301

Explain the use of Merge statement in oracle 11g

986

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

What is etl - extraction, transformation, and loading?

868

What is online banking?

1085

You are working on a project that was proceeding well until a manufacturing glitch occurred that requires corrective action. It turns out the glitch was an unintentional enhancement to the product, and the marketing people are absolutely crazy about its potential. The corrective action is canceled, and you continue to produce the product with the newly discovered enhancement. As the project manager, you know that a change has occurred to the project scope. Which of the following is true? A. Project scope changes do not require CCB approval. B. Performance measurement baselines are affected by scope changes. C. Project scope change uses inspection to determine if change has occurred. D. Project scope change uses workarounds to correct unexpected problems with scope change.

1102

What is the difference between symbol and string?

945

What are the advantages of inheritance in c++?

1062

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2031

How to restrict billing information to AR?

1447

Explain what is cells in openstack?

276

What is scope resolution operator in c++ with example?

1002

What are the types of subquery?

996

What is qualifications subprofile?

955

When to use Single, SingleOrDefault, First and FirstOrDefault?

112

could i know the selection pattern at hpcl, am an undergradute in chemical technology, but my sujects or course do not figure out antwhere on the lists.

1874

What is a stl vector?

1178

Which cable is use for rtcc control panel

1733