(TCO 3) Commands to create database objects such as tables are part of SQL _____.

Group of answer choices

Data Creation Language

Object Creation Language

Data Definition Language

Data Manipulation Language

Flag this Question

Question 2 pts

(TCO 3) The DateOfBirth column in an Employees table should use the SQL data type_____.

Group of answer choices

DATE

NUMBER(8)

CHAR(10)

VARCHAR(10)

Flag this Question

Question 3 pts

(TCO 3) Applying the _____ constraint to a column in the CREATE TABLE statement automatically assigns a value to the column when a new row is inserted in the table.

Group of answer choices

NOT NULL

CHECK

DEFAULT

UNIQUE

Flag this Question

Question 4 pts

(TCO 3) The _____ constraint in a CREATE TABLE statement is used to enforce entity integrity rules.

Group of answer choices

CHECK

DEFAULT

PRIMARY KEY

FOREIGN KEY

Flag this Question

Question 5 pts

(TCO 3) The SQL command used to remove a table from the database is _____.

Group of answer choices

DROP TABLE

DELETE TABLE

KILL TABLE

PURGE TABLE

Flag this Question

Question 6 pts

(TCO 3) The SQL command to modify data in a table is _____.

Group of answer choices

ALTER DATA

UPDATE

EDIT

MODIFY

Flag this Question

Question 7 pts

(TCO 3) The SQL command to display data contained in a table is _____.

Group of answer choices

DISPLAY

LIST

PRINT

SELECT

Flag this Question

Question 8 pts

(TCO 3) To retrieve only rows that match a specified set of conditions, use the _____ clause of the SELECT statement.

Group of answer choices

FILTER

MATCH

CONDITIONS

WHERE

Flag this Question

Question 9 pts

(TCO 3) A join operation that returns rows matching the join condition, plus rows with unmatched values, is _____.

Group of answer choices

a cross join

an inner join

an outer join

a lower join

Flag this Question

Question 10pts

(TCO 3) To perform a mathematical summary of values in a specified column in a query, use _____.

Group of answer choices

an aggregate function

a join operation

the SUMMARIZE clause

the LIKE operator