Difference between varchar and varchar2 data types?
What privilege is needed for a user to create tables in oracle?
What is a system tablespace?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is an oracle recycle bin?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain the use of rows option in imp command.
Compare and contrast between sql and sql server and explain its various functions?
Is oracle the best database?
How do I connect to oracle?
Is oracle a programming language?
What are the benefits of ordbms?
What is tns service name?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?