全国
Oracle认证考试
切换题库
考试题库
章节练习
[单项选择题]Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()
2024-05-17
[多项选择题]You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
2024-05-17
[多项选择题]While setting up the database for your production environment, you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective?()
2024-05-17
[单项选择题]The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()
2024-05-17
1Z0-042章节练习
2020-03-29
1Z0-042章节练习
2019-05-13
1Z0-042章节练习
2019-05-05
1Z0-042章节练习
2018-11-02
+ 点击查看更多
备考
搜题
练习
网校
登录