Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open.
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
Which three RMAN persistent settings can be set for a database?
A. backup retention policy
B. default backup device type
C. default section size for backups
D. default destinations for backups
E. multiple backup device types for a single backup
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
A. image copy backup by using RMAN
B. multisection image copy backup by using RMAN
C. multisection parallel backup by using RMAN
D. cold backup after taking the tablespace offline
E. cold backup after placing the tablespace in backup mode
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1.
Create a policy to capture the privileges used by a user for privilege analysis.
2.
Generate a report with the data captured for a specified privilege capture.
3.
Start analyzing the data captured by the policy.
4.
Revoke the unused privileges.
5.
Compare the used and unused privileges' lists.
6.
Stop analyzing the data.
Identify the correct sequence of steps.
A. 1, 3, 5, 6, 2, 4
B. 1, 3, 6, 2, 5, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 5, 2, 6, 4
Your database is running in archive log mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?
A. Enable minimal supplemental logging.
B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
C. Enable the recyclebin.
D. Enable undo retention guarantee.
E. Enable Fast Recovery Area.
You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?
A. Use job classes.
B. Use scheduler windows.
C. Use the mapping rule for the consumer groups.
D. Set the switch_time plan directive for both plans.
E. Use scheduler schedules.
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:
SQL> GRANT create tablespace to C##A_ADMIN;
Which statement is true? (Choose the best answer.)
A. The command fails because the CONTAINER clause is not used.
B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).
D. The command fails because system privileges cannot be granted to a common user.
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the
users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
'/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?
A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
Which three statements are true about transportable databases? (Choose three.)
A. The transported database must have the same database identifier (DBID) as the source database
B. Recovery Manager (RMAN) is used to convert the necessary data files of a database if the endian format of the target platform is different
C. The COMPATIBLE parameter must be set to 10.0.0 or higher and the database must be opened in read-only mode before being transported
D. Redo logs and control files are also transported
E. Both the source and target databases must use the same character set
