What do database buffers contain?
No Answer is Posted For this Question
Be the First to Post Answer
What is Index and different types of Indexes?
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.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
where we have to use ON clause and where we have to use USING clause in JOINS
What privilege is needed for a user to create views in oracle?
How many memory layers are in the shared pool?
What is save point in oracle database?
what is Table ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is it possible to insert comments into sql statements return in the data model editor ?
What is the use of file param in imp command?
What is pragma autonomous transaction in oracle?