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-001





Question ID 8160

Which statement would you use to add a primary key constraint to the patient table using the id_number column immediately enabling the constraint?

Option A

This task can't be accomplished.

Option B

ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);

Option C

ALTER TABLE patient ADD (id_number CONATRAINT pat_id_pk PRIMARY KEY);

Option D

ALTER TABLE patient MODIFY(id_number CONSTRAINT pat_id_pk PRIMARY KEY);

Correct Answer B
Explanation Explanation/Reference: Explanation: Answer B is correct because this statement will add a primary key constraint to the patient table and immediately enable it. Incorrect Answers: A: This task can be successfully accomplished. C: Syntax to add a primary key is wrong. D: Syntax to add a primary key is wrong. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 100-105 Chapter 3: Creating Oracle Database Objects


Question ID 8161

You attempt to create the salary table with this command: 1. CREATE TABLE SALARY. 2. (employee_id NUMBER(9) 3. CONSTRAINT salary_pk PRIMARY KEY, 4. 1995_salary NUMBER(8,2), 5. NUMBER_manager_name VARCHAR2(25) 6. CONSTRAINT mgr_name_nn NOT NULL, 7. $_salary_96 NUMBER(8,2)); Which two lines of the statement will return errors? (Choose two)

Option A

1

Option B

2

Option C

3

Option D

4

Option E

5

Option F

7

Correct Answer DF
Explanation Explanation/Reference: Explanation: Answers D, F is correct because the first letter in column name cannot be numeric, like 1995_salary, or can not start with $. Incorrect Answers: A: The CREATE clause is correct , there are no error. B: A definition of employee_id column is correct also. C: A definition of PRIMARY KEY in SALARY table is correct. E: Column name can include keywords, just cannot be the same as keywords. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 105-107 Chapter 3: Creating Oracle Database Objects

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