165
164
新闻中心
- 【第10题】OCP考试1Z0-071近期考试原题分享2019-05-21
071考试是OCP认证的一个重要科目，不少考生都在这里受伤，对此我们专门收集整理了近期071考试的原题，并对071题库进行了讲解，希望帮助大家顺利通过071考试。--------------------------------------------10.choose the best answerEvaluate the following SQL statement:SQL> SELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'Internet' ORDER BY 2 DESCUNIONSELECT promo_id, promo_categoryFROM pr........详情
- 【第9题】OCP考试1Z0-071近期考试原题分享2019-05-21
9.choose two
The 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');
SQL INSERT INTO product VALUES (2,'pencil');
SQL SAVEPOINT a;
SQL UPDATE product SET pcode = 10 WHERE pcode = 1;
SQL SAVEPOINT b;
SQL DELETE FROM product WHERE pcode = 2;
SQL COMMIT;
SQL DELETE FROM produc........详情
- 【第8题】OCP考试1Z0-071近期考试原题分享2019-05-21
071考试是OCP认证的一个重要科目，不少考生都在这里受伤，对此我们专门收集整理了近期071考试的原题，并对071题库进行了讲解，希望帮助大家顺利通过071考试。--------------------------------------------8.choose twoExamine the structure of the PRODUCTS table.Which two statements are true?A) EXPIRY_DATE always stores date and time in character formatB) PRICE can store a maximum of eight digits and two decimal........详情
- 【第7题】OCP考试1Z0-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考试1Z0-071近期考试原题分享2019-05-21
071考试是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 employeesSET salary = NV........详情
- 【第5题】OCP考试1Z0-071近期考试原题分享2019-05-21
5.choose the best answer
Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The sequence SEQ1 has generated numbers up to the maximum limit of 200.
You issue the following SQL statement:.....详情
- 【第4题】OCP考试1Z0-071近期考试原题分享2019-05-21
071考试是OCP认证的一个重要科目，不少考生都在这里受伤，对此我们专门收集整理了近期071考试的原题，并对071题库进行了讲解，希望帮助大家顺利通过071考试。--------------------------------------------4.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........详情
- 【第3题】OCP考试1Z0-071近期考试原题分享2019-05-21
071考试是OCP认证的一个重要科目，不少考生都在这里受伤，对此我们专门收集整理了近期071考试的原题，并对071题库进行了讲解，希望帮助大家顺利通过071考试。--------------------------------------------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 the PROMOTIONS table has either blowout s........详情
- 【第2题】OCP考试1Z0-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考试1Z0-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,........详情
