Which of the following is a valid SQL type?

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

CHARACTER

FLOAT

All of these

NUMERIC

CHARACTER

FLOAT

All of these

NUMERIC

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.

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 special stored procedure executed when certain event occurs.

A view is a database diagram.

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
The Microsoft Access wildcards are and .

underscore(_); question mark (?)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

underscore(_); question mark (?)

percent sign (%); underscore (_)

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
In SQL, which command is used to change a table's storage characteristics?

None of these

ALTER TABLE

CHANGE TABLE

MODIFY TABLE

None of these

ALTER TABLE

CHANGE TABLE

MODIFY TABLE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT city FROM weather;

SELECT humidity = 89 FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL WHERE clause:

limits the row data are returned.

Neither A nor B are correct.

limits the column data that are returned.

Both A and B are correct.

limits the row data are returned.

Neither A nor B are correct.

limits the column data that are returned.

Both A and B are correct.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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

Introduction to SQL What is a view?

Introduction to SQL The Microsoft Access wildcards are ____ and ____ .

Introduction to SQL In SQL, which command is used to change a table's storage characteristics?

Introduction to SQL Find all the cities whose humidity is 89

Introduction to SQL The SQL WHERE clause:

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

Introduction to SQL
What is a view?

Introduction to SQL
The Microsoft Access wildcards are and .

Introduction to SQL
In SQL, which command is used to change a table's storage characteristics?

Introduction to SQL
Find all the cities whose humidity is 89

Introduction to SQL
The SQL WHERE clause: