How many types of dimensions in oracle?

528

How to omit columns with default values in insert statement in oracle?

1008

What skills should a dba have?

529

When should an artificial (or derived) primary key be used?

550

Can we invoke one form from another in a multi-forms application?

1085

What are the types of profiles in ODI?

559

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2028

What is the difference between truncate and delete? Why is one faster?

601

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

570

if some data is not transfered where it will get stored

1890

What is blob datatype?

1063

What is catalog in Oracle?

1285

How to create a new table in your schema?

1042

How can you find all the processes on your system?

529

Please explain drop constraint oracle?

1032