摘要: Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A. All AWR tables belong to the SYSTEM schemaB. The AWR cont 阅读全文
posted @ 2017-11-30 18:27 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0) 编辑
摘要: View the Exhibit and examine the attributes of an undo tablespace.In an OLTP system, the user SCOTT has started a query on a large table in the peak t 阅读全文
posted @ 2017-11-30 18:07 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0) 编辑
摘要: Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A part 阅读全文
posted @ 2017-11-30 17:48 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0) 编辑
摘要: Exists:子查询至少返回一行时条件为true。 Not Exists:子查询不返回任何一行时条件为true。 In:与子查询返回结果集中某个值相等。-- in null不会显示为null的值,因为null是未知的所以不会有=null,要查询为null的请用is null Not In:与子查询返 阅读全文
posted @ 2017-11-30 15:37 巴啦啦大魔王 阅读(289) 评论(0) 推荐(0) 编辑
摘要: View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the follo 阅读全文
posted @ 2017-11-30 14:35 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0) 编辑
摘要: Which three statements are true about multiple-row subqueries? (Choose three.)A. They can contain a subquery within a subquery.B. They can return mult 阅读全文
posted @ 2017-11-30 14:11 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0) 编辑
摘要: Which two statements are true regarding subqueries? (Choose two.)(关于子查询哪两句话是正确的?)A. A subquery can retrieve zero or more rows.(子查询能检索 0 行或多行)B. Only t 阅读全文
posted @ 2017-11-30 13:38 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0) 编辑