You created a Database as a Service (DBaaS) instance. This action also created a virtual
machine and configured it for the DBaaS instance. It also created two user accounts. One
of the users is oracle.
What three functions can the oracle user perform?
A.
Grant privileges and roles to database users.
B.
Create database users.
C.
Back up and recover databases.
D.
Create tablespaces.
E.
Reboot a VM.
F.
Use thesudocommand to perform root user access operations.
Explanation:
oracle is the Oracle Database administrator account you use to access the system and
perform non-root database administration tasks. A home directory, /home/oracle, is created
forthis user. This user cannot use the sudo command to perform operations that require
root-user access. Additionally, by default you cannot connect as this user to the compute
node using SSH. You can add the public key to the user’s $HOME/.ssh/authorized_keys
file to grant persistent SSH access, or you can connect as the opc user and then use the
sudo -s command to start a root-user command shell, followed by an su – oracle command
to switch to the oracle user.
A,B,D. C is being done by “opc” user.
A,B,D.
A,B,D
A,B,D
A,B,D
– A Grant privileges and roles to database users.
– B Create database users.
-D Create tablespaces.
Backup and restore are done by the “root”user.
A,B,D. Opc creates the backups, not oracle.
I hope the real exam´s answers on Friday are not as faulty as these, or the more I study, the less chance I stand of passing… :o(
have you clear exam?
…. I thought about this one:
I think these can be the correct answers:
— Grant privileges and roles to database users.
— Create database users.
— Back up and recover databases.
…. backup and recovery database can be considered correct because you need to be the “oracle” user in order to launch the rman command prompt.
So from that perspective the “oracle” user can be used to backup/restore the database.
I just tested it on a dbaas VM of mine.
I cannot launch rman command prompt with neither root nor ‘opc’.
But I CAN with ‘oracle’.
You should create the backup with bkup_api utility using opc user: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/create-demand-backup-using-bkup_api.html
Could you create a tablespace with oracle user?
Final answer ?