What are data pump export and import modes?
No Answer is Posted For this Question
Be the First to Post Answer
What is the recommended interval at which to run statspack snapshots, and why?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
What do you mean by merge in oracle and how can you merge two tables?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is an Extent ?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is COST-based approach to optimization ?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
What is a cluster Key ?
What is procedure overloading in oracle?