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 21769

What are Clusters ?

 5 8641

what is difference between foreign key and reference key

 3 40596

what is unique key?

 14 22745

what is the difference between primary key & foreign key?

 57 122024

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 7206

structural difference between bitmap and btree index ?

 1 11304

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

 2 5710

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

 4 11465

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 3445

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

 1789

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

4 6905

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 3461

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.

 849

Explain the use of Merge statement in oracle 11g

 582

Post New Infosys Oracle General Interview Questions


Infosys Oracle General Interview Questions


Un-Answered Questions

what is threaded joints ,where present usage ?

1602

Have you developed custom transaction software?

522

What does the statement of Inventory be used for?

616

Explain how can we detect that the other end of a tcp connection has crashed? Can we use "keepalives" for this?

747

what happen when we add mentos in cold drink?& why?

1540




salary and rent entry with tds deduct

1237

Does treemap allow null keys?

473

How automated assistant work?

36

What is the use of mrp list?

533

Where can I learn javascript?

522

What are the KPI that decides the capacity expansion of GGSN/xGW?

2448

What is the use of Callout function in SharePoint 2013?

485

What are IP protections used for electrical panels, JB, equipments installed in explosive zones like Petrochemicals, Oil & gas

1205

What is meant by a process?

133

how to carry out Magnetizing Current Test on Distribution transformer and what purpose we are doing this test. why transformer rating in always in KVA ? what ispositive, negative, zero sequence impedence? How ElCB tripping if Neutral touch with ground Why AC & DC capacitor are use in UPS ? why motor rating in KW? how to syncronize two dg sets

1705