- 博客(10)
- 收藏
- 关注
RSS订阅原创 Postgresql 下通过数据字典来查询某个表的权限
我选择通过 information_schema.table_privileges 这个视图表来查询。具体操作和结果见下图。下图是我创建了个用户user01 在 xiedb 这个库里面创建了一张表。然后基于数据字典的方式观察这个表的各种权限。
2023-04-09 12:46:53
182
1
原创 OCP 053-new-1
1. You want to convert an existing database backup into an archival backup that will always be exempt from the RMAN retention policy.Which two conditions should be met for the backup to be converted...
2019-06-13 06:11:37
210
原创 OCP 071--45
View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1in the ORDERS table.Which two...
2019-05-12 22:56:45
302
原创 OCP 1z0-071 no 199
Q199View the Exhibit and examine the structure of the ORDER_ITEMS table.Examine the following SQL statement:SELECT order_id, product_id, unit_priceFROM order_itemsWHERE unit_price =(SELECT...
2019-05-11 16:14:26
146
原创 OCP 071 -129 争议题
Q129Examine the structure of the EMPLOYEES table. (Choose the best answer.)You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and w...
2019-05-05 00:01:17
1039
原创 OCP -071 NO 126
View the Exhibit and examine the structure of the PRODUCTS table. (Choose the best answer.)You must display the category with the maximum number of items.You issue this query:SQL > SELECT C...
2019-05-04 00:13:52
122
原创 OCP 071 NO 118
View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them....
2019-05-03 22:56:01
174
原创 OCP 071 某题解析
View the Exhibit and examine the structure of the ORDER_ITEMS table.(Choose the best answer.)You must select the ORDER_ID of the order that has the highest total value among all the orders...
2019-05-03 10:48:16
568
原创 构建oracle rac 第二个节点 遇到Ora-15018和ora-15031错误。
本人还是菜鸟级。一次搭rac。 用着asmlib的方式构建。第一个节点部署比较顺利，第二个节点到最后执行root.sh 报错，截图如下输入oracleasm listdisks命令看到结果如下：检查一下状态。在这里发现问题了最后排查发现：节点2没有找到 /opt/oracle/extapi/64/asm/orcl/1/libasm.so 文件。于是从节点一把这个libasm.so 文件copy一份...
2018-07-02 09:38:47
1258
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人