1z1-062 無料問題集「Oracle Database 12c: Installation and Administration」

（A）Backup sets containing both data files and archive logs are created.

（B）Checks are performed for logical corruptions.

（C）Checks are performed to confirm whether all database files exist in correct locations

（D）Corrupted blocks, if any, are repaired.

（E）Checks are performed for physical corruptions.

（A）They are not affected.

（B）They are terminated after completing the transaction.

（C）They are not terminated but may only issue queries.

（D）They are terminated immediately.

（A）Missing or stale histogram statistics

（B）Undersized shared pool

（C）Oversized buffer cache

（D）High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

（E）High clustering factor for the indexes

（A）The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

（B）Only timed operating system (OS) statistics and plan execution statistics are collected.

（C）Optimizer statistics are collected automatically.

（D）Automatic Workload Repository (AWR) snapshots are not generated automatically.

（A）Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

（B）Generate Active Session History reports for the peak load period.

（C）Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

（D）Create a baseline on a pair of snapshots that span the peak load period.

（A）ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.

（B）ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

（C）ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.

（D）ORCL2 database link creation fails.

（A）a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

（B）a default database configuration

（C）a General Purpose database template with default memory allocation

（D）a Data Warehouse database template, with the dedicated server mode option and AMM enabled

（A）If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

（B）It fails because common users are unable to use the SET CONTAINER statement.

（C）It fails because local users are unable to use the SET CONTAINER statement.

（D）It succeeds because the PDB_ADMIN user has the required privileges.

（A）The predefined connect role is always automatically granted to all new users at the time of their creation.

（B）A role can be granted to other roles.

（C）The predefined resource role includes the unlimited_tablespace privilege.

（D）A role can contain both system and object privileges.

（E）All roles are owned by the sys user.

（F）A role cannot be assigned external authentication.

（A）parameter file

（B）Flashback Data Archive files

（C）online redo log files

（D）archived log files

（E）multiplexed copies of the current control file

（F）Flashback logs

（A）Dynamic Registration by the PMON process

（B）Static registration in the listener.ora file using the GLOBAL_DBNAME parameter

（C）Dynamic Registration by the LREG process

（D）Dynamic Registration by the SMON process

（E）Static registration in the listener.ora file using the SERVICE_NAME parameter

（A）a Data Warehouse database template

（B）a custom database template

（C）a file system for storage of data files

（D）Automatic Storage Management (ASM) for storage of data files

（A）The database must have multiplexed redo logs for the flashback to succeed.

（B）The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

（C）The database must be MOUNTED for the flashback to succeed.

（D）The database must be opened with the RESETLOGS option after the flashback is complete.

（E）The database must use block change tracking for the flashback to succeed.

（F）The database must be opened in restricted mode for the flashback to succeed.

（A）telnet on port 23

（B）Cloud Control on port 7799

（C）SSL/TLS on port 443

（D）SSH on port 22

（E）Enterprise Manager on port 1158

（A）A job class specifies a scheduler window that will be open when that job class becomes active.

（B）A scheduler window can control resource allocation by itself.

（C）A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.

（D）A scheduler window specifies a job class that will be activated when that scheduler window becomes active.

（E）A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.

（A）Enables the Installation of Grid Infrastructure files on block or raw devices.

（B）Automatically registers the database with Oracle Restart.

（C）Helps you to easily upgrade the database from a prior release.

（D）Effectively implements role separation

（E）Enables you to take advantage of Oracle Managed Files.