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 21758

What are Clusters ?

 5 8639

what is difference between foreign key and reference key

 3 40596

what is unique key?

 14 22741

what is the difference between primary key & foreign key?

 57 122014

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 7203

structural difference between bitmap and btree index ?

 1 11304

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

 2 5709

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

 4 11464

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 3443

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

 1787

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

4 6901

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 3457

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.

 847

Explain the use of Merge statement in oracle 11g

 580

Post New Infosys Oracle General Interview Questions


Infosys Oracle General Interview Questions


Un-Answered Questions

What is the use of jsf life cycle?

74

What is assignment operator in pl sql?

549

Explain the role of Garbage collector and its generations?

506

What is decision table testing?

638

Is it good to store images in database?

538




What do you by mean by the term information collection in rpa?

1

What is the use of stripslashes in php?

525

What is boolean in c?

592

Name the different modes of recording?

547

Tell me what are your long-term goals or career plans? : insurance sales

311

what are the personel characterstics and qualities that you would bring to this position that would be paticularly helpful in fulfilling the responsibilities of this position?

1946

What makes blackberry 10 more user-friendly?

466

Mention what are different methods to trace the pl/sql code?

546

What is the best practice configuration usage for files - pom.xml or settings.xml?

121

How much of the internet does aws use?

108