You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM
$ srvctl stop service –db CDB1 –service CRM
Which three statements are true?
A.
CRM is only available for new logins on the CDB1 instance on host01.
B.
CRM is available for new logins on one CDB1 instance.
C.
The srvctl start service command automatically opens PDB_1 if not already opened.
D.
The srvctl stop service command does not close PDB_1 on any instance of CDB1.
E.
The CRM service is not available for new logins on any instance of CDB1.
Explanation:
C, D and E
D is correct
srvctl stop service -db raccont -service plug
The PDB spark remains open until you close the PDB using the SQL command ALTER PLUGGABLE DATABASE PDB_NAME CLOSE IMMEDIATE;. You can check the status of the database using the srvctl status service command.
https://docs.oracle.com/database/121/RACAD/admin.htm#RACAD8913
A is wrong
CDB1 is database not instance.
C,D,E
C Correct
If you start a service, the PDB is started too if it’s not open.
D Correct
If you stop a service, It doesnt mean you are closing PDB. That PDB could have more services running on it.
E Correct
If you execute the last command: srvctl stop service wil not be available for new logins
B correct : because cardinality is singleton
C correct : when service is stardted then pdb is opened
D is correct :
B correct : because cardinality is singleton
C correct : when service is started then pdb is opened
D is correct :