搜题

【单项选择题】

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

A、A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B、B. It fails and reports an error because the CONTAINER=ALL clause is not used.

C、C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D、D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.

E、E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

查看正确答案

更多“In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）”相关的问题

第1题

[单选题] In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

A、The CDB must be open. B、The CDB must be in the mount stage. C、The CDB must be in the nomount stage. D、Alt existing PDBs must be closed.

点击查看答案

第2题

[] In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（） In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

A、A. It collects data from SGA and compares it with a preserved snapshot. B、B. It collects data from SGA, analyzes it, and provides a report. C、C. It collects data from SGA and compares it with the latest snapshot. D、D. It collects data from both SGA and PGA, analyzes it, and provides a report

点击查看答案

第3题

[] Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（） Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）

A、A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb. B、B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command. C、C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command. D、D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.

点击查看答案

第4题

[单选题] Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）

A、Place the root container in ARHCHIVELOG mode. B、Take the user data tablespace offline. C、Place the root container in the nomount stage. D、Ensure that HR_PDB is open.

点击查看答案

第5题

[多选题] Identify two correct statements about multitenant architectures.（）

A、Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration. B、Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources. C、Multiple CDBs share certain PDB resources. D、Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server. E、Patches are always applied at the CDB level. F、A PDB can have a private undo tablespace.

点击查看答案

第6题

[单选题] You completed your Java procedure for your external Java function activity, and you now want todeploy this to your server. What would you do to deploy the Java procedure?（）

A、take the Java sources (.java) files and include them in your $APPL_TOP B、take the Java sources (.java) files and include them in your CLASSPATH C、take the Java classes (.class) files and include them in your $APPL_TOP D、take the Java classes (.class) files and include them in your CLASSPATH

点击查看答案

第7题

[多选题] In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

A、The C # # ROLE1 role is created in the root database and all the PDBs. B、The C # # ROLE1 role is created only in the root database because the container clause is not used. C、Privileges are granted to the C##A_ADMIN user only in the root database. D、Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E、The statement for granting a role to a user fails because the CONTAINER clause is not used.

点击查看答案

第8题

[多选题] Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）

A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs. B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root. C、The command will, create a common user whose description is contained in the root and each pdb. D、The schema for the common user C # # A_ADMIN can be different in each container. E、The command will create a user in the root container only because the container clause is not used

点击查看答案

第9题

[单选题] The type of current which will have the greatest effect on the course made good for your vessel is（）.

A、one flowing in the same direction as your course steered B、one flowing in the opposite direction as your course steered C、one that flows at nearly right angles to your course steered D、a rotary current in which the direction of current flow constantly changes

点击查看答案

第10题

[简答题] In what sense does foreign language teaching methodology help you in your professional development?

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服