Explain integrity constraints?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
How to Select second Maximum salary in a Table ?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
primary key is foreign key for the same table?
What are the predefined tablespaces in a database?
State some uses of redo log files?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
In Oracle 9i what does "i" Stands for?
What privilege is needed for a user to create indexes in oracle?
What is a materialised view?
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
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.