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 35571

What are Clusters ?

5 10751

what is difference between foreign key and reference key

3 42135

what is unique key?

14 26488

what is the difference between primary key & foreign key?

57 135839

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 8396

structural difference between bitmap and btree index ?

1 12079

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

2 6791

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

4 13196

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 4360

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

2232

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

4 8317

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 4234

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.

1308

Explain the use of Merge statement in oracle 11g

992

Post New Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions

Infosys Oracle General Interview Questions (16)

Un-Answered Questions

What does xml-soap server includes to allow flexible services for the users?

813

What is an erlenmeyer flask?

896

protection relay watchdog contact operation?

1923

Single reduction is used in final drive when it is about a) 6:1 b) 8:1 c) 10:1 d) 12:1

1310

What are user facing features?

432

what are relationships?

1000

What are the features involved in updating a language?

832

List few advantages of stored procedure.

945

what is programmable command format (pcf) commands?

893

Describe the degree term in a tree.

919

Integrity in the project management field is accomplished through all of the following except: A. Training to learn how to manage relationships with others from different cultures B. Adhering to an ethical code C. Applying established project management processes D. Following the Project Management Professional Code of Professional Conduct

956

Difference between delete and free.

1042

What do you understand by DDL and DML statements?

890

How to executed jquery selectors? : jquery mobile

745

What are servers?

981