2017年11月30日
052-2
摘要： 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 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)
052-1
摘要： 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 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
051-174
摘要： 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 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
Oracle中的Exists、In、ANY、ALL
摘要： Exists：子查询至少返回一行时条件为true。 Not Exists：子查询不返回任何一行时条件为true。 In：与子查询返回结果集中某个值相等。-- in null不会显示为null的值，因为null是未知的所以不会有=null，要查询为null的请用is null Not In：与子查询返 阅读全文
posted @ 2017-11-30 15:37 巴啦啦大魔王 阅读(309) 评论(0) 推荐(0)
051-144
摘要： 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 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
051-139
摘要： 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 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
051-133
摘要： 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 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)