Question 111
The HR user receives the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)
Question 112
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
Question 113
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
Question 114
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?
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
Question 115
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE"
clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?
clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?
