CUUG内部OCP题库解析-071-文档6
10页1、CUUG内部OCP题库解析-071-文档6题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。(071-sql部分考试)下面的题是(071考试-第6个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/19QUESTION 56Which two statements are true about sequences created in a single instance database? (Choose two.)A. When the MAXVALUElimit for the sequence is reached, you can increase the MAXVALUElimit by using the ALTERSEQUENCEstatement.B. DELETE would remove a sequence from the database.C. The number
2、s generated by a sequence can be used only for one table.D. CURRVALis used to refer to the last sequence number that has been generated.E. When a database instance shuts down abnormally, the sequence numbers that have b cached but not used would be available once again when the database instance is restarted.Correct Answer: ADSection: (none)Explanationhttps:/ 57View the exhibit and examine the structure of the CUSTOMERStable.Which two tasks would require subqueries or joins to e executed in a si
3、ngle statement?A. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customersB. finding the average credit limit of male custo ers residing in Tokyoor Sydney C. listing of customers who do not have a credit limit and were born before 1980 D. finding the number of customers, in each city, whos marital status is married.E. listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city
4、 Tokyo.Correct Answer: AE 解析:select country_id,count(cust_id) select CUST_ID,CUST_FIRST_NAME,CUST_LAST_NAME from customers from customerswhere cust_credit_limit where cust_credit_limit in (select cust_credit_limit from customers where cust_city=Tokyo);(select avg(cust_credit_limit) from customers)group by country_id;QUESTION 58Which statement is true about transactions?A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transactio
《CUUG内部OCP题库解析-071-文档6》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-071-文档6》请在金锄头文库上搜索。
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页