CUUG内部OCP题库解析-071-文档3
11页1、CUUG内部OCP题库解析-071-文档3题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。(071-sql部分考试)下面的题是(071考试-第3个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1918、(8-7) choose twoWhich two statements are true regarding views? (Choose two.)A) A simple view in which column aliases have been used cannot be updated.B) The OR REPLACE option is used to change the definition of an existing view without droppingand re-creating it.C) The WITH CHECK OPTION constrain
2、t can be used in a view definition to restrict the columnsdisplayed through the view.D) Rows added through a view are deleted from the table automatically when the view is dropped.E) Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.F) A subquery used in a complex view definition cannot contain group functions or joins.Answer:BE(解析:只要是简单视图,使用别名的列是可以使用 UPDATE命令更新的。WITH CHECK OPTION用于限制通过视图更改基表的条件,禁止更改不包含在子查询条件里的行。)19、(8-14) choose twoView the Exhibit and e
3、xamine the structure of the ORDERS table.The columns ORDER_MODE and ORDER_TOTAL have the default values direct and 0 respectively.Which two INSERT statements are valid? (Choose two.)A) INSERT INTO(SELECT order_id,order_date,customer_id FROM orders)VALUES (1,09-mar-2007, 101);B) INSERT INTO orders(order_id,order ate,order_mode,customer_id,order_total)VALUES(1,TO_DATE(NULL), online, 101, NULL);C) INSERT INTO ordersVALUES (1, 09-mar-2007, online,1000);D) INSERT INTO orders(order_id,order_date,order
4、_mode,order_total)VALUES (1,10-mar-2007,online,1000);E) INSERT INTO ordersVALUES (1,09-mar-2007, DEFAULT, 101, DEFAULT);Answer:AE(解析:验证过,考点是考如何插入默认值的列,实际插入过程中可以忽略列,或者用 default关键字显示插入。D语法没有错误,但是 customer_id是非空约束,所以无法插入)原来 047的考题。20、(9-1)choose the best answer:Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?A) DELETE but not TRUNCATE statement can be used to remove data from selective columns and rowsof a table.B) DELETE and TRUNCATE statements can have a rollback done
《CUUG内部OCP题库解析-071-文档3》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-071-文档3》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页