OCP之路
文章平均质量分 72
create_oracle
这个作者很懒,什么都没留下…
展开
-
1Z0-051 QUESTION 2 选项WITH CHECK OPTION在CREATE VIEW中的使用
QUESTION 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.)原创 2014-05-06 23:22:53 · 883 阅读 · 0 评论 -
1Z0-051 QUESTION 25 表名应该注意的地方和CLOB应该注意的地方
QUESTION 25 Resume (character large object [CLOB] data type), which contains the resume submitted by the employee Which is the correct syntax to create this table? A. CREATE TABLE EMP_1 (emp_id N原创 2014-05-11 00:56:52 · 386 阅读 · 0 评论 -
1Z0-051 QUESTION 8 子查询和JION的用法
QUESTION 8 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.)原创 2014-05-07 13:50:13 · 498 阅读 · 0 评论 -
1Z0-051 QUESTION 16 Q操作符的使用
QUESTION 16 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原创 2014-05-10 00:24:41 · 1216 阅读 · 0 评论 -
1Z0-051 QUESTION 17 NULL的运算
QUESTION 17 View the E xhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to date. You issue the following query:原创 2014-05-10 00:47:08 · 512 阅读 · 0 评论 -
1Z0-51 QUESTION 22 INTERVAL的使用
QUESTION 22 You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the cred原创 2014-05-11 00:12:55 · 479 阅读 · 0 评论 -
1Z0-051 QUESTION 26 table的命名规则
QUESTION 26 Which is the valid CREATE TABLE statement? A. CREATE TABLE emp9$# (emp_no NUMBER (4)); B. CREATE TABLE 9emp$# (emp_no NUMBER(4)); C. CREATE TABLE emp*123 (emp_no NUMBER(4)); D. CREATE原创 2014-05-11 14:49:06 · 551 阅读 · 0 评论 -
1Z0-051 QUESTION 27 table的命名规则
QUESTION 27 Which two statements are true regarding tables? (Choose two.) A. A table name can be of any length. B. A table can have any number of columns. C. A column that has a DEFAULT value cann原创 2014-05-11 15:03:49 · 517 阅读 · 0 评论 -
1Z0-051 QUESTION 28 关于约束
Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values. B. A column with the UNIQUE constraint can contain NULL values. C. A constraint is en原创 2014-05-11 15:30:13 · 341 阅读 · 0 评论 -
1Z0-051 QUESTION 29 关于约束
QUESTION 29 Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values. B. The column with a UNIQUE constraint can store NULLS . C. A constraint原创 2014-05-11 19:54:58 · 394 阅读 · 0 评论 -
1Z0-51 QUESTION 33 CREATE TABLE中约束的语法
33. You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:原创 2014-05-12 00:31:00 · 449 阅读 · 0 评论 -
1Z0-051 QUESTION 36 create table中约束应注意的地方
36. Examine the following SQL commands: SQL>CREATE TABLE products ( prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0), prod_name CHAR(30), prod_qty NUMBER(6), CONSTRAINT p_name NOT NULL原创 2014-05-12 00:59:29 · 529 阅读 · 0 评论 -
QUESTION 31 CREATE table 注意事项
32. Which CREATE TABLE statement is valid? A. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL); B. CREATE TABLE ord_de原创 2014-05-12 00:16:47 · 490 阅读 · 0 评论 -
1Z0-051 QUESTION 31 关于check约束
31. Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; SQL>CREATE TABLE ord_items (ord_no NUMBE原创 2014-05-11 20:46:05 · 431 阅读 · 0 评论 -
1Z0-051 QUESTION 35 Primary key和foreign key的用法
35. Which two statements are true regarding constraints? (Choose two.) A. A table can have only one primary key and one foreign key. B. A table can have only one primary key but multiple foreign k原创 2014-05-12 00:46:27 · 792 阅读 · 0 评论 -
QUESTION 30 关于check约束
QUESTION 30 Evaluate the following CREATE TABLE commands: CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no原创 2014-05-11 20:35:03 · 474 阅读 · 0 评论 -
1Z0-051 QUESTION 34 通过alter table修改primary key
34. You created an ORDERS table with the following description: name Null Type ORD_ID NOT NULL NUMBER(2) CUST_ID NOT NULL NUMBER(原创 2014-05-12 00:37:27 · 1179 阅读 · 0 评论 -
1Z0-051 QUESTION 24 数据类型应该注意的地方
QUESTION 24 Examine the structure proposed for the TRANSACTIONS table: name Null Type TRANS_ID NOT NULL NUMBER(6) CUST_NAME NOT NULL VARCHAR2(20) CUST_STATUS NOT NULL VARCHAR2 TRANS_DATE NOT NUL原创 2014-05-11 00:45:06 · 389 阅读 · 0 评论 -
1Z0-051 QUESTION 23 数据类型应该注意的地方
QUESTION 23 Examine the structure proposed for the TRANSACTIONS table: name Null Type TRANS_ID NOT NULL NUMBER(6) CUST_NAME NOT NULL VARCHAR2(20) CUST_STATUS NOT NULL CHAR TRANS_DATE NOT NULL DA原创 2014-05-11 00:33:32 · 456 阅读 · 0 评论 -
1Z0-051 QUESTION 21 LONG数据类型应该注意的地方
QUESTION 21 Examine the description of the EMP_DETAILS table given below: name NULL TYPE EMP_ID NOT NULL NUMBER EMP_NAME NOT NULL VARCHAR2 (40) EMP_IMAGE LONG Which two statements are true regar原创 2014-05-10 23:57:30 · 528 阅读 · 0 评论 -
1Z0-051 QUESTION 1 利用CREATE TABLE AS创建表
QUESTION 1 View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS ta原创 2014-05-06 22:50:41 · 508 阅读 · 0 评论 -
1Z0-051 QUESTION 5 TO_CHAR的应用
QUESTION 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;原创 2014-05-07 09:42:01 · 426 阅读 · 0 评论 -
1Z0-051 QUESTION 4 单行函数Single-Row Functions
QUESTION 4 Which two statements are true regarding single row functions? (Choose two.) A. They a ccept only a single argument. B. They c an be nested only to two levels. C. Arguments can only be c原创 2014-05-07 00:10:57 · 891 阅读 · 0 评论 -
1Z0-051 QUESTION 3 转译字符\在where语句中的使用
QUESTION 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原创 2014-05-06 23:36:29 · 644 阅读 · 0 评论 -
1Z0-051 QUESTION 6 CASE和DECODE用法
QUESTION 6 Examine the structure of the SHIPMENTS table: name Null Type PO_ID NOT NULL NUMBER(3) PO_DATE NOT NULL DATE SHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2(30) SHIPMENT_COST NUMBE原创 2014-05-07 11:08:17 · 560 阅读 · 0 评论 -
1Z0-051 QUESTION 9 关于INTERSECT的用法
QUESTION 9 Which statement is true regarding the INTERSECT operator? A. It ignores NULL values. B. Reversing the order of the intersected tables alters the result. C. The names of columns in all S原创 2014-05-07 14:18:00 · 591 阅读 · 0 评论 -
1Z0-051 QUESTION 12 别名和INITCAP的运用
QUESTION 12 You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, t he customer's last name should have the heading Name and the incremented c原创 2014-05-07 17:21:56 · 466 阅读 · 0 评论 -
1Z0-051 QUESTION 7 ON和USING的用法
1Z0-051 QUESTION 1 利用CREATE TABLE AS创建表原创 2014-05-07 13:13:25 · 439 阅读 · 0 评论 -
1Z0-051 QUESTION 10 运算的时候注意括号的位置和隐式转换
QUESTION 10 View the Exhibit; e xamine the structure of the PROMOTIONS table. Each promotion has a duration of at least seven days . Your manager has asked you to generate a report, which provides原创 2014-05-07 15:29:23 · 363 阅读 · 0 评论 -
1Z0-051 QUESTION 11 运算顺序
QUESTION 11 View the Exhibit and examine the structure of the PRODUCTS table. All products have a list price. You issue the following command to display the total price of each product after a disc原创 2014-05-07 16:04:23 · 418 阅读 · 0 评论 -
1Z0-051 QUESTION 13 Q字符的特殊使用
QUESTION 13 View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box'原创 2014-05-07 18:24:29 · 1243 阅读 · 0 评论 -
1Z0-051 QUESTION 14 DISTINCT的用法
Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which原创 2014-05-09 23:32:31 · 502 阅读 · 0 评论 -
1Z0-051 QUETION 15 别名的用法
QUESTION 15 View the Exhibit and examine the data in the CUSTOMERS table. Evaluate the following query: SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAX LOWER原创 2014-05-10 00:09:43 · 442 阅读 · 0 评论 -
1Z0-51 QUESTION 18 DISTINCT的用法
QUESTION 18 Examine the structure of the PROMOTIONS table: name Null Type PROMO_ID NOT NULL NUMBER(6) PROMO_NAME NOT NULL VARCHAR2(30) PROMO_CATEGORY NOT NULL VARCHAR2(30) PROMO_COST NOT NULL原创 2014-05-10 16:09:39 · 531 阅读 · 0 评论 -
QUESTION 19 INTERVAL的用法
QUESTION 19 Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the abov原创 2014-05-10 21:50:14 · 461 阅读 · 0 评论 -
1Z0-51 QUESTION 20 表的数据类型应该注意的地方
QUESTION 20 Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.) A. Only one LONG column can be used per table. B. A TIMESTAMP data type column store原创 2014-05-10 23:26:25 · 586 阅读 · 0 评论 -
1Z0-051 QUESTION 37 关于drop table
37. You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command? (Choose all that apply.) A. All data along with the table stru原创 2014-05-12 01:08:47 · 759 阅读 · 0 评论