How does the CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb_admin IDENTIFIED BY password; statement function?

• A. It creates a new root container with the name pdb1
• B. It generates only metadata for pdb1 without any datafiles
• C. It converts the current root database into a PDB named pdb1
• D. It clones the seed database to create pdb1 with its own administrative user

How does Flashback Table differ from Flashback Database in terms of scope and impact?

• A. Flashback Table reverts the entire database; Flashback Database affects a specific table
• B. Flashback Table operates at the object level; Flashback Database rewinds the entire database instance
• C. Flashback Table disables redo log application; Flashback Database enforces redo consistency
• D. Flashback Table requires archive logs; Flashback Database uses only undo data

What advantage does Flashback Database provide over traditional point-in-time recovery?

• A. It eliminates the need for any redo logs
• B. It allows rewinding the entire database quickly using flashback logs instead of restoring backups
• C. It creates guaranteed restore points automatically for every transaction
• D. It replaces undo segments with archived redo

When applying quarterly Release Update (RU) patches, what is considered best practice?

• A. Disable database auditing during patching
• B. Use a staging environment to validate the patch first
• C. Avoid backing up the Oracle home before patching
• D. Apply directly to production without testing

What is the effect of issuing ALTER PLUGGABLE DATABASE ALL OPEN READ ONLY;?

• A. All PDBs in the CDB are opened in READ WRITE mode
• B. All user-created PDBs except PDB$SEED open in read-only mode
• C. Only PDB$SEED opens, as it is the default template PDB
• D. The command fails because PDB$SEED cannot change open mode