A subquery in an SQL SELECT statement is enclosed in:

Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

brackets -- [...].

braces -- {...}.

parenthesis -- (...) .

CAPITAL LETTERS.

brackets -- [...].

braces -- {...}.

parenthesis -- (...) .

CAPITAL LETTERS.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

READ

SELECT

QUERY

None of these

READ

SELECT

QUERY

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

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
You can add a row using SQL in a database with which of the following?

ADD

CREATE

INSERT

MAKE

ADD

CREATE

INSERT

MAKE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
What is a view?

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 database diagram.

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

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 database diagram.

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL A subquery in an SQL SELECT statement is enclosed in:

Introduction to SQL The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null 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 You can add a row using SQL in a database with which of the following?

Introduction to SQL What is a view?

Introduction to SQL
A subquery in an SQL SELECT statement is enclosed in:

Introduction to SQL
The SQL statement that queries or reads data from a table is ________ .

Introduction to SQL
COUNT(field_name) tallies only those rows that contain a value; it ignores all null 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
You can add a row using SQL in a database with which of the following?

Introduction to SQL
What is a view?