READ Free Dumps For Oracle- 1z0-007

Question ID 8021	Which two statements are true about constraints? (Choose two.)
Option A	The UNIQUE constraint does not permit a null value for the column.
Option B	A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
Option C	The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
Option D	The NOT NULL constraint ensures that null values are not permitted for the column.
Correct Answer	BD

Explanation Explanation/Reference: Explanation : B: A unique constraint can contain null values because null values cannot be compared to anything. D: The NOT NULL constraint ensure that null value are not permitted for the column Incorrect answer : A statement is not true C statement is not true Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-9

Question ID 8022	Which three are true? (Choose three.)
Option A	A MERGE statement is used to merge the data of one table with data from another.
Option B	A MERGE statement replaces the data of one table with that of another.
Option C	A MERGE statement can be used to insert new rows into a table.
Option D	A MERGE statement can be used to update existing rows in a table.
Correct Answer	ACD

Explanation Explanation/Reference: Explanation : The MERGE Statement allows you to conditionally insert or update data in a table. If the rows are present in the target table which match the join condition, they are updated if the rows are not present they are inserted into the target table

Previous-Page 1 2. . . 138 139 140 141 142 143 144. . . 160 161 Next-Page

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