|
Home > Archive > Oracle certifications > February 2002 > Last 1z0-001 question need help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Last 1z0-001 question need help
|
|
| sid456 2002-02-10, 12:52 pm |
| YOU ATTEMPT TO CREATE THE SALARY TABLE WITH THIS COMMAND:
a. CREATE TABLE SALARY
b. EMPLOYEE_ID NUMBER(9)
c. CONSTRAINT SALARY_PK PRIMARY KEY
d. 1995_SALARY NUMBER(8,12),
e. NUMBER MANAGER_NAME VARCHAR2(25)
f. CONSTRAINT MGR_NAME_NN NOT NULL,
g. $SALARY_96 NUMBER (8,12);
WHICH TWO LINES OF THE STATEMENT WILL RETURN ERRORS (CHOOSE TWO)?
ans:d,g
I agreed with d is incorrect.
Not sure about the second answer, should it be e or g.
Please help! I am going to take the exam. in
48 hours. Thanks in advance. | |
| aneesh_bhatia 2002-02-10, 1:14 pm |
| quote:
Originally posted by sid456
YOU ATTEMPT TO CREATE THE SALARY TABLE WITH THIS COMMAND:
a. CREATE TABLE SALARY
b. EMPLOYEE_ID NUMBER(9)
c. CONSTRAINT SALARY_PK PRIMARY KEY
d. 1995_SALARY NUMBER(8,12),
e. NUMBER MANAGER_NAME VARCHAR2(25)
f. CONSTRAINT MGR_NAME_NN NOT NULL,
g. $SALARY_96 NUMBER (8,12);
WHICH TWO LINES OF THE STATEMENT WILL RETURN ERRORS (CHOOSE TWO)?
ans:d,g
I agreed with d is incorrect.
Not sure about the second answer, should it be e or g.
Please help! I am going to take the exam. in
48 hours. Thanks in advance.
Answer: "D" (you already know why)
"E" (NUMBER is a reserved word,
cannot be used as a column)
Cheers!  | |
| sid456 2002-02-11, 3:35 am |
| Thanks again! | |
| laloca 2002-02-11, 10:56 am |
| Hi Sid,
there are some naming conventions:
Do not use characters from european or asian character sets
Only alphanumeric characters allowed, except $, _ and #
Object name must start with a letter (a-z)
Do not use preserved words like SYS, DUAL, NUMBER etc.
"g" is definitely wrong because it starts with $ and not with a letter a-z.
where is the "number" in line e. from? maybe copied by mistake?
Good luck for your exam! |
|
|
|
|