Evaluate the following SQL:
CREATE USER sam IDENTIFIED BY sam;
GRANT
CREATE ANY MATERIALIZED VIEW,
CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE
TO dw_manager
WITH ADMIN OPTION;
GRANT dw_manager TO sam WITH ADMIN OPTION;
Which of the following actions is the user SAM able to perform?

Where can you find the non-default parameters when the instance is started?

ASM disk groups provide:

Which one helps you identify your statement in the DBA_TUNE_MVIEW view?

Where is the trace file generated when a deadlock shutdown is detected by Oracle?

In Oracle 10g, what is the default value for the initialization parameter 'RESUMABLE_TIMEOUT'?

How is the SQL profile used?

What does the RMAN CATALOG command do?

What are the two main advantages of using bitmap indexes?

Examine the following SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

Which ones are considered types of segments?