Oracle Database 10g New Features for Administrators Set 2

What is the Character Set Scanner?

In an online transaction processing(OLTP) environment you find that the transaction tables get heavily fragmented during the week. You decide to defragment the transaction tables on every Friday at 9:30 p,m to gain performance. Which two new features of the Oracle 10G database could you use to automate this task?

Standby redo logs are used in Data Guard environments for a number of reasons. Which three statements are true regarding standby redo logs?

Which two data types can be converted to LOBs using an ALTERMODIFY command?

You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of th specified duration?

What is the result of setting the CURSOR_SHARING = SIMILAR initialization parameter?

In order to speed forign key certain, Oracle 10G will cache the first_____primary key values only where there are multirow DML statements.

Which four are true regarding the workspace Manager in Oracle 10G? (choose four)

Examine the list of variables and their data types: Name Data Type TS, TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS, IDS1 INTERVAL DAY TO SECOND Which three expressions using the new date and time data types are valid?

Which statement regarding the COMPATIABLE parameter is correct?