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 two are true about the AL32UTF8 character set? (Choose two.)

A. It is used to encode data for columns of any data type.

B. It supports multilingual databases.

C. It uses less space than other character sets, for all data types.

D. It is used to store PL/SQL source code.

E. It improves the I/O performance of a database compared to other character sets.

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

You execute this command:

Which two statements are true about the SALES tablespace? (Choose two.)

A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.

B. It is read-only by default.

C. DML operations performed on objects in this tablespace are not logged by default.

D. It uses the default blocksize used at database creation.

E. It is a locally managed tablespace.

F. It is offline by default.

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.