单项选择题
Which statement describes the effect of the execution of the above PL/SQL block?（）
A. The plan baselines are verified with the SQL profiles.
B. All fixed plan baselines are converted into nonfixed plan baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
相关考题
-
单项选择题
You opened the encryption wallet and then issued the following command: Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome?（）
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option. -
单项选择题
Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）
A. The incident metadata is purged when the problem is resolved and the DBA closes the SR
B.The incident files and dumps are not retained in the ADR for the manually created incidents
C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month -
多项选择题
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）
A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
