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 21781

What are Clusters ?

 5 8651

what is difference between foreign key and reference key

 3 40609

what is unique key?

 14 22767

what is the difference between primary key & foreign key?

 57 122103

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 7218

structural difference between bitmap and btree index ?

 1 11313

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

 2 5723

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

 4 11479

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 3450

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

 1791

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

4 6915

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 3467

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.

 851

Explain the use of Merge statement in oracle 11g

 588

Post New Infosys Oracle General Interview Questions


Infosys Oracle General Interview Questions


Un-Answered Questions

What are the phases of servlet life cycle?

599

In which phases of Unified process is project deployement dealt with?

2166

What are the basic features of ms excel?

266

What is meant by Regression testing? Differentiate Sanity and Regression testing?

1834

What are the points to be considered for calculating cement reconciliation. a)Do we need to deduct the wt of cement bags b)Do we need to adjust the qty due to wt loss during transportation, loading unloading etc or else each bag can be considered as 50 kg bag c)What is the proportion of mix cover block making.

1666




What does subquery mean in sql?

530

how you can customize slide layout?

135

What is jcl in mainframe, and how many types of jcl statements are there for a job?

624

what is buy bach shares?

1617

What is the difference between while and do while loop? Explain with examples.

590

What is transient Phenomenon?

1767

Explain what are the restrictions that views have to follow? : sql server architect

462

What are the unit test considerations ?

208

Is bootstrap frontend or backend?

416

as per is code, what is the minimum content of opc and ppc cement for rcc structure

1736