1z0-043单项选择题每日一练(2019.01.08)

单项选择题
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）
A. Disable SQL tracing for the APPS tablespace.
B. Disable logging attributes for the APPS tablespace.
C. Modify the tablespace to be a dictionary-managed tablespace.
D. Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
E. Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
单项选择题
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database： RMAN> REPORT NEED BACKUP days 3; What would be the output of this command？（）
A.a list of files that require a backup within three days
B.a list of files that have not been backed up for three days
C.a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D.a list of files for which a backup has already been performed and may need a backup after three days
单项选择题
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？（）
A. You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B. You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C. You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D. You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
单项选择题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
A. Only the Flashback Table
B. Both the Flashback Transaction Query and the Flashback Version Query
C. Only the Flashback Drop
D. Only the Flashback Version
单项选择题
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
A. DBWn
B. RECO
C. RVWR
D. LGWR