The plan baselines are verified with the SQL profiles.
All fixed plan baselines are converted into nonfixed plan baselines.
All the nonaccepted SQL profiles are accepted into the plan baseline.
The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
第1题:
The ASM-preferred mirror read feature is enabled.
The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
The ASM disk is dropped immediately from a disk group when it becomes unavailable.
The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
第2题:
A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
The virtual private catalog owner cannot create and modify the stored scripts.
The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
第3题:
It contains only SQL profiles generated by SQL Tuning Advisor.
It stores plans generated by the optimizer using a stored outline.
It is part of the data dictionary and stored in the SYSAUX tablespace.
It is part of the data dictionary and stored in the SYSTEM tablespace.
It contains the statement log, the plan history, plan baselines, and SQL profiles.
第4题:
Accent expansion
Canonical equivalence
Reverse secondary sorting
Ignorable characters
Character rearrangement
第5题:
Complete Recovery with online redo log
Complete Recovery with archived redo log
Tablespace Point-in-Time Recovery (TSPITR)
Incomplete Recovery with system change number (SCN)
第6题:
file striping
allocation unit mirroring
automatic disk rebalancing
automatic file size increment
automatic undo management
第7题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第8题:
Every SQL statement in the STS is considered only once for execution
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
The execution plan and execution statistics are computed for each SQL statement in the STS
The effects of DDL and DML are considered to produce the execution plan and execution statistics
第9题:
With alter database enable block change tracking
With alter system enable block change tracking
With an init.ora parameter change
With an spfile parameter change
第10题:
alter tablespace DAVE_TBS backup mode
alter tablespace DAVE_TBS start backup
alter tablespace DAVE_TBS begin backup
alter tablespace DAVE_TBS backup begin
alter tablespace DAVE_TBS backup