CUUG内部OCP题库解析-071-文档5
6页1、CUUG内部OCP题库解析-071-文档5题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。(071-sql部分考试)下面的题是(071考试-第5个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/19QUESTION 51View the exhibit for the structure of the STUDENTand FACULTYtables. STUDENTName Null? Type- - -STUDENT_ID NOT NULL NUMBER(2) STUDENT_NAME VARCHAR2(20) FACULTY_ID VARCHAR2(2)LOCATION_ID NUMBER(2)FACULTYName Null? Type- - -FACULTY_ID NOT NULL NUMBER(2) FACULTY_NAME VARCHAR2(20)LOCATION_ID N
2、UMBER(2)You need to display the faculty name followed by the number of students handled by the faculty at the base location.Examine the following two SQL statements:Statement 1SQLSELECT faculty_name, COUNT(student_id) FROM student JOIN facultyUSING (faculty_id, location_id) GROUP BY faculty_name; Statement 2SQLSELECT faculty_name, COUNT(student_id) FROM student NATURAL JOIN facultyGROUP BY faculty_name;Which statement is true regarding the outcome?A. Only statement 2 executes successfully and gi
3、ves the required result.B. Only statement 1 executes successfully and gives the required result.C. Both statements 1 and 2 execute successfully and give different results.D. Both statements 1 and 2 execute successfully and give the same required result.Correct Answer: A Section: (none) ExplanationSELECT DNAME,COUNT(EMPNO) FROM DEPT2 NATURAL JOIN EMPGROUP BY DNAME; QUESTION 52Which statement correctly grants a system privilege? A. GRANT CREATE VIEWON table1 TO user1;B. GRANT ALTER TABLE TO PUBLIC
4、;C. GRANT CREATE TABLE TO user1, user2;D. GRANT CREATE SESSION TO ALL;Correct Answer: C Section: (none)Explanation 解析:无 ALTER TABLE 系统权限 Explanation/Reference: QUESTION 53View the exhibit and examine the structure of ORDERSand CUSTOMERS tables.ORDERS ORDERS Name Null? TypeORDER_ID NOT NULL NUMBER(4)ORDER_DATE NOT NULL DATEORDER_MODE VARCHAR2(8)CUSTOMER_ID NOT NULL NUMBER(6)ORDER_TOTAL NUMBER(8, 2)CUSTOMERSName Null? Type CUSTOMER_IDNOT NULL NUMBER(6)CUST_FIRST_NAME NOT NULL VARCHAR2(20)CUST_LAST
《CUUG内部OCP题库解析-071-文档5》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-071-文档5》请在金锄头文库上搜索。
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页