没有合适的资源?快使用搜索试试~ 我知道了~
OCP考试资料-OCP-19c-082.docx
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 4 下载量 89 浏览量
2023-10-15
10:24:28
上传
评论 1
收藏 3.4MB DOCX 举报
温馨提示
试读
74页
OCP考试资料_OCP_19c_082 内容丰富 内容新
资源推荐
资源详情
资源评论
**1. Which two statements are true about space-saving features in an Oracle
Database? 关于Oracle数据库中节省空间的功能,哪两种说法是正确的?
A.An index created with the UNUSABLE attribute has no segment.
使用UNUSABLE属性创建的索引没有分段。
B.Private Temporary Tables(PTTs)store metadata in memory only.
专用临时表(PTT)仅将元数据存储在内存中。
C.Private Temporary Tables(PTTs) when used, are always dropped at the next
commit statement.
D.An index that is altered to be UNUSABLE will retain its segment
E. A table that is truncated will always have all of its extents removed
被截断的表将始终删除其所有扩展数据块。------会保留一个
答案:AB
2. Which two statements are true about views?
A.A view must only refer to tables in its defining query.
B.The WITH CHECK clause prevents certain rows from being displayed when
querying the view
C.Views can be updated without the need to re-grant privileges on the view
无需重新授予视图的权限即可更新视图
D.The WITH CHECK clause prevents certain rows from being updated or inserted
in the underlying table through the view.
WITH CHECK子句防止某些行通过视图更新或插入到基础表中。
E.Views can be indexed
答案:CD
3. Examine the description of the products table
A.SELECT prod id, AVG(MAX (cost)) FROM products GROUP BY prod.
B.SELECT prod id, MAX (AVG (cost)) FROM products GROUP BY prod id:
C.Select prod id, release date, SUM(cost) FROM products GROUP BY prod id
D.SELECT prod id, release date, SUM(cost) FROM products GROUP BY prod id,
release date
答案:D
4. You currently have an active transaction in your session and have been
granted select access to V$TRANSACTION
您当前在会话中有一个活动事务,并且已被授予选择访问权限
A.after successfully executing a TRUNCATE statement followed by a DML
statement。在成功执行TRUNCATE语句后,再执行DML语句。(TRUNCATE隐式提
交,然后DML接着产生了一个事务 )
B.after successfully executing a CREATE TABLE AS Select statement followed by a
SELECT FOR UPDATE statement。在成功执行CREATE TABLE AS Select语句后,再执
行Select FOR UPDATE语句。(CREATE隐式提交,然后for update会产生一个事务)
C.after successfully executing a CREATE TABLE statement followed by a CREATE
INDEX statement
D.after successfully executing a commit or ROLLBACK followed by a DML
statement。在成功执行commit或rollback后,再执行DML语句。(提交或者回滚,事务
结束,再进行DML,产生一个事务)
E.after successfully executing a DML statement following a failed DML statement
F. after successfully executing a commit or ROLLBACK followed by a Select
statement
答案:ABD
*5、Which two statements are true about the PMON background process?
A.It rolls back transactions when a process fails。当进程失败时,它会回滚事务
B.It registers database services with all local and remote listeners known to the
database instance
C.It frees unused temporary segments
D.It frees resources held by abnormally terminated processes。它释放了异常终止的
进程所拥有的资源
E.It records checkpoint information in the control file
答案:AD
6. Examine the description of the BOORS TRANSACTIONS table:
Which two WHERE conditions give the same result?
A.WHERE borrowed date= SYSDATE AND (transaction_ type ='RM' AND
(member_id 'A101' OR member id ='A102' ))
B.WHERE borrowed date= SYSDATE AND (transaction type='RM' OR member id
IN ('A101', 'A102'))
C.WHERE borrowed date= SYSDATE AND (transaction type ='RM' AND
member_id 'A101' OR member id ='A102')
D.WHERE borrowed date= SYSDATE AND transaction type ='RM' OR member id
IN('A101', 'A102')
E.WHERE (borrowed date= SYSDATE AND transaction type ='RM') OR member id
IN A101','A102’)
答案:DE
**7. Which three statements are true?
A. The second ROLLBACK command restores the row that was inserted
B.The first ROLLBACK command leaves the inserted row locked
C.The second ROLLBACK command restores the 100 rows that were in the table
originally:第二个ROLLBACK命令恢复表中原来的100行
D.The second ROLLBACK command rolls back the ROLLBACK TO SAVEPOINT a
command
E.The first ROLLBACK command leaves the table's 100 original rows locked:第一
个ROLLBACK命令使表的100个原始行处于锁定状态
F.The first ROLLBACK command restores the 100 rows that were in the table
originally 第一个ROLLBACK命令恢复表中最初的100行
答案:CEF
*8. Which is the default column or columns for sorting output from
compound queries using SET operators such as INTERSECT in a SQL
statement? 在SQL语句中,使用SET运算符(如INTERSECT)对复合查询的输出进行排
序的默认列是哪一列?
A.the first NUMBER or VARCHAR2 column in the last select of the compound
剩余73页未读,继续阅读
资源评论
- Kyrie的碎碎念2024-01-23资源质量不错,和资源描述一致,内容详细,对我很有用。
- qq_422758862024-02-05资源不错,内容挺好的,有一定的使用价值,值得借鉴,感谢分享。
- ly壹亿壹壹2024-03-21资源有一定的参考价值,与资源描述一致,很实用,能够借鉴的部分挺多的,值得下载。
- Carlsonshi05272024-04-14终于找到了超赞的宝藏资源,果断冲冲冲,支持!
优质网络系统领域创作者
- 粉丝: 2965
- 资源: 2397
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功