165
164
071题库
- 【第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
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认证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
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认证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?
A) 1
B) 100
C) an error
D) 10.....详情
- 【第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
2018年的OCP 11g题库解析暂告一段落,关于12c的OCP解析公开课正在进行中,课程包括071、062、063三个科目,这里为您带来的是最新版的071考试题库解析,帮大家顺利通过OCP的071考试。--------------------------------------------2.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........详情
- 【第1题】OCP认证071考试题库解析大全2019-05-21
2018年的OCP
11g题库解析暂告一段落,关于12c的OCP解析公开课正在进行中,课程包括071、062、063三个科目,这里为您带来的是最新版的071考试题库解析,帮大家顺利通过OCP的071考试。--------------------------------------------1.choose the best answerWhat is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?A) RDB allows the definition of relationships bet........详情