create_oracle-CSDN博客

原创 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 760

原创 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 536

原创 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 798

原创 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 1188

原创 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 458

原创 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 498

原创 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 438

原创 QUESTION 30 关于check约束

QUESTION 30Evaluate 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 479

原创 1Z0-051 QUESTION 29 关于约束

QUESTION 29Which 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 395

原创 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 342

原创 1Z0-051 QUESTION 27 table的命名规则

QUESTION 27Which 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 519

原创 1Z0-051 QUESTION 26 table的命名规则

QUESTION 26Which 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

原创 1Z0-051 QUESTION 25 表名应该注意的地方和CLOB应该注意的地方

QUESTION 25Resume (character large object [CLOB] data type), which contains the resume submitted by theemployeeWhich is the correct syntax to create this table?A. CREATE TABLE EMP_1(emp_id N

2014-05-11 00:56:52 391

原创 1Z0-051 QUESTION 24 数据类型应该注意的地方

QUESTION 24Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL VARCHAR2TRANS_DATE NOT NUL

2014-05-11 00:45:06 391

原创 1Z0-051 QUESTION 23 数据类型应该注意的地方

QUESTION 23Examine the structure proposed for the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(6)CUST_NAME NOT NULL VARCHAR2(20)CUST_STATUS NOT NULL CHARTRANS_DATE NOT NULL DA

2014-05-11 00:33:32 459

原创 1Z0-51 QUESTION 22 INTERVAL的使用

QUESTION 22You need to create a table for a banking application. One of the columns in the table has the followingrequirements:1) You want a column in the table to store the duration of the cred

2014-05-11 00:12:55 486

原创 1Z0-051 QUESTION 21 LONG数据类型应该注意的地方

QUESTION 21Examine the description of the EMP_DETAILS table given below:name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regar

2014-05-10 23:57:30 532

原创 1Z0-51 QUESTION 20 表的数据类型应该注意的地方

QUESTION 20Which 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 591

原创 QUESTION 19 INTERVAL的用法

QUESTION 19Evaluate the following query:SELECT INTERVAL '300' MONTH,INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECONDFROM dual;What is the correct output of the abov

2014-05-10 21:50:14 465

原创 1Z0-51 QUESTION 18 DISTINCT的用法

QUESTION 18Examine the structure of the PROMOTIONS table:name Null TypePROMO_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 532

原创 1Z0-051 QUESTION 17 NULL的运算

QUESTION 17View 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 518

原创 1Z0-051 QUESTION 16 Q操作符的使用

QUESTION 16Evaluate the following query:SQL> SELECT promo_name q'{'s start date was }' promo_begin_dateAS "Promotion Launches"FROM promotions;What would be the outcome of the above query?A

2014-05-10 00:24:41 1221

原创 1Z0-051 QUETION 15 别名的用法

QUESTION 15View 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 "MAXLOWER

2014-05-10 00:09:43 444

原创 1Z0-051 QUESTION 14 DISTINCT的用法

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amountin each income level. The report should NOT show any repeated credit amounts in each income level.Which

2014-05-09 23:32:31 506

原创 1Z0-051 QUESTION 13 Q字符的特殊使用

QUESTION 13View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box'

2014-05-07 18:24:29 1248

原创 1Z0-051 QUESTION 12 别名和INITCAP的运用

QUESTION 12You need to produce a report where each customer's credit limit has been incremented by $1000. In theoutput, t he customer's last name should have the heading Name and the incremented c

2014-05-07 17:21:56 469

原创 1Z0-051 QUESTION 11 运算顺序

QUESTION 11View 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 421

原创 1Z0-051 QUESTION 10 运算的时候注意括号的位置和隐式转换

QUESTION 10View 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 367

原创 1Z0-051 QUESTION 9 关于INTERSECT的用法

QUESTION 9Which 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 599

原创 1Z0-051 QUESTION 8 子查询和JION的用法

QUESTION 8View 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 505

原创 1Z0-051 QUESTION 7 ON和USING的用法

1Z0-051 QUESTION 1 利用CREATE　TABLE　AS创建表

2014-05-07 13:13:25 441

原创 1Z0-051 QUESTION 6 CASE和DECODE用法

QUESTION 6Examine the structure of the SHIPMENTS table:name Null TypePO_ID NOT NULL NUMBER(3)PO_DATE NOT NULL DATESHIPMENT_DATE NOT NULL DATESHIPMENT_MODE VARCHAR2(30)SHIPMENT_COST NUMBE

2014-05-07 11:08:17 563

原创 1Z0-051 QUESTION 5 TO_CHAR的应用

QUESTION 5Which 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 427

原创 1Z0-051 QUESTION 4 单行函数Single-Row Functions

QUESTION 4Which 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 895

原创 1Z0-051 QUESTION 3 转译字符\在where语句中的使用

QUESTION 3You need to extract details of those products in the SALES table where the PROD_ID column containsthe string '_D123'.Which WHERE clause could be used in the SELECT statement to get the

2014-05-06 23:36:29 647

原创 1Z0-051 QUESTION 2 选项WITH CHECK OPTION在CREATE VIEW中的使用

QUESTION 2View 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 892

原创 1Z0-051 QUESTION 1 利用CREATE　TABLE　AS创建表

QUESTION 1View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMEStables.The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS ta

2014-05-06 22:50:41 518

create_oracle的专栏