The baseline, once created, cannot be removed.
Disable the baseline metrics in the Database Control Manage Metrics page.
The baseline will be automatically removed once the database performance has been optimized.
Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
第1题:
While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第2题:
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do?()
第3题:
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
第4题:
You acquire a pc with 3 hard drives: Disk 0, Disk 1, Disk 2. Each physical disk has a capacity of 6GB. You want each disk to consist of one partition. You want to configure the computer to dual-boot Win98 and Win2K PRO. You want to save your documents to Disk 1 and have the ability to access them under either OS. You also want to install Win2K PRO and have the ability to secure individual files on Disk 2.
第5题:
When a file is created in DGROUP1 with the template, it would have threeway mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have twoway mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have threeway mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have twoway mirroring but no file striping.
第6题:
Convert a disk.
Rescan the disks.
Import a foreign disk.
Attach a virtual hard disk (VHD).
第7题:
Only one channel is allocated and the backup is created in the flash recovery area
Only one channel is allocated and the backup is created in the destination specified for channel 1
Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
第8题:
The online redo log file Is not allowed to be overwritten.
The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
第9题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第10题:
A window must have been created with the WEEKEND_PLAN resource plan.
A program must have been created with the WEEKEND_PLAN resource plan.
A job class must have been created with the WEEKEND_PLAN resource plan.
A windows group must have been created with the WEEKEND_PLAN resource plan.
第11题:
Save the baseline in the database
Save the baseline in the Database Control Home Page
Create a procedure to read and apply the baseline to disk I/O metrics
Apply the baseline to the disk I/O metrics in the Mange Metrics page
Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd
第12题:
The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command,the data on that disk will be lost.
The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete,the disk will be dropped.
This command will fail because you cannot drop a specific disk in an ASM disk group.
The disk drop command will be suspended for a predetermined amount of time,waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command,ASM will proceed to rebalance the disk group and then drop the disk.
第13题:
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第14题:
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()
第15题:
You have a server named Server1 that runs a Server Core Installation of Windows Server 2012 R2. You attach a 4-TB disk to Server1. The disk is configured as an MBR disk. You need to ensure that you can create a 4-TB volume on the disk. Which Diskpart command should you use?()
第16题:
You have a server that runs Windows Server 2008. The server has the Windows Server virtualization role service installed. You need to merge a differencing disk and a parent disk. What should you do?()
第17题:
When a file is created in DGROUP1 with the template, it would have three-way mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.
第18题:
When a file is created in DGROUP1 with the template, it would have three-way mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file Striping.
第19题:
secedit
gpupdate
netdom
scwcmd
第20题:
Compute the baseline statistics.
Take an immediate AWR snapshot.
Decrease the window size for the baseline.
Decrease the expiration time for the baseline.
第21题:
A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第22题:
第23题:
Compute the baseline statistics.
Take an immediate AWR snapshot.
Decrease the window size for the baseline.
Decrease the expiration time for the baseline.