Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

A. It can be granted to any user and any role.

B. It is overridden by any specified user space quota.

C. It allows a user to have unlimited space in any tablespace in the database.

D. It allows a user to have unlimited space only in his or her default permanent tablespace.

E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. control files

B. bad files

C. input files

D. password files

E. server parameter files (SPFILE)

F. dump files

A user complains about poor database performance. You suspect that the user's session is losing time waiting for events to complete.

You want to verify this.

Which view reveals on what events a session has spent time waiting in the past?

A. V$SESSION_WAIT_CLASS

B. V$SYSTEM_EVENT

C. V$SESSION

D. V$SESSION_EVENT

E. V$SESSION_WAIT

Which is always true about privileges?

A. Connections as SYSTEM can use only the SYSOPER privilege.

B. Connections as SYS must be made using the SYSDBA privilege

C. System privileges can be granted only to users.

D. The owner of a schema is granted all object privileges within the schema by default.

E. The SYSDBA privilege can be granted to a user or role.

Which statement is true about database links?

A. Private database link creation requires the same user to exist in both the local and the remote database.

B. A database link can be created only between Oracle databases.

C. A public database link can be used by a user in the local database to connect to any schema in the remote database.

D. A database link created in a database allows a connection from that database instance to another, but not vice versa.

E. A public database link can be created only by SYS.