| gill123 |
Posted: Jun 19, 2007 10:05:54 PM |
Total Post: 12
Joined: Jun, 2007
|
Hi everybody,
Well I am quite late so I believe most of you already found errors with the dumps for 1z0-007. So if any of you has the corrections please kindly share it.
Right now I am really confused as I can see some answers are wrong but not sure about the answers. Please help.
Many thanks. |
|
|
 kiran |
| Posted: Jun 20, 2007 10:09:49 AM |  |
|
Total Post: 13
Joined: May, 2007
|
Hi gill,
I am also feeling the same.
So come up with ur doubts, so that we can have discussion and inturn correct answer.
what do u say
|
|
|
|
|
| gill123 |
| Posted: Jun 20, 2007 01:24:49 PM | |
|
Total Post: 12
Joined: Jun, 2007
|
Yes great idea......i will post my doubts soon....thanks
|
|
|
|
|
| gill123 |
| Posted: Jun 20, 2007 08:55:28 PM | |
|
Total Post: 12
Joined: Jun, 2007
|
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements inserts a row into the table? (Choose three)
A. INSERT INTO employees
VALUES ( NULL, ‘John’,‘Smith’);
B. INSERT INTO employees( first_name, last_name)
VALUES(‘John’,‘Smith’);
C. INSERT INTO employees
VALUES (‘1000’,‘John’,NULL);
D. INSERT INTO employees(first_name,last_name, employee_id)
VALUES ( 1000, ‘John’,‘Smith’);
E. INSERT INTO employees (employee_id)
VALUES (1000);
F. INSERT INTO employees (employee_id, first_name, last_name)
VALUES ( 1000, ‘John’,‘’);
Answer: C, E, F
But I think the answer is D, E, F
|
|
|
|
|
| kiran |
| Posted: Jun 21, 2007 02:13:24 AM | |
|
Total Post: 13
Joined: May, 2007
|
C,E,F are the correct answers.
In the 'D' option the values are not given as columns names order.
So i think D is wrong option
|
|
|
|
|
| gill123 |
| Posted: Jun 21, 2007 03:55:05 AM | |
|
Total Post: 12
Joined: Jun, 2007
|
Thanks.
But for D as we can see the following:
EMPLOYEE_ID NUMBER gets 1000
FIRST_NAME VARCHAR2(25) gets ‘John’
LAST_NAME VARCHAR2(25) gets ‘Smith’
Doesn't it seem right?
whereas in C EMPLOYEE_ID NUMBER gets ‘1000’(which is not a number)
Please confirm.
Thanks.
|
|
|
|
|
| gill123 |
| Posted: Jun 21, 2007 05:16:29 AM | |
|
Total Post: 12
Joined: Jun, 2007
|
Sorry....I misunderstood:)
You are right.....D is wrong.
But I am still confused about C.
Thanks.
|
|
|
|
|
| kiran |
| Posted: Jun 21, 2007 05:42:15 AM | |
|
Total Post: 13
Joined: May, 2007
|
Hi gill,
Yes u r right option 'c' is not correct option. at the same time 'D' also cannot be correct option because column order and value order should be same. So E and F are only correct options.
|
|
|
|
|
| KS |
| Posted: Jun 21, 2007 05:43:33 AM | |
|
Total Post: 63
Joined: Nov, 2006
|
Hi guys,
---------------------------------------------------------------------
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements inserts a row into the table? (Choose three)
C. INSERT INTO employees
VALUES (‘1000’,‘John’,NULL);
D. INSERT INTO employees(first_name,last_name, employee_id)
VALUES ( 1000, ‘John’,‘Smith’);
---------------------------------------------------------------------
Guys , the options C,E,F are the right ones.
Let me explain you , why D is not correct...
The order of the column given is (first_name,last_name, employee_id)
and the order of the vsalues is ( 1000, ‘John’,‘Smith’)
I guess you got know what's wrong in D..
first_name is not a number data type (1000)
and Employee_id is not a CHAR or VARCHAR2 datatype.
Also about the option C.. it will insert the data into the EMPLOYEE table.
Kindly while going through the dump, create the table and test the answers... I think both of you haven't tried it.
Try executing the options and post with the Error you are getting, then we will dicuss about why that option got failed.
- Sri.
|
|
|
|
|
| kiran |
| Posted: Jun 21, 2007 07:23:07 AM | |
|
Total Post: 13
Joined: May, 2007
|
Hi sri and gill,
come up with wrong answers if you found any. so that we can have discussion. Actually i am not having oracle s/w to check these questions.
so can you pls come up with corrections
thanks in advance.
bye,
kiran
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
