Introduction to SQL

Introduction to SQL
SQL is a data sublanguage.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which one of the following sorts rows in SQL?

SORT BY

ALIGN BY

ORDER BY

GROUP BY

SORT BY

ALIGN BY

ORDER BY

GROUP BY

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL keyword(s) ________ is used with wildcards.

IN only

NOT IN only

IN and NOT IN

LIKE only

IN only

NOT IN only

IN and NOT IN

LIKE only

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

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
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Data Manipulation Language(DML)

None

Data Definition Language(DDL)

Both of above

Data Manipulation Language(DML)

None

Data Definition Language(DDL)

Both of above

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON Introduction to SQL

↑