READ Free Dumps For Oracle- 1z0-001
| Question ID 8138 | Examine the structure of STUDENTS table;
Name Null Type
STU ID NOT NULL NUMBER(3)
NAME NOT NULL VARCHAR2(25)
ADDRESS VARCHER2(50)
GRADUATION DATE
What statement adds a new column after NAME Column to hold phone numbers?
|
| Option A | ALTER TABLE student ADD COLUMN3(phone varchar2(9))
|
| Option B | ALTER TABLE student ADD COLUMN3(phone varchar2(9)) AS COLUMN3;
|
| Option C | ALTER TABLE student ADD COLUMN3(phone varchar2(9)) POSITION 3;
|
| Option D | You can't specify position when new column is added.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because it's impossible to specify position where new column will be added after table creation. Incorrect Answers: A: You cannot specify position of new column in the table. B: You cannot specify position of new column in the table. C: You cannot specify position of new column in the table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 141-142 Chapter 4: Creating Other Database Objects in Oracle
| Question ID 8139 | Which three SQL arithmetic expression return a date? (Choose three)
|
| Option A | '03-jul-96' + 7
|
| Option B | '03-jul-96' - 12
|
| Option C | '03-jul-96' + (12/24)
|
| Option D | '03-jul-96' - '04-jul-97'
|
| Option E | ('03-jul-96' - '04-jul-97') /7
|
| Option F | ('03-jul-96' - '04-jul-97') /12
|
| Correct Answer | ABC |
Explanation Explanation/Reference: Explanation: Answer A, B, C is correct because you can use "+" add and "-" operations with date and numeric values, result will be a DATE. Incorrect Answers: D: Result of this arithmetic expression will be numeric, not a DATE. E: Result of this arithmetic expression will be numeric, not a DATE. F: Result of this arithmetic expression will be numeric, not a DATE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 24 Chapter I: Selecting Data from Oracle