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?

What will happen if the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup?

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?

Which commands are used to apply incremental backups?