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.

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different

locations.

Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

Examine this command:

How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

A. as SCOTT in BOSTON_DB

B. as SYS in both the databases

C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

D. as SCOTT in both the databases

E. as SCOTT in DALLAS_DB

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.

B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.

F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Examine these commands: What is the expected result?

A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

B. Only the first row in EMP.DAT is inserted into U1.EMP.

C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

Which is a machine image in Oracle Cloud?

A. the number of OCPUs and amount of memory allocated to an instance

B. the physical persistent block storage space allocated to an instance

C. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance

D. a template of a virtual hard disk of specific size without an operating system installed

E. a template of a virtual hard disk of specific size with an installed operating system