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.

Report this post to a moderator

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!

Report this post to a moderator

Thanks again!

Report this post to a moderator

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!

__________________
laLocA

Report this post to a moderator