Quiz 1Z0-040

Quiz 1Z0-040 , Oracle Database 10g: New Features for Administrators

Which four are true when implementing automatic segment-space management?

An Oracle flashback view can be enabled__________.

Which statement correctly describes setup of a server-persistent parameter file (SPFILE) when used with Real Application Clusters?

What does the MERGE syntax do?

What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

In Oracle 10g, the LogMiner allows storage of a copy of the data dictionary in …..(Choose all that apply.)

Which three statements are true about the privileged connection options available in Oracle 10g?

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals?

Which constraint states are supported?

What does the Metadata Application Programming Interface (API) allow you to do?