Which create table statement is valid?

The correct answer is D. Option D. 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…

Using DDL Statements to Create and Manage Tables

Question

Exhibit

Options

AOption A
BOption B
COption C
DOption D

How the community answered

(45 responses)

A
2% (1)
B
11% (5)
C
4% (2)
D
82% (37)

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

Topics

#CREATE TABLE#DDL syntax#constraints#table definition

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice