What is the difference between shrink database and shrink file?
What are the different stages in 'data warehousing'?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
What is a checkpoint in dbms and when does it occur?
What is " group by " clause?
What is database management system explain?
What is rdbms architecture?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What are the advantages and disadvantages of views in the database?
What is use of foreign key?
What is the use of PARFILE option in EXP command ?
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
Enlist ways to efficiently code transactions.