165
164
新闻中心
- 【第29题】2019年最新OCP认证071考试题库汇总2019-05-23
这两年来，OCP的071考试不像以前那么稳定了，总是不断的有新考题出现，增加了071考试的难度，对此，我们对071考试的原题进行了收集，并由专业人员给出了答案，分享给大家。--------------------------------------------071最新题库-第29题、choose the best answer:You need to produce a report where each customer's credit limit has been
incremented by $1000.In the output, the customer's last name should have the ........详情
- 【第30题】2019年最新OCP认证071考试题库汇总2019-05-23
这两年来，OCP的071考试不像以前那么稳定了，总是不断的有新考题出现，增加了071考试的难度，对此，我们对071考试的原题进行了收集，并由专业人员给出了答案，分享给大家。--------------------------------------------071最新题库-第30题、choose the best answerView the Exhibit and examine the structure of the SALES and STORES
tables.You want to display the store name and the total quantity sold for each item ........详情
- 【第21题】2019年最新OCP认证071考试题库汇总2019-05-23
这两年来，OCP的071考试不像以前那么稳定了，总是不断的有新考题出现，增加了071考试的难度，对此，我们对071考试的原题进行了收集，并由专业人员给出了答案，分享给大家。--------------------------------------------071最新题库-第21题、choose the best answerView the Exhibit and examine the description of the EMPLOYEES table.You want to calculate the total remuneration for each employee. Total
remuneration ........详情
- 【第22题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第22题、choose the best answer:
View the Exhibit and examine the structure of the CUSTOMERS table.
CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table.
CUSTOMERS needs to be updated to reflect the latest information about the customers.
What is the error in the following MERGE statement?
MERGE INTO customers c
USING customer_vu cv
........详情
- 【第23题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第23题、choose the best answer:
You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?
A) SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, 'e')'' AND
SUBSTR(cust_first_name, -2, 1)='a';
.....详情
- 【第24题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第24题、choose the best answer:
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?
A) ALL should be replaced with a list of specific privileges.
B) WITH GRANT OPTION should be added to the statement.
C) PUBLIC should be replaced with specific usernames.
........详情
- 【第25题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第25题、choose two:
View the Exhibit and examine the data in the PRODUCT_INFORMATION table.
Which two tasks would require subqueries? (Choose two.)
A) displaying all supplier IDs whose average list price is more than 500
B) displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
C) displaying all the products whose minimum list pri........详情
- 【第26题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第26题、choose two:
You executed the following CREATE TABLE statement that resulted in an error:
SQL CREATE TABLE employees(
emp_id NUMBER(10) PRIMARY KEY,
ename VARCHAR2(20),
email NUMBER(3) UNIQUE,
address VARCHAR2(500),
phone VARCHAR2 (20),
resume LONG,
hire_date DATE,
remarks LONG,
dept_id NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments(dept_id) ,
CONSTRAINT........详情
- 【第27题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第27题、choose the best answer:
View the Exhibit and examine the structure of the CUSTOMERS table.
Evaluate the following SQL statement:
SQL SELECT cust_city, COUNT(cust_last_name)
FROM customers
WHERE cust_credit_limit 1000
GROUP BY cust_city
HAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000;
Which statement is true regarding the outcome of the above query?.....详情
- 【第28题】2019年最新OCP认证071考试题库汇总2019-05-23
071最新题库-第28题、choose two:
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks would require subqueries?
A) Display the minimum list price for each product status.
B) Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.
C) Display all suppliers whose list price is less than 1000.
D) Display the number of pr........详情
- 【第20题】2019年最新OCP认证071考试题库汇总2019-05-22
20.choose the best answer
View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name,cost,and start date of all promos
in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?.....详情
- 【第19题】2019年最新OCP认证071考试题库汇总2019-05-22
19.choose the best answer
View the Exhibit and examine the structure of the PROMOTIONS table.
Evaluate the following SQL statement:
SQLSELECT promo_name,CASE
WHEN promo_cost=(SELECT AVG(promo_cost)
FROM promotions
WHERE promo_category= 'TV')
THEN 'HIGH'
ELSE 'LOW'
END COST_REMARK
FROM promotions;
Which statement is true regarding the outcome of the above query?.....详情
- 【第18题】2019年最新OCP认证071考试题库汇总2019-05-22
18.choose the best answer
View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables.
You issue the following query:
SQLSELECT p.prod_id,prod_name,prod_list_price,
quantity_sold,cust_last_name
FROM products p NATURAL JOIN sales s NATURAL JOIN customers c
WHERE prod_id =148;
Which statement is true regarding the outcome of this query?.....详情
- 【第17题】2019年最新OCP认证071考试题库汇总2019-05-22
17.choose the best answer
View the Exhibit and examine the description of the EMPLOYEES table.
Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date,6),1) "Review" FROM employees;
The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the first Monday after the completion of six months
o........详情
- 【第16题】2019年最新OCP认证071考试题库汇总2019-05-22
16.choose two
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.
You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products where in QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)
A) SELECT product_id, quantity_........详情
- 【第15题】2019年最新OCP认证071考试题库汇总2019-05-22
15.choose the best answer
View the Exhibit and examine the structure of the ORDER_ITEMS table.
Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price =
(SELECT MAX(unit_price)
FROM order items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID.
What correction should........详情
- 【第14题】2019年最新OCP认证071考试题库汇总2019-05-22
14.choose the best answer
View the Exhibit and examine the data in EMP and DEPT tables.
In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing
the DEPTNO column in the DEPT table.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DR........详情
- 【第13题】2019年最新OCP认证071考试题库汇总2019-05-22
13.choose the best answer
Which statement is true regarding the USING clause in table joins?
A) It can be used to access data from tables through equijoins as well as nonequijoins.
B) It can be used to join tables that have columns with the same name and compatible data types.
C) It can be used to join a maximum of three tables.
D) It can be used to restrict the number of columns used in a N........详情
- 【第12题】2019年最新OCP认证071考试题库汇总2019-05-22
12.choose the best answer
Evaluate the following query:
SQL SELECT promo_name || q'{'s start date was \}' || promo_begin_date
AS "Promotion Launches"
FROM promotions;
What would be the outcome of the above query?
A) It produces an error because the data types are not matching.
B) It executes successfully and displays the literal "{'s start date was \} " for each row in the output.
C) It e........详情
- 【第11题】2019年最新OCP认证071考试题库汇总2019-05-22
11.choose the best answer
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:
SQL CREATE TABLE DEPARTMENT_DETAILS
(DEPARTMENT_ID NUMBER PRIMARY KEY,
DEPARTMENT_NAME VARCHAR2(50) ,
HOD VARCHAR2(50));
SQL CREATE TABLE COURSE_DETAILS
(COURSE_ID NUMBER PRIMARY KEY,
COURSE_NAME VARCHAR2 (50) ,
DEPARTMENT_ID NUMBER REFERENCES DEPARTMENT_DETAILS(DEPARTMENT_ID));
You want........详情
