A+) - Murdoch University
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which SQL keyword is used to name a new table and describe the table's columns?
Select one:
a. SET
b. CREATE
c. SELECT
d. ALTER
e. CONSTRAINT
Feedback
The correct answer is: CREATE
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
Which SQL keyword is used to impose restrictions on a table, data or relationship?
Select one:
a. SET
b. CREATE
c. SELECT
d. ALTER
, e. CONSTRAINT
Feedback
The correct answer is: CONSTRAINT
Question 3
Correct
Mark 1.00 out of 1.00
Flag question
Question text
One advantage of using the CONSTRAINT phrase to define a primary key is that the database
designer controls the .
Select one:
a. name of the primary key
b. name of the foreign key
c. name of the constraint
d. A and B
e. A, B and C
Feedback
The correct answer is: name of the constraint
Question 4
Correct
Mark 1.00 out of 1.00
Flag question
Question text
When creating tables, Oracle Database automatically converts the SQL standard data type "int"
into: