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

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

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL can be used to:

create database structures only.

modify database data only.

All of these

query database data only.

create database structures only.

modify database data only.

All of these

query database data only.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A view is which of the following?

A base table that cannot be accessed via SQL commands

A virtual table that cannot be accessed via SQL commands

A base table that can be accessed via SQL commands

A virtual table that can be accessed via SQL commands

A base table that cannot be accessed via SQL commands

A virtual table that cannot be accessed via SQL commands

A base table that can be accessed via SQL commands

A virtual table that can be accessed via SQL commands

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

A view is a database diagram.

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

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.

None of these

A view is a database diagram.

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

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.

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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 SQL can be used to:

Introduction to SQL A view is which of the following?

Introduction to SQL What is a view?

Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

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
SQL can be used to:

Introduction to SQL
A view is which of the following?

Introduction to SQL
What is a view?

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.