问题：While creating a&ensp...

Monday, September 12, 2022

问题：Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database...

Thursday, October 10, 2024

问题：Which two statements are true ab...

Friday, September 16, 2022

问题：简单介绍OEM和OMS共同点和不同点？...

Monday, September 12, 2022

问题：在设置撤消表空间的自动管理功能时，DBA通过使用相关的初始化参数对自动撤消表空间进行配置。下面的4个参数中，哪一个不是与自动撤消管理功能相关的参数？（）A、UNDO_MANAGEMENTB、UNDO_TABLESPACEC、UNDO_RETENTIOND、TRANSACTIONS...

Friday, March 22, 2024

问题：In your test d...

Friday, September 16, 2022

问题：Examine the details of the Top 5...

Friday, September 16, 2022

问题：Which three statemen...

Thursday, September 15, 2022

问题：对于以下SQL语句说法正确的是（） SELECT ename ...

Friday, September 16, 2022

问题：You notice a performance change...

Friday, September 16, 2022

问题：You execute the ...

Monday, September 12, 2022

问题：Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）A、NLS_SORT = BINARYB、NLS_SORT = BINARY_AIC、NLS_SORT = BINARY_CID、NLS_SORT = BINARY_AI_CIE、Binary sorts are case insensitive and accent ...

Monday, July 15, 2024

问题：From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries.  You would like to make su...

Saturday, October 1, 2022

问题：The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only.  What is the order of precedence？（） 1. SET within RUN  2. SET at RMAN prompt  3....

Friday, May 5, 2023

问题：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 fo...

Monday, June 3, 2024

问题：You configured automa...

Friday, September 16, 2022

问题：PL/SQL很容易检测和处理预定义和用户定义的错误条件，称为（）。A、消息B、错误C、异常D、溢出...

Wednesday, May 29, 2024

问题：Which of the following best describes a full backup? （）A、All datafiles of a database B、All datafiles, archive logs, and control files C、All datafiles and control files D、All the used blocks in a datafile...

Friday, April 11, 2025

问题：当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER...

Monday, June 3, 2024

问题：What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with t...

Friday, January 17, 2025