CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-071-文档1题库新特点：oracle 11g版本的ocp认证考试题库，来自cuug整理，考试题大部分都在这里能找到，如果想考ocp认证可以参考这些文档。（071-sql部分考试）下面的题是（071考试-第1个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/191.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (00DB) models?A) RDB allows the definition of relationships between different tables, whereas OODBdoes not allow this.B) OODB incorporates methods with data structure definition, whereas RDB does notallow this.C) OODB supports multiple objects in the same database, whereas RDB supports onlytables.D) RDB supports E.F. Codd's rules, whereas OODB does not support them.Answer：2.choose twoExamine the description of the EMP_DETAILS table given below:Whic two statements are true regarding SQL statements that can be executed on theEMP_DETAIL table?A) You cannot add a new column to the table with ONG as the data type.B) An EMP_IMAGE colum can be included in the GROUP BY clause.C) You can alter the table to include the NOT Nun., constraint on the EMP_IMAGEcolumn.D) An EMP_IMAGE column cannot be includ d in the ORDER BY clause.Answer:AD(解析：答案 A：SQL> alter table sales add emp_info long;alter table sales add emp_info long *第 1 行出现错误:ORA-01754: 表只能包含一个 LONG 类型的列。答案 D：SQL> select * from sales2 order by emp_image;select * from sales*第 1 行出现错误:ORA-00997: 非法使用 LONG 数据类型）3.choose threeView the Exhibit and examine the description of SALES and PROMOTIONS tables.You want to delete rows from the SALES table, where the PROMO_NAME column in thePROMOTIONS table has either blowout sale or everyday low price as values.Which three DELETE statements are valid?A) DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price');B) DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price');C) DELETEFROM salesWHERE promo_id IN SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale'OR promo_name = 'e eryday low price');D) DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN ('blowout sale','everyday lowprice');Answer：ACD4.choose the best answerView the Exhibits and examine PRODUCTS and SALES tables.You issue the following query to display product name and the number of times theproduct has been sold:SQL>SELECT p.prod_name, i.item_cntFROM (SELECT prod id, COUNT(*) item_cntFROM sales GROUP BY prod_id) i RIGHT OUTER JOIN products pON i.prod_id = p.prod_id;What happens when the above statement is executed?A) The statement executes successfully and produces the required output.B) The statement produces an error because a subquery in the FROM clause andouter-joins cannot be used together.C) The statement produces an error because ITEM_CNT cannot be displayed in the outerquery.D) The statement produces an error because the GROUP BY clause cannot be used ina subquery in the FROM clause.Answer：A（SQL> select d.dname,e.emp_cntfrom (select deptno,count(*) emp_cnt from emp group by deptno)e right outer join dept don e.deptno=d.deptno;DNAME EMP_CNT- -ACCOUNTING 2RESEARCH 4SALES 6OPERATIONSTRAIN）5.choose the best answerEvaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLNOCACHE;The sequence SEQ1 has generated numbers up to the maximum limit of 200.You issue the following SQL statement:SELECT seq1.nextval FROM dual;What is displayed by the SELECT statement?A) 1B) 100C) an errorD) 10Answer：B6. choose the best answerIn the EMPLOYEES table there are 1000 rows and employees are working in the companyfor more than 10 years.Evaluate the following SQL statement:SQL> UPDATE employeesSET salary = NVL(salary,0) + NVL(comm,0),comm = NVL(comm,0)WHERE hire_date < SYSDATE - 600;What would be the result?A) It gives an error because NVL function cannot be used with UPDATE.B) It gives an error because multiple NVL functions are used in an expression.C) It executes successfully and updates the records of those employees who have beenworking in the company for more than 600 days.D) It executes successfully but no rows updated.Answer：C（SQL> update emp2 set sal=nvl(sal,0)+nvl(comm,0),comm=nvl(com ,0)3 where hiredate < sysdate - 100;已更新 14行。）7. choose the best answerEvaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A) Any views created on the EMP table hat include the MGR_ID column would beautomatically modified and remain
