ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2019-02-20 15:31:30
Evaluate the following CREATE SEQUENCE statement:START WITH 100MAXVALUE 200NOCACHE;You issue the following SQL statement:What is displayed by the SELECT statement?B) 100D) 10Answer:B......【阅读全文】
发布时间:2019-02-20 13:53:12
View the Exhibit and examine the description of SALES and PROMOTIONS tables. A) DELETEWHERE promo_id = (SELECT promo_idWHERE promo_name = 'blowout sale')FROM promotions FROM salesFROM promotionsAND promo_id = (SELECT promo_idWHERE promo_name = 'eve.........【阅读全文】
发布时间:2019-02-19 11:51:23
20.choose twoExamine the description of the EMP_DETAILS table given below:Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?A) You cannot add a new column to the table with LONG as the data type.B) An EMP_IMAGE column can be included .........【阅读全文】
发布时间:2019-02-19 10:53:58
1.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (OODB) models?A) RDB allows the definition of relationships between different tables, whereas OODBdoes not allow this.B) OODB incorporates methods with data structure definit.........【阅读全文】
发布时间:2019-02-19 10:04:36
18、(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.........【阅读全文】