165
164
新闻中心
- 【第10题】OCP 11g(12c)考试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';.....详情
- 【第9题】OCP 11g(12c)考试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 11g(12c)考试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 11g(12c)考试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 11g(12c)考试071科目考试题库整理2019-05-21
6. choose the best answer
In 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 employees
SET 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 give........详情
- 【第5题】OCP 11g(12c)考试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:
SELECT seq1.nextval FROM dual;
What is displayed by the SELECT statement?.....详情
- 【第4题】OCP 11g(12c)考试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 11g(12c)考试071科目考试题库整理2019-05-21
OCP认证是Oracle非常重要的一个认证，对于11g版本来说，考试科目为071、052、053，对于12c版本来说，考试科目为071、062、063，可见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........详情
- 【第2题】OCP 11g(12c)考试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 11g(12c)考试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,........详情
