READ Free Dumps For Oracle- 1z0-061
| Question ID 21034 | You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same
AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?
|
| Option A | Option A
|
| Option B | Option B
|
| Option C | Option C
|
| Option D | Option D
|
| Correct Answer | D |
Explanation
| Question ID 21035 | Which create table statement is valid?
|
| Option A | Option A
|
| Option B | Option B
|
| Option C | Option C
|
| Option D | Option D
|
| Correct Answer | D |
Explanation Explanation: PRIMARY KEY Constraint A PRIMARY KEY constraint creates a primary key for the table. Only one primary key can be created for each table. The PRIMARY KEY constraint is a column or a set of columns that uniquely identifies each row in a table. This constraint enforces the uniqueness of the column or column combination and ensures that no column that is part of the primary key can contain a null value. Note: Because uniqueness is part of the primary key constraint definition, the Oracle server enforces the uniqueness by implicitly creating a unique index on the primary key column or columns.