Exactprep 1z0-060 Questions

Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

The C##A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

The command will create a common user whose description is contained in the root and each PDB.

The schema for the common user C # # A_ADMIN can be different in each container.

The command will create a user in the root container only because the CONTAINER clause is not used.

It executes successfully and creates an UNDO tablespace in HR_PDB.

It fails and reports an error because there can be only one UNDO tablespace in a CDB.

It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

It executes successfully but neither tablespace nor the data file is created.

It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

It fails because no SQL *Loader data file location is specified.

It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

It fails because no SQL *Loader control file location is specified.

Create a SYSMAN user with the SYSDBA role as an administrator for EM express.

Configure the DISPATCHERS initialization parameter such that at least one dispatcher is configured for the XMLDB service with the TCP protocol.

Install the Oracle HTTP Server.

Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure port number 5500 for the HTTP server.