Which of the following is a valid SQL type?

Introduction to SQL
Which of the following is a valid SQL type?

NUMERIC

FLOAT

All of these

CHARACTER

NUMERIC

FLOAT

All of these

CHARACTER

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

None of these

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

None of these

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Indexes can usually be created for both primary and secondary keys.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL Which of the following is a valid SQL type?

Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL What is a view?

Introduction to SQL Indexes can usually be created for both primary and secondary keys.

Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat?

Introduction to SQL
Which of the following is a valid SQL type?

Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL
What is a view?

Introduction to SQL
Indexes can usually be created for both primary and secondary keys.

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?