Create Database   «Prev  Next»

Create an Oracle CDB - Quiz

Oracle AI Database 26ai: five questions, one point each. Select one answer for questions 1-4 and exactly four for question 5. Multiple-answer questions receive one point only when every correct option and no incorrect option is selected.
1. After manually creating a new Oracle AI Database 26ai CDB, which supplied script is documented for building the required dictionary views and PL/SQL packages across the CDB?
Select one answer.
  A. pupbld.sql
  B. A custom script that creates the STANDARD package from scratch
  C. Only a query against USER_TABLES
  D. catcdb.sql, following the installed release instructions

2. How should undo be managed in a new Oracle AI Database 26ai CDB?
Select one answer.
  A. Create four named rollback segments and set ROLLBACK_SEGMENTS.
  B. Use automatic undo management with undo tablespaces; inspect local or shared undo configuration.
  C. Store undo in a temporary tablespace.
  D. Disable undo because redo records can replace it.

3. During manual database initialization, which script creates data dictionary views and public synonyms, including views such as USER_TABLES?
Select one answer.
  A. catproc.sql
  B. user_catalog.sql
  C. pupbld.sql
  D. catalog.sql

4. What should replace a lesson that tells Oracle AI Database 26ai administrators to run PUPBLD.SQL to enforce application data access restrictions?
Select one answer.
  A. Database-enforced least privilege using appropriate object/system privileges and roles.
  B. Re-create PRODUCT_USER_PROFILE and rely on it for every client.
  C. Give all application users the DBA role.
  D. Use SQL*Plus -RESTRICT as a substitute for database authorization.

5. Which FOUR statements correctly describe storage in a modern Oracle CDB/PDB environment?
Select exactly four answers. Credit requires all four correct choices and no extra choices.
  A. Permanent application tablespaces use data files.
  B. Every database must contain a tablespace named REPORTS.
  C. Temporary tablespaces use tempfiles for temporary work.
  D. Online redo logs are tablespaces that store table rows.
  E. PDB$SEED is the normal destination for application tables.
  F. Permanent tablespaces must use manual free-list management.
  G. Automatic undo management uses undo tablespaces.
  H. User application objects normally belong in a user PDB rather than CDB$ROOT or PDB$SEED.