当前位置: gbaiyou-> 071题库
165
164

新闻中心

  • 【第10题】OCP认证071近期出现的考试题库分享2019-05-21
  • 10.choose the best answer Evaluate the following SQL statement: SQL SELECT promo_id, promo_category FROM promotions WHERE promo_category = 'Internet' ORDER BY 2 DESC UNION SELECT promo_id, promo_category FROM promotions WHERE promo_category = 'TV' UNION SELECT promo_id, promo_category FROM promotions WHERE promo_category ='Radio'; Which statement is true regarding the outcome of the ........详情
  • 【第9题】OCP认证071近期出现的考试题库分享2019-05-21
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------9.choose twoThe SQL statements executed in a user session are as follows:SQL> CREATE TABLE product(pcode NUMBER(2),pname VARCHAR2(10));SQL> INSERT INTO product VALUES (1, 'pen');S........详情
  • 【第8题】OCP认证071近期出现的考试题库分享2019-05-21
  • 8.choose two Examine the structure of the PRODUCTS table. Which two statements are true? A) EXPIRY_DATE always stores date and time in character format B) PRICE can store a maximum of eight digits and two decimals. C) PRODUCT_PIC can store only videos. D) PRODUCT_NAME always stores the exact number of characters including spaces entered for each row. E) PRODUCT_TYPE always stores two byt........详情
  • 【第7题】OCP认证071近期出现的考试题库分享2019-05-21
  • 7. choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement? A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain valid. B) Any constraints defined on the MGR_ID column would be removed by the above command. C) Any sy........详情
  • 【第6题】OCP认证071近期出现的考试题库分享2019-05-21
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------6. choose the best answerIn the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.Evaluate the following SQL statement:SQL> UPDATE e........详情
  • 【第5题】OCP认证071近期出现的考试题库分享2019-05-21
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------5.choose the best answerEvaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLENOCACHE;The sequence SEQ1 has generated number........详情
  • 【第4题】OCP认证071近期出现的考试题库分享2019-05-21
  • 4.choose the best answer View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the number of times the product has been sold: SQLSELECT p.prod_name, i.item_cnt FROM (SELECT prod id, COUNT(*) item_cnt FROM sales GROUP BY prod_id) i RIGHT OUTER JOIN products p ON i.prod_id = p.prod_id; .....详情
  • 【第3题】OCP认证071近期出现的考试题库分享2019-05-21
  • 3.choose three View 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 the PROMOTIONS table has either blowout sale or everyday low price as values. Which three DELETE statements are valid? A) DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sa........详情
  • 【第2题】OCP认证071近期出现的考试题库分享2019-05-21
  • 2.choose two Examine 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 in the GROUP BY clause. C) You can alter the table to include the NOT Nun., constraint on the EMP_IMAGE........详情
  • 【第1题】OCP认证071近期出现的考试题库分享2019-05-21
  • 1.choose the best answer What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models? A) RDB allows the definition of relationships between different tables, whereas OODB does not allow this. B) OODB incorporates methods with data structure definition, whereas RDB does not allow this. C) OODB supports multiple objects in the same database,........详情