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 17191

What are Clusters ?

 5 5856

what is difference between foreign key and reference key

 3 35689

what is unique key?

 14 16930

what is the difference between primary key & foreign key?

 57 104211




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 5640

structural difference between bitmap and btree index ?

 1 10131

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

 2 4320

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

 4 9364

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 2441

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

 1166

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

4 4999

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 2404

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.

 221

Explain the use of Merge statement in oracle 11g

 9

Post New Infosys Oracle General Interview Questions




Infosys Oracle General Interview Questions





Un-Answered Questions

sir please send me d previous paper of jindal steel power corporatio ltd.. mah email id z khan.aalmeen@gmail.com

1286

If u maintain sub-contacting where and how will be reflect

1103

What are the different installation options available for SAP PI system?

1

How do we go with database connection and log4j integration in servlet?

13

Which is more beneficial: Stateful or Stateless Bean?

12




Explain how to mine an olap cube?

1

Compare the features of AngularJS and jQuery?

530

AE datasets names? how many types?

1444

How many types of vat categoryplease tell me all type of vat categories..............

1151

what is there inside an inverter and how it works?

594

7. (a) How do you implement internal controls in IT systems? (b) How to design internal controls over financial reporting, when financial reporting is performed totally from the software application? Explain briefly the major points. (c) What are the additional controls needed, when the software interfaces are webbased? Explain the materiality of the payroll processing functions to be performed by webinterfaces from the control perspective.

1214

What is the chemical composition of FCVS350 ?

2481

How generating electric power export to grid from the generating station ?

715

Every One is saying that Documentation is very very importent in Tester's Life.Could any one explain with proper examples..?

1098

what is the purpose of the verify function of idcams?

10