Oracle
What is oracle rowcount?
How to execute a stored procedure in oracle?
What happens if you set the sga too low in oracle?
What are a query and state the different types of queries and their uses?
26. Display the earliest shipping date in the format: DD/MON/YYYY
what are the default admin accounts in Oracle 10g ?
what are the things that you consider while creating indexes on partitioning tables?
How to omit columns with default values in insert statement 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 ASM (Automatic Storage Management) in Oracle?
Explain the use of analyse option in exp command.
Draw E-R diagram for many to many relationship ?