-
编辑 删除
OCP-051-008
View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)观察下面的表结构, 哪儿个任务需要在一个语句中包含子查询或者joinsA. listing of customers who do not have a credit limit and wer...
-
编辑 删除
OCP-051-007
7. Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.) 关于USING和ON子句, 哪儿个是正确的A. Both USING and ON clauses can be used for equijoins and nonequijoins. --using不能用于不等值连接B. A maximum of one pair of columns...
-
编辑 删除
OCP-051-006
6. Examine the structure of the SHIPMENTS table: 检查表SHIPMENTS 的结构name Null TypePO_ID NOT NULL NUMBER(3) PO_DATE NOT NULL DATESHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2(30) SHIPMENT_COST NUMBER(8,2)You want to generate a report that displays the PO_ID and the penal...
-
编辑 删除
OCP-051-005
5. Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .) A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;C. SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL;D. SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;E. S...
-
编辑 删除
OCP-051-004
4. Which two statements are true regarding single row functions? (Choose two.) --下列关于简单函数描述正确的是A. They accept only a single argument. --select concat('a','b') from dual; B. They can be nested only to two levels. &nb...
-
编辑 删除
OCP-051-003
3. You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required output? --以下哪个子句可以找出包含 '_D123' 字符串的行A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'B...
-
编辑 删除
OCP-051-002
2. View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)A. CREATE VIEW v3AS SELECT * FROM SALES WHERE cust_id = 2034WITH CHECK OPTION;B. CREATE VIEW v1AS SELECT * FROM SALESW...
-
编辑 删除
OCP-051--001
oracle 通过CTAS建表的约束关系
