1Z0-060 무료 덤프문제 온라인 액세스

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A.It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• B.It fails and reports an error because the CONTAINER=ALL clause is not used.
• C.It fails and reports an error because the CONTAINER=CURRENT clause is not used.
• D.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES',
`INT_SALES', 600);
What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

• A.All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.
• B.All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.
• C.It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.
• D.All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= `/dev/flash_device_1 `,' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A.Set DB_FLASH_CACHE_ZISE = 128G.
• B.Set DB_FLASH_CACHE_ZISE = 64G.
• C.Set DB_FLASH_CACHE_ZISE = 64G, 64G
• D.DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?

• A.The user cannot connect any database because the CONTAINER clause is missing.
• B.The user can connect only to the root database.
• C.The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.
• D.The user can connect to the root and all PDBs.

What are three purposes of the RMAN "FROM SERVICE" clause?

• A.to support active database duplication by taking image copies of the source database
• B.to support file recovery over the network in a Data Guard environment
• C.to support synchronization of a standby database with the primary database in a Data Guard environment
• D.to support file restoration over the network in a Data Guard environment
• E.to support PUSH-based active database duplication