没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
考试科目: 1Z0 - 082
考试题量: 90
通过分数: 60%
Q1. 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.
B.Private Temporary Tables(PTTs)store metadata in memory only.
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
A.使用不可用属性创建的索引没有段。
B.专用临时表(PTT)仅在内存中存储元数据。
C.使用私有临时表(PTT)时,总是在下一个 commit 语句中删除。
D.被修改为不可用的索引将保留其段
E.被截断的表将始终删除其所有扩展数据块
Answer:AB
Q2. 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.
E.Views can be indexed
A.视图只能在其定义查询中引用表。
B.WITH CHECK 子句防止在查询视图时显示某些行
C.视图可以更新,而无需重新授予视图权限
D.WITH CHECK 子句防止某些行通过视图更新或插入到基础表中。
E.视图可以被索引
Answer:CD
Q3. Examine the description of the products table
检查 products 表的说明
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
Answer:D --最长的 group by 后带 DATE
Q4. 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 指示新事务已启动?
A.after successfully executing a TRUNCATE statement followed by a DML statement
B.after successfully executing a CREATE TABLE AS Select statement followed by a SELECT FOR
UPDATE statement
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
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
Answer:ABD
Q5. Which two statements are true about the PMON background process?
关于 PMON 后台进程,哪两种说法是正确的?
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
A.当流程失败时,它回滚事务
它向数据库实例已知的所有本地和远程侦听器注册数据库服务
C.释放未使用的临时段
它释放异常终止的进程所持有的资源
E.在控制文件中记录检查点信息
Answer:AD-- rolls processes
Q6. 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','A1021)
Answer:DE D 没有多余() E 开始就有()
Q8. Which is the default column or columns for sorting output from compound queries
using SET operators such as INTERSECT in a SQL statement?
使用集合运算符(如 SQL 语句中的 INTERSECT)对复合查询的输出进行排序时,默认列是
哪列?
A.the first NUMBER or VARCHAR2 column in the last select of the compound query
B.the first NUMBER column in the first select of the compound query
C.the first vARCHAR2 column in the first select of the compound query
D.the first column in the first select of the compound query
A.复合查询最后一个 select 中的第一个数字或 VARCHAR2 列
B.复合查询的第一个 select 中的第一个数字列
C.复合查询的第一个 select 中的第一个 vARCHAR2 列
D.复合查询的第一个 select 中的第一列
E.复合查询最后选择的第一列
Answer:D
Q9. 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 的所有城市。城市必须按升序返回,姓氏按降序进一步排序。您
必须向查询中添加哪两个子句?
A.ORDER BY 1, LNAME DESC
B.ORDER BY1, 2
C.WHERE city IN (‘%AN%’)
D.WHERE city= ‘%AN%’
E.WHERE city LIKE ‘%AN%’
F.ORDER BY last name DESC, city ASC
Answer:AE like 用法 排除 C D 城市先升序排除 F
Q10. 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 特权捕获包完成?
A.analysis of privileges that a user has on other schema's objects
B.analysis of privileges that a user has on their own schema objects
C.analysis of privileges granted indirectly to a role that are then used by a user who has been
granted that role
D.analysis of privileges granted directly to a role that are then used by a user who has been
granted that role
E.analysis of all privileges used by the sys user
A.分析用户对其他架构对象的权限
B.分析用户对自己的模式对象拥有的权限
C.分析间接授予某个角色的权限,该权限随后由授予该角色的用户使用
D.分析直接授予某个角色的权限,该权限随后由授予该角色的用户使用
E.分析 sys 用户使用的所有权限
Answer: AC
Q18. Which three statements are true about roles?
A) Roles may be granted to roles.
B) The SET ROLE statement can enable one or more roles for a session.
C) All roles granted to a user are set on by default when the user logs in.
D) Roles must be password protected.
E) The SET ROLE statement can disable one or more roles for a session.
F) Object privileges may not be granted to roles.
A) 可以将角色授予角色。
B) SETROLE 语句可以为会话启用一个或多个角色。
C) 默认情况下,当用户登录时,将启用授予用户的所有角色。
D) 角色必须受密码保护。
E) SET ROLE 语句可以为会话禁用一个或多个角色。
F) 对象权限不能授予角色。
Answer:ABE
Q20. Which two statements are true about undo segments and the use of undo by
transactions in an Oracle database instance
关于 Oracle 数据库实例中的撤消段和事务对撤消的使用,哪两种说法是正确的
A.A single transaction may use multiple undo segments simultaneously.
B.Undo segments can be stored in the SYSAUX tablespace
C.Undo segments can extend when a transaction fills the last extent of the undo segment
D.Undo segments can wrap around to the first extent when a transaction fills the last extend
of the undo segment
E.Undo segments can be stored in the SYSTEM tablespace
A.单个事务可以同时使用多个撤消段。``
B.撤消段可以存储在 SYSAUX 表空间中
C.当事务填充撤消段的最后一个区段时,撤消段可以扩展
D.当事务填充撤消段的最后一个扩展段时,撤消段可以环绕到第一个扩展段
E.撤消段可以存储在系统表空间中
剩余37页未读,继续阅读
资源评论
sc2413
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功