ocp-182_在线真题试卷与模拟练习_ocp-182

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Examine the description of the CUSTOMERS table: （含图） For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit.Customers whose due amount is null should not be displayed. Which query should be used?

Which two statements are true about space - saving features in an Oracle Database? 关于Oracle数据库中的节省空间功能，哪两种说法是正确的？

You currently have an active transaction in your session and have been granted select access to VSTRANSACTION. 您当前在会话中有一个活动事务，并且已被授予VSTRANSACTION的select访问权限。（含图） In which three situations will re - executing this query still return a row but with a different XID indicating a new transaction has started? 在哪三种情况下，重新执行此查询仍将返回一行，但使用不同的XID指示新事务已启动？

Which two statements are true about the PMON background process? 关于PMON后台进程，哪两种说法是正确的？

Examine the description of the BOORS TRANSACTIONS table: （含图） Which two WHERE conditions give the same result?

Which three statements are true? （含图）

Examine the description of the MEMBERs table: （含图） You want to display all cities that contain the string AN. The cities must be returned in ascending order with the last names further sorted in descending order. Which two clauses must you add to the query? 您希望显示包含字符串AN的所有城市。城市必须按升序返回，姓氏按降序进一步排序。您必须向查询中添加哪两个子句？

You want to apply the principle of Least Privilege in all your live databases. 您希望在所有实时数据库中应用最小特权原则。 One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two are types of analyses that can be done using the DBMS PRIVILEGE CAPTURE package? 您的要求之一是使用特权分析从拥有不必要特权的所有用户处撤销这些特权。哪两种类型的分析可以使用DBMS特权捕获包完成？

Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance 关于Oracle数据库实例中的撤消段和事务对撤消的使用，哪两种说法是正确的

In the PROMOTIONs table, the PROMO BEGIN DATE column is of data type DATE and the default date format is DD - MON - RR Which two statements are true about expressions using PROMO BEGIN DATE contained in a query? 在促销表中，促销开始日期列的数据类型为DATE，默认日期格式为DD-MON-RR 关于使用查询中包含的PROMO BEGIN DATE的表达式，哪两条语句是正确的？

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information? 关于Oracle数据库用于解析连接信息所支持的命名方法及其功能，哪三种说法是正确的？

Which two statements are true about Oracle synonyms? 关于Oracle同义词，哪两种说法是正确的？

Examine the description of the PRODUCT DETAILs table: （含图） Which two statements are true?

Which three statements are true about connection strings and service names used to connect to an Oracle database instance? 关于用于连接到Oracle数据库实例的连接字符串和服务名称，哪三条语句是正确的？

Which three statements are true about Deferred Segment Creation in Oracle databases? 关于oracle中的延迟段创建，哪三种说法是正确的

Which two Oracle database space management features require the use of locally managed Table spaces? 哪两种Oracle数据库空间管理功能需要使用本地管理的表空间？

Which three statements are true about data block storage in an Oracle Database? 关于Oracle数据库中的数据块存储，哪三种说法是正确的？

Which two are true about a SQL statement using SET operators such as UNION? 关于使用集合运算符（如UNION）的SQL语句，哪两个是正确的？

Which two are benefits of external tables? 哪两个是外部表的好处？

Which three statements are true regarding the UNION and UNION ALL operators? 关于UNION和UNION ALL运算符，哪三种说法是正确的？

1 2 3 4 5 6 7