Ceritified Information
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.Examine the command:RMAN> LI5T FAILURE;Which statement is true about this command?In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multil container database … Read more
You notice that the performance of your production 24Ãâ€â€7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.How can you detect the cause of the degraded performance? Question: How can you detect the cause of the degraded performance? Options: by performing emergency monitoring using … Read more
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.You have set the db_smart_flash_file parameter_DB_FLASH_CACHE_FILE= ‘ /dev/flash_device_1′,’/dev/flash_device_2’Flow should the D3_flash_cache_size be configured to use both devices?* Smart Flash Cache concept is not new in Oracle 12C – DB Smart Flash … Read more
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.Examine the steps to recover the database:1 .Restore the control files by using the RMAN restore controlfile … Read more
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:1.Make the tablespace read-only at the source database.2.Export metadata from the source database.3.Import metadata into the target database,4.Transfer the dump file and data files to the target machine.5.Convert data files by using Recovery … Read more
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.What is the easiest way to perform capacity planning for consolidation? Question: What is the … Read more
LDAP_DIRECTORY_SYSAUTH is set to YES.Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID). SSL has been configure for the database and OLD and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:$sqlplusscott/[email protected] As sysdba where DB01 is … Read more
You execute the RMAN commands:RMAN> BACKUP VALIDATE DATABASE;RMAN> RECOVER CORRUPTION LIST;Which task is performed by these commands? Question: Which task is performed by these commands? Options: Corrupted blocks, if any, are repaired in the backup created. Only those data files that have corrupted blocks are backed up. Corrupted blocks in the data files are checked … Read more
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.The statistics_level parameter is PDB modifiable.As the user sys, execute the following command on pdb2:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID=’*’ SCOPE=SPFILE;Which statement is true about the result … Read more
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation? Question: Which statement is true about this backup operation? Options: The backup must be performed in mount state. The tablespace must be taken offline. All files must be backed up as backup … Read more