AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7925

Which four are correct guidelines for naming database tables? (Choose four)

Option A

Must begin with either a number or a letter.

Option B

Must be 1-30 characters long.

Option C

Should not be an Oracle Server reserved word.

Option D

Must contain only A-Z, a-z, 0-+, _, *, and #.

Option E

Must contain only A-Z, a-z, 0-9, _, $, and #.

Option F

Must begin with a letter.

Correct Answer BCEF
Explanation Explanation/Reference: Explanation: Oracle database object must begin with a letter and can usually be between 1 and 30 characters long, except for databases (which have a maximum of eight characters) and database links (with a maximum of 128 characters). Name cannot be an Oracle Server reserved word. Name must contain only A-Z, a-z, 0-9, _, $, and #. Incorrect Answers A: Database tables may not begin with number. D: It cannot contain symbols "+" or "*". OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 208-211 Chapter 5: Creating Oracle Database Objects


Question ID 7926

Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?

Option A

CREATE INDEX NAME _IDX (first_name, last_name);

Option B

CREATE INDEX NAME _IDX (first_name, AND last_name)

Option C

CREATE INDEX NAME_IDX ON (First_name, last_name);

Option D

CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);

Option E

CREATE INDEX NAME_IDX ON employees (First_name, last_name);

Option F

CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

Correct Answer E
Explanation Explanation/Reference: Explanation: Answer E provides correct syntax to create index: CREATE INDEX index_name ON table_name(list of columns). Incorrect Answers A: You need to use keyword ON also to create index. B: You cannot use keyword AND to build a list of columns for index. Also this statement is missing the table name on which the index is creating. C: This statement is missing the table name on which the index is creating. D: You cannot use keyword AND to build a list of columns for index. F: You cannot use keyword FOR to create an index. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 322-331 Chapter 7: Creating Other Database Objects in Oracle

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