Quiz 1Z0-050

Quiz 1z0-050, Oracle Database 11g: New Features for Administrators

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?