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 35728

What are Clusters ?

5 10970

what is difference between foreign key and reference key

3 42290

what is unique key?

14 26902

what is the difference between primary key & foreign key?

57 137470

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 8486

structural difference between bitmap and btree index ?

1 12143

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

2 6952

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

4 13325

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 4449

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

2278

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

4 8444

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 4300

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.

1352

Explain the use of Merge statement in oracle 11g

1029

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

Is powershell a bash?

1085

Can we get price for the products by maintaining condition types in crm without connecting to ipc?

961

What are the two kinds of properties in c#.

948

What are the different table types that are supported by teradata?

1003

What are the layers & masks in photoshop?

Can comments be nested?

1036

Can I uninstall visual c++?

1040

Can we rename a column in the output of sql query?

995

What are the types of keyfigure aggregation in terms of characteristics/calc type?

836

What are hydrides of boron called?

1016

State about the security aspects of stored procedures?

977

What is a db2 cursor?

1063

how to find that tools work well with your existing system?

1870

How to force my .net app to run as administrator on windows 7?

979

What r the features,u take care in prototype testing?

2225