CUUG内部OCP题库解析-053-文档4
20页1、CUUG内部OCP题库解析-053-文档4题库新特点:oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了,cuug整理了近期的053考题,并进行了讲解。下面的题是(053考试-第6个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1921.You are managing an Oracle Database 11g instance. You want to create aduplicate database for testing purpose.What are the prerequisites for performing the active database duplication?(Choose all that apply.)A. The source database backup must be copied over the net for testdatabase.B. The source database must b
2、e run in ARCHIVELOG mode if the database isopen.C. The source database must be shut down cleanly if the database is inmounted state.D. A net service name should be set up and a listener configured with thetarget as well as the source database.Answer: BCD22.An index called ORD_CUSTNAME_IX has been created on theCUSTNAME column in the ORDERS table using the following command:SQLCREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column inthe W
3、HERE clause. You want to check the impact on the performance ofthe queries if the index is not available. You do not want the index to bedropped or rebuilt to perform this test.Which is the most efficient method of performing this task?A. disabling the indexB. making the index invisible C. making the index unusableD. using the MONITORING USAGE clause for the indexAnswer: B11g版本才提供这个功能,这样索引就隐藏起来了,如果把索引隐藏 后发现有性能问题,我们可以立即打开索引:SQL alter index IDX_T1_TABLE_NAME visible;23.Which tasks can be accomplis
4、hed using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBs C. deduplication, encryption, and compression settings for all SecureFile LOBsD. deduplication, encryption, and compression settings only for SecureFile CLOBs Answer: C消除重复数据,加密,压缩适用于所有securefile LOB24.Which of the following information will be gathered by the SQL Test CaseBuilder for the problems pertaining to SQL
《CUUG内部OCP题库解析-053-文档4》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-053-文档4》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页