Post New Answer View All Answers
How to build data dictionary view an new database?
State the difference between a primary key and foreign key?
How to resolve the ORA-39133 error in Oracle?
Explain how you would restore a database using RMAN to Point in Time?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are the various constraints used in oracle?
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.
What is a table index in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is translate in oracle?
How to omit columns with default values in insert statement in oracle?
How to select all columns of all rows from a table in oracle?
Can we store pictures in the database and if so, how it can be done?
What is PL/SQL ?