Introduction to SQL

Introduction to SQL
SQL data definition commands make up a(n) ________ .

XML

DDL

HTML

DML

XML

DDL

HTML

DML

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which SQL keyword is used to sort the result-set?

ORDER

SORT BY

ORDER BY

SORT

ORDER

SORT BY

ORDER BY

SORT

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL WHERE clause:

Neither A nor B are correct.

limits the column data that are returned.

limits the row data are returned.

Both A and B are correct.

Neither A nor B are correct.

limits the column data that are returned.

limits the row data are returned.

Both A and B are correct.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
SUM, AVG, MIN, and MAX can only be used with numeric columns.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The result of a SQL SELECT statement is a ________ .

file

report

table

form

file

report

table

form

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON Introduction to SQL

↑