Introduction to SQL

Introduction to SQL
The result of every SQL query is a table.

False

True

ANSWER DOWNLOAD EXAMIANS APP

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

form

table

file

report

form

table

file

report

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

NATURAL JOIN

EQUIJOIN

NON-EQUIJOIN

OUTER JOIN

NATURAL JOIN

EQUIJOIN

NON-EQUIJOIN

OUTER JOIN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the cities whose humidity is 89

SELECT city WHERE humidity = 89;

SELECT city FROM weather;

SELECT city FROM weather WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

SELECT city WHERE humidity = 89;

SELECT city FROM weather;

SELECT city FROM weather 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
Indexes may be created or dropped at any time.

False

True

ANSWER DOWNLOAD EXAMIANS APP

MORE MCQ ON Introduction to SQL

↑