Oracle Interview Questions Answers, Oracle Placement Papers, Oracle Technical, HR Interview Questions, Oracle Aptitude Test Questions, Oracle 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

Oracle Interview Questions

Questions Answers Views Company eMail

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 22484

1) Difference between "Delete" and "Concatenate" with reference to databases? 2) Difference between SDLC and STLC. 3) Latest versions of the browsers used. 4) What is URL Tampering? 5) Full form of URL. I don't need the answers. These are just for reference.

2445

Could you please let me know the interfaces in OM / FA??

2266

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 4597

How do we use in the begining of any HTML page.

3 5905

What is a temp table? how to denote temp table?

4 11985

can anyone give FULL DETAILS on ATM scenarios, test cases and test cases PURPOSES

2078

what is meaning of multimedia?

16 27413

what is autonomouse transaction?

3 8228

write a script to check whether user enter a value is a leap year or not?

3 15724

What is workflow?Explain with a example?

2 9327

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3970712838_6793 by 128 in tablespace SYSAUX? What is the solution for this issue?

2 19646

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 12787

How to Select second Maximum salary in a Table ?

13 15765

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

2 5044

Post New Oracle Interview Questions

Oracle Interview Questions

Un-Answered Questions

What is sql lookup?

919

What is soil classification? : soil science

1037

What is the use of perform statement in scripts ?

1954

What is wake up sensor?

936

Is the Department making any adjustments to the standard duties tests?

Difference between top-of-page and top-of-page during at line- selection?

2342

What is the port number of telnet and dns?

1164

What is difference between singleton and single call?

1090

Describe why operational and informational systems are separate.

950

what is transistors comprised of?

1179

What is the full form of sp?

997

Explain rest in rails routes.

889

What is motion path in powerpoint?

408

1) Explain different type of Users? Explain specifically Service User? 2) Difference between System and Communication User?Explain in Context of Profile Parameter? 3) There are 5 systems say BI, SOLMAN, CRM, PI, SRM etc etc. Which system will act as a satellite system in CUA and Why? HOw CUa system works? 4) State different types of Transactions & Tables in Strutural Authorization Profile in HR Security? 5) What is L0 , L1 , L2 , L3 , L4 code called in HR Security? 6) What fields are required to create Strutural Authorization Profile in HR Security? State significance of Evaluation Path? 7) What is Structural Authorization Profile in HR Security? When required Role has already been assigned to User then why Structural Authorization Profile is required by user? 8) How are structural Authorization Profile are created? 9) Important Authorization Object in HR Security? 10) Fields in P_ORGIN A.O? 11) Important infotypes and What is PA? 12) How access is provided for tables to user? Significance of Authorization Group in TDDAT table? 13) Difference between SU22 and SU24? 14) Explain Authorization Structure? 15) Which table stores the Authorization Object of a User? 16) What we do to keep Roles consistent in DEV QAS and PRD? 17) A User has create and display access? Will he have access to change as well? 18) How User can have access to view salary slip of other employees(HR Security)?Explain in detail. 19) In HR security does we add Employee ID anywhere in Roles? 20) Any issue you have faced while Transport? 21) Have you faced any issue in Upgrade? Expalain how to compare Roles from older version of SAP to new version of SAP? 22) Any typical issue you have resolved in HR Security?

5055

Differentiate between stress and strain.

1032