Which of the following are considered types of segments?

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?

What are the two main advantages of using bitmap indexes?

What does the RMAN CATALOG command do?

How is the SQL profile used?

Which commands are used to copy ASM files?

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

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

ASM disk groups provide:

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

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?