READ Free Dumps For Oracle- 1z0-001

Question ID 8182	Which table name is valid?
Option A	#_667.
Option B	Number.
Option C	Catch_#22.
Option D	1996_invoices.
Option E	Invoices-1996.
Correct Answer	C

Explanation Explanation/Reference: Explanation: Answers C is correct because there is no errors in table name Catch_#22. Incorrect Answers: A: Table name cannot start with symbol "#". B: Table name cannot be an Oracle keyword, like keyword NUMBER in this answer. D: Table name cannot start with numeric symbol. E: Table name cannot use symbol "-". Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 105-107 Chapter 3: Creating Oracle Database Objects

Question ID 8183	Examine the structure of the student table: NAME NULL? TYPE STUD_ID NOT NULL NUMBER(3) NAME NOT NULL VARCHAR2(25) PHONE NOT NULL VARCHAR2(9) ADDRESS VARCHAR2(50) GRADUATION DATE There are hundred records in the student table. You want to change the name of the graduation column to the grad_date. Which statement is true?
Option A	You can't rename a column.
Option B	You use the alter table command with the modify clause to rename the column.
Option C	You use the alter table command with the rename column clause to rename the column.
Option D	You use the alter table command with the modify column clause to modify the column.
Correct Answer	A

Explanation Explanation/Reference: Explanation: Answers A is correct because you can not change the name of the column without recreating this table. Incorrect Answers: B: ALTER TABLE command will not rename the column. C: ALTER TABLE command will not rename the column. D: ALTER TABLE command will not rename the column. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 6-8 Chapter 1: Selecting Data from Oracle

Previous-Page 1 2. . . 143 144 145 146 147 148 149. . . 152 153 Next-Page

Send email to admin@getfreedumps for new dumps request!!!