Study tips 1z0-050

Which two statements are true about Shared SQL Area and Private SQL Area?

Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

Which statement describes the purpose of the above password file?

Which two statements correctly describe the relation between a data file and the logical database structures?

Which data types would you use for the new column?

What will be the implications on the archiving and the location of archive redo log files?

Which two statements are true about the SALES_DATA tablespace?

Which statement describes the effect of the above command?

Which method would you use to restrict enabling of such roles?

Which two statements are true regarding undo tablespaces?