The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SQL can be used to:

create database structures only.

All of these

query database data only.

modify database data only.

create database structures only.

All of these

query database data only.

modify database data only.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

456789

6789

2345

1234

456789

6789

2345

1234

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL WHERE clause:

Neither A nor B are correct.

Both A and B are correct.

limits the column data that are returned.

limits the row data are returned.

Neither A nor B are correct.

Both A and B are correct.

limits the column data that are returned.

limits the row data are returned.

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?

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;

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;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL Find the name of all cities with their temperature, humidity and countries.

Introduction to SQL SQL can be used to:

Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

Introduction to SQL The SQL WHERE clause:

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

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
Find the name of all cities with their temperature, humidity and countries.

Introduction to SQL
SQL can be used to:

Introduction to SQL
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

Introduction to SQL
The SQL WHERE clause:

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