<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[create_oracle的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/create_oracle</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; create_oracle]]></copyright><item><title><![CDATA[1Z0-051 QUESTION 37 关于drop table]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25573445</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25573445</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 01:08:47 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 36 create table中约束应注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25572869</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25572869</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 00:59:29 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 35 Primary key和foreign key的用法]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25572093</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25572093</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 00:46:27 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 34 通过alter table修改primary key]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25571697</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25571697</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 00:37:27 +0800</pubDate><description><![CDATA[34. You created an ORDERS table with the following description: 
name                Null            Type 
ORD_ID              NOT NULL        NUMBER(2) 
CUST_ID             NOT NULL        NUMBER(]]></description><category></category></item><item><title><![CDATA[1Z0-51 QUESTION 33 CREATE TABLE中约束的语法]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25571177</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25571177</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 00:31:00 +0800</pubDate><description><![CDATA[33. You want  to create an ORD_DETAIL table  to store details  for an order placed having  the  following 
business requirement:]]></description><category></category></item><item><title><![CDATA[QUESTION 31 CREATE table 注意事项]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25566247</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25566247</guid><author>create_oracle</author><pubDate>Mon, 12 May 2014 00:16:47 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 31 关于check约束]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25560509</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25560509</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 20:46:05 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[QUESTION 30 关于check约束]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25559371</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25559371</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 20:35:03 +0800</pubDate><description><![CDATA[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 ]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 29 关于约束]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25558903</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25558903</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 19:54:58 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 28 关于约束]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25546723</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25546723</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 15:30:13 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 27 table的命名规则]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25545597</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25545597</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 15:03:49 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 26 table的命名规则]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25545025</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25545025</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 14:49:06 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 25 表名应该注意的地方和CLOB应该注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25515663</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25515663</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 00:56:52 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 24 数据类型应该注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25515277</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25515277</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 00:45:06 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 23 数据类型应该注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25514483</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25514483</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 00:33:32 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-51 QUESTION 22 INTERVAL的使用]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25514157</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25514157</guid><author>create_oracle</author><pubDate>Sun, 11 May 2014 00:12:55 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-051 QUESTION 21 LONG数据类型应该注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25512687</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25512687</guid><author>create_oracle</author><pubDate>Sat, 10 May 2014 23:57:30 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-51 QUESTION 20 表的数据类型应该注意的地方]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25511979</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25511979</guid><author>create_oracle</author><pubDate>Sat, 10 May 2014 23:26:25 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[QUESTION 19 INTERVAL的用法]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25507545</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25507545</guid><author>create_oracle</author><pubDate>Sat, 10 May 2014 21:50:14 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[1Z0-51 QUESTION 18 DISTINCT的用法]]></title><link>https://blog.youkuaiyun.com/create_oracle/article/details/25487771</link><guid>https://blog.youkuaiyun.com/create_oracle/article/details/25487771</guid><author>create_oracle</author><pubDate>Sat, 10 May 2014 16:09:39 +0800</pubDate><description><![CDATA[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 ]]></description><category></category></item></channel></rss>