The condition in a WHERE clause can refer to only one value.

Introduction to SQL
The condition in a WHERE clause can refer to only one value.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

ADD

APPEND

INSERT

UPDATE

ADD

APPEND

INSERT

UPDATE

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL can be used to:

query database data only.

create database structures only.

All of these

modify database data only.

query database data only.

create database structures only.

All of these

modify database data only.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The condition in a WHERE clause can refer to only one value.

Introduction to SQL Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Introduction to SQL SQL can be used to:

Introduction to SQL Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Introduction to SQL
The condition in a WHERE clause can refer to only one value.

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Introduction to SQL
SQL can be used to:

Introduction to SQL
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF.

Introduction to SQL
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.