What is a view? | EXAMIANS

Introduction to SQL
What is a view?

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

None of these

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.

None of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Indexes can usually be created for both primary and secondary keys.

False

True

ANSWER DOWNLOAD EXAMIANS APP

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

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, country FROM weather, location;

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

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, country FROM weather, location;

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL -92 wildcards are and .

underscore(_); question mark (?)

question mark (?); asterisk (*)

percent sign (%); underscore (_)

asterisk (*); percent sign (%)

underscore(_); question mark (?)

question mark (?); asterisk (*)

percent sign (%); underscore (_)

asterisk (*); percent sign (%)

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following must be enclosed in double quotes?

Column Alias

Dates

Strings

All of these

Column Alias

Dates

Strings

All of these

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following are the five built-in functions provided by SQL?

SUM, AVG, MIN, MAX, NAME

SUM, AVG, MIN, MAX, MULT

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

SUM, AVG, MIN, MAX, MULT

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MULT, DIV, MIN

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL What is a view?

Introduction to SQL Indexes can usually be created for both primary and secondary keys.

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

Introduction to SQL The SQL -92 wildcards are ____ and ____ .

Introduction to SQL Which of the following must be enclosed in double quotes?

Introduction to SQL Which of the following are the five built-in functions provided by SQL?

Introduction to SQL
What is a view?

Introduction to SQL
Indexes can usually be created for both primary and secondary keys.

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

Introduction to SQL
The SQL -92 wildcards are and .

Introduction to SQL
Which of the following must be enclosed in double quotes?

Introduction to SQL
Which of the following are the five built-in functions provided by SQL?