Topic: Oracle Certified Professional Exams (OCP & OCA) >> Question about valid table names (Q173 in TK) 1Z0-007
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Question about valid table names (Q173 in TK) 1Z0-007 |
| ozkucur |
Posted: Nov 07, 2006 05:31:53 AM |
Total Post: 23
Joined: Oct, 2006
|
Which is a valid CREATE TABLE statement?
A)CREATE TABLE EMP9$# AS (empid number(2));
B)CREATE TABLE EMP*123 AS (empid number(2));
C)CREATE TABLE PACKAGE AS (packid number(2));
D)CREATE TABLE 1EMP_TEST AS (empid number(2));
ANSWER: TK says A
IMO: A,C ???
First of all, I think the AS keyword in the answers is just mistyped.
I removed the AS keyword, and tried each statement in SQL*PLUS.
Both A and C answers worked. But this was single selection question, so only one of them has to be correct.
On the other hand, the table name in A is valid, but using $ and # is discouraged by Oracle.
The table name in C is also valid but it looks like a reserved word.
Any opinion? |
|
|
 Jayanta |
| Posted: Nov 07, 2006 02:50:01 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
HI!
THOUGH THE USE OF _,$ AND # IS DISCOURAGED BUT U CAN USE THEM WITHOUT ANY PROBLEM. U HAVE NO NEED TO THINK WEATHER THE QUESTION IS MISTYPED OR NOT.
"AS" IS NOT A VALID KEYWORD FOR CREATE TABLE STATEMENT, SO IT IS WRONG.
BYE
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
